I'm not sure, check it custom reports in sqlserver 2005 and above version

Thanks & Regards

Balaji.G

I need more informations for this issue..

1.Application's slow frequently or rarely

2.If frequently means.. Did you check the cpu usage or not

3. did you run the profiler or not?

4. if you...

Dear Siva,

Thanks for your great and timely help.. Its working fine..

Thanks & Regards

Balaji.G

Hi Siva,

select 'insert into sam(Id,Name,type,Email,Versionnumber)

values(' + ""id""+','+""Name""+','+ ""type""+','+""Email""+','+""Versionnumber""+ ')'

from sam

when i ran the above query.. the following error occurred

cannot use empty objects or column names.Use a single space if necessary..

then...

Hi,

I used + symbol in front of the column name.. its error occurred. Any other alternate solution is there? or else.. any tool is...

Hi Henri,

Shall i use in this way..

insert into db1.dbo.tab1 (col1,col2,col3) values (select col1,col2,col3 from tab1 where col1

COLLATE Latin1_General_CI_AS

not in(select col1 from tab1 where col1 is...

Hi Ashish

I'm asking about sqlserver 2000 production database..

My database size is : 14GB

Thanks

Regards

Balaji.G

Thanks..

I have one more question like if i shrink a database. afterwards

what are the other steps to be...

Hi,

you need find out, if any blocks occurred in your database

use master

...

Thanks for all your valuable comments

Regards

Balaji.G

Some of the unnecessary objects are available in our database.

So that only i would delete those objects and shrink a database

Some of the objects are heap.There is no constraint. I...

while execute the query or sp, some times timeout expired came.

I have checked the fragmentation.. Some of the objects are heavily fragmented

Most of the objects are not upto date.

More Space...

Hi,

when you take copy only backup. The Log Sequence number doesn't change it. and

i think...