Hi,

Please post complete erorr messages. As this will help to find out any other issues also.

Duplicate post. Please post your replies at http://www.sqlservercentral.com/Forums/Topic760489-146-1.aspx

Did you check the log file?

Duplicate post. Please post your replies at http://www.sqlservercentral.com/Forums/Topic760489-146-1.aspx

Duplicate post. Please post your replies at http://www.sqlservercentral.com/Forums/Topic760489-146-1.aspx

Hi Vishal,

I am surprised that without root cause analysis you used dbcc with allow data loss and that too in production. Can you post the...

Hi Pradeep,

Can you tell me on how to do that in 2000.

Hi,

Thanks a lot Jeff and Lynn. It worked very well.

Hi,

Beside index seek and index scan there are other factors that influence the query. You have to checkout the I/O,cpu and other things to point out the...

Hi Jeff,

Thanks a lot for providing the solution. I will check it and revert back to you.

Hi,

Please post table script and sample data and query execution plans so that we can look into this further.

Hi Friends,

I got this from one of my old friend who is a developer. I dont have the exact structure at the time...

Hi Lucky,

Do you want only database engine or reporting services also. If you want only database engine you can ignore that warning. If you want reporting...

Use this command

select serverproperty('ProductLevel')

This is better when compared to select @@version

google for sp_Msforeachdb. It will definitely help you.