Showing posts with label control. Show all posts
Showing posts with label control. Show all posts

Friday, March 30, 2012

Layout Issue

I have a dataset that goes like this

1

2

3

4

5

6

Using a table control, report preview appears as above.

I want the report to look like

1 2 3

4 5 6

How can I generate a report like this ?

Thanks

Is there any other control I can use to get the desired output.

Thanks !!

Monday, March 19, 2012

Last Modified Date of the Database Object ?

Dear All,
In order to get a version control.
I would like to get the last modified date of the Store Procedure, Table De
finition
I find the the [sysobjects] Table ONLY contains a Create Date.
How can i find it.
Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
Thank you very much
EricLunCurrent versions of SQL Server do not track modifications to objects, only
creation. You will have to track these yourself, or use a third party
product to do so. Your version control strategy, by the way, should not
rely on a feature of the product. In other words, if you were using version
control tools, you should have alter scripts stored in your source control
tool, without having to look at the database (other than to verify that what
is deployed exists in source control, or vice versa).
http://www.aspfaq.com/2495
Yukon will offer DDL triggers, but that's several months away, at least.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"EricLun >" <eric_klyuen@.yahoo.com.hk <no spam pls> wrote in message
news:DCE9AA09-6AF7-4BFD-A576-6D730BD4D79B@.microsoft.com...
quote:

> Dear All,
> In order to get a version control.
> I would like to get the last modified date of the Store Procedure, Table

Definition
quote:

> I find the the [sysobjects] Table ONLY contains a Create Date.
> How can i find it.
> Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
> Thank you very much
> EricLun
|||Thank you very much form your help.

Last Modified Date of the Database Object ?

Dear All,
In order to get a version control.
I would like to get the last modified date of the Store Procedure, Table Definition
I find the the [sysobjects] Table ONLY contains a Create Date.
How can i find it.
Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
Thank you very much
EricLunCurrent versions of SQL Server do not track modifications to objects, only
creation. You will have to track these yourself, or use a third party
product to do so. Your version control strategy, by the way, should not
rely on a feature of the product. In other words, if you were using version
control tools, you should have alter scripts stored in your source control
tool, without having to look at the database (other than to verify that what
is deployed exists in source control, or vice versa).
http://www.aspfaq.com/2495
Yukon will offer DDL triggers, but that's several months away, at least.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"EricLun >" <eric_klyuen@.yahoo.com.hk <no spam pls> wrote in message
news:DCE9AA09-6AF7-4BFD-A576-6D730BD4D79B@.microsoft.com...
> Dear All,
> In order to get a version control.
> I would like to get the last modified date of the Store Procedure, Table
Definition
> I find the the [sysobjects] Table ONLY contains a Create Date.
> How can i find it.
> Do SQL Server remember the [ALTER] and [RECOMPILE] time of these objects
> Thank you very much
> EricLun|||Thank you very much form your help.

Wednesday, March 7, 2012

Large transaction file

I've got some problems to get the transaction files under control.
For example: I have a database wich is 1 gigabyte and the transaction
log is 4.5 gigabyte
Databases are made with automatically growth file enabled en recovery
model set to full. I shrunk the database with the enterprise manager
with truncate free space from the end of the file en shrink file to XX
Mb but the file doesn't get any smaller. I've also disbled auto growth
an enabled auto schrink.
I've set up a maintenance plan wich makes a daily backup of the
database and transaction .log
SQL 2000 SP3
Any idea?
.Peter
Have a look at these articles.
INF: Shrinking the Transaction Log in SQL Server 2000 with
DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-
us;272318
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Hope this helps
John|||Check out below KB articles:
INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650
INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318
http://www.mssqlserver.com/faq/logs-shrinklog.asp
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Peter Taal" <p.taal@.jkz-rkz.nl> wrote in message
news:ac2ff6c9.0309292347.703506cf@.posting.google.com...
> I've got some problems to get the transaction files under control.
> For example: I have a database wich is 1 gigabyte and the transaction
> log is 4.5 gigabyte
> Databases are made with automatically growth file enabled en recovery
> model set to full. I shrunk the database with the enterprise manager
> with truncate free space from the end of the file en shrink file to XX
> Mb but the file doesn't get any smaller. I've also disbled auto growth
> an enabled auto schrink.
> I've set up a maintenance plan wich makes a daily backup of the
> database and transaction .log
> SQL 2000 SP3
> Any idea?
> .|||Peter:
I had the same problem last week with a vendor supplied
database. Transaction log was 12.5 GB 3X the size of the
database. No matter how I tried I could not shrink the
log file to the desire size of 1 GB. Of course I
researched the problem and after some time it hit me.
First I said, talking to myself, why and how did this
stupid file get so large in the first place. Because of
the property settings for the data files of course. I
check the property settings for the data and log files and
found that the vendor had set the unrestricted growth at
10% for both files. I changed this to growth to my
desired size in MB so that I would uniformed growth.
After making this change I was then able to shrink any of
the files I wanted to the desired size.
Hope this will help you as well.
Thomas
>--Original Message--
>I've got some problems to get the transaction files under
control.
>For example: I have a database wich is 1 gigabyte and the
transaction
>log is 4.5 gigabyte
>Databases are made with automatically growth file enabled
en recovery
>model set to full. I shrunk the database with the
enterprise manager
>with truncate free space from the end of the file en
shrink file to XX
>Mb but the file doesn't get any smaller. I've also
disbled auto growth
>an enabled auto schrink.
>I've set up a maintenance plan wich makes a daily backup
of the
>database and transaction .log
>SQL 2000 SP3
>Any idea?
>..
>.
>