JestersGrind (11/23/2011)
Archie,You are correct. That was an over sight on my part. I didn't test it with SQL 2000. The question should have stated that this was for SQL 2005 and higher. My apologies.
Thanks,
Greg
Though it was not stated, we should consider the question to be on current database engine unless otherwise specified. 2000 is quite old and if we are posting a question relative to 2000 then we should explicitly state that it is for 2000. In other words, I don't think it was an oversight.:-D
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