Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 profiler

Author  Topic 

NeilG
Aged Yak Warrior

530 Posts

Posted - 2010-01-15 : 08:58:17
I looking at carrying out a profiler trace against a sql server 2000 instance, but was wondering if there is a problem with using the sql server 2005 profiler to do this.

Just really because it has more options

-----------------------------------------------
Learning something new on SQL Server everyday.

Kristen
Test

22859 Posts

Posted - 2010-01-15 : 09:16:25
I don't think the "more options" will help you if SQL 2000 isn't shipping the data to support them

Never tried it, I've always stuck with the 2000 profiler against SQL 200 databases / servers.

What are you particularly after in the SQL 2005 profilers ?
Go to Top of Page

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-15 : 12:50:55
profiler 2005 works fine against sql 2000. as Kristen said, it only supports what sql 2000 exposes though.
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2010-01-15 : 13:05:17
Thanks Russell, I'll keep that in mind. Bound to come up with a need for it sooner or later!
Go to Top of Page
   

- Advertisement -