I am assuming only that you are asking about job execution history?

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1148570,00.html

Sorry to add some confusion to the discussion, but...

It is absolutely unclear for me what is it that author was trying to achieve in his comparison?

Reading the second sentence I...

Since it is unclear from your posting what are you looking for, the short answer is: master.dbo.sysprocesses

Management views appeared in SQL 2005 and were not arounf in SQL 2000.

Can you please add the parameters and settings on your tempdb? Could it be linked to the fact that you are simply hitting an "auto grow" of your tempdb during...

TRY ... CATCH catches all the errors with a severity greater than 10 at execution.

That means that syntacs erors will not be captured. Your "sp" contains several (like missed operand...

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=62887&SiteID=1

Excerpt from the article:

"When running 4 part reference query like this:

select * from sql2000.mybase.dbo.mytable

SQL Server 2005 x64 runs the following query on remote SQL2000 server:

exec [mybase]..sp_tables_info_rowset_64 N'mytable', N'dbo',...

Very basic article. Even so it is explained in the article header, I would like to add that linked servers were available from SQL 7(or 6.5?) and did not change...