No one has the answer for my doubts 😉

http://technet.microsoft.com/en-us/library/ms191539.aspx

You can access data of old version in new version. That is you can access data of SQL 2000 in SQL 2008

Thanks Gila monster,

I dont know for what they are asking about. But I have below statement from the monitoring agent.

"The average amount of wait time (milliseconds) for each lock request...

Hello Leonard,

I used Central mangement Server and have added 20 SQL servers of the same domain in the group, some of them are of sql server 2005 and around 3...

hmm I read it. It requires some powershell script that will pull evalulution output and insert into one sql table and than we can pull the report frm that table....

Grant.. Its perfect one..! Thanks a lot.

I tried PBM on one server and see result. Now the last point, Can I automate this task ? Can I automatically export the...

Hello Grant,

Can you please describe me in detail how to use "Policy based management" to pull report for backup failed databases. ?

Thanks a lot Derek and Leonard,

Can you please gimme some URL to get step by step guide for linked server ? Or any URL to get aware of central server...

Thanks a lot George..!!

But my most of the SQL Server are SQL Server 2005 and SQL Server 2008.

Hello Gila Monster,

Can you please help me ?

I did not recieve any reply from other masters. 😉

Thanks a lot guys!

Special thanks to Ed, Jacob and Chris, and let me tell you the culprit was the SP with odd codding. Now our client accepted this truth that...

I am using SQL 2005 not SQL server 2012. Moreover, I shrinked as much as I can. At last after clients approval we have restarted services and it clears the...

Thanks Ed and Voide,

@Voide: You are right, I found one SP which seems to be culprit, its runnig from long time , but not blocking anything. Might it...

Thanks a lot to all Masters for guiding me!

I went through URL's given by you all and used below query to find out how much disk space tempDB has and...