Urg sorry; that wouldn't work because the function returns a table which was not supported in SQL 2000.
You can run that query in a database that is 90 and it will return the SQL Statements to you. Please note this is instance wide and not database based.
When I run it on masters database I don't just get master database statements I get statements from all server statements.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]