Sudhir Dwivedi (9/22/2011)
But still I think you should have added the versions of SQL Servers as In SQL 7.0 it's not a True case.
Maybe so, but given that SQL 7 is many years out of support and that you can't download it from MSDN - it would be a stretch for the question to be based on it.
It is one of those cases where it is safe to bet that the question is about the current release or within the past 2 releases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events