Thanks for the Reply Mike.

My problem is that i have an .mdf and .ldf file and since I am not able to attach that i cant check the version or...

Thanks to All

Thanks for the reply

I checked the getdate and its showing current time and i got event in SQL Server log when i run DBCC CHECKDB.

I have run some update...

Thanks Lynn Pettis

Can you pleae tell how much is the normal CPU and memory utilisation of SQL Server if the RAM is 4GB.

(like it requires minimum of 30% CPU and...

Thanks Grant

Dont go for Restart if u are in production environment.Try shrinking the tempdb. Kill those connection from that application and investigate on the query which is causing this problem.

For a DBA you dont need to know any tools for administration. Tools reduce ur work load so its ur choice to go for Tools or use SQL Server features.

I am with Ffalcon.Try shrinking database and log files.

http://msdn.microsoft.com/en-us/library/ms190488.aspx.

My question is that if u dont have enough space in backup disk then how will u take backup of user databases??

If...

We have SQL Server 2005 SP3 available

check this

http://www.microsoft.com/Downloads/details.aspx?familyid=AE7387C3-348C-4FAA-8AE5-949FDFBE59C4&displaylang=en

Please help in this issue

How can i execute the same for a particular column.I want to convert all the the values in that particular coulmn

Thanks for the quick reply...

Can i use that column name.I want to convert all the values from that column..

Go for transactional replication

Gila,

When i ran trace against a database accessing an application its not showing any result but when i click a...

still the same result :-(..