I executed this command

DBCC CHECKDB('AlarmSwitch') WITH NO_INFOMSGS

It took about 3 minutes and then I got message 'Command(s) completed successfully.'

Its mean there is no problem with my DB. Am...

Thanks for your prompt reply

I understand that in SQL Server 2005 we can't update it but because we have migrated our application from SQL Server 2000 to 2005 and in...

Through some how I want to change system catalog (syscolumns table)

In syscolumns table there is a column "colid" I want to change the value of this colid. Why I want...

Its mean then I should now be worried about it

Thanks

Hanslindgren:

I am just wondering that after 8 days these connection are still sleeping and might consume some resources. You think it is right behaviour of my SQL Server or my...

When I check in Activity Monitor of SQL Server 2005 I also see few connections in sleeping status. I understand if C#.NET application is using Pooling, for performance reason SQL...