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.
| Author |
Topic |
|
JeffK95z
Starting Member
19 Posts |
 Posted - 2007-03-26 : 20:50:01
|
Hi all, I have a home grown solution in place for all of our SQL 2000 servers... They get imported into another management sql 2000 box.My problem is that we now have several SQL 2005 boxes. I have just finishing migrating my dts packages to SSIS (a fun way to learn SSIS!).It turns out, I can't read a 2005 trace file, from a 2000 server. here are my findings: - SQL Server 2000 fn_trace_gettable DOES NOT read SQL Server 2005 trc files
- SQL Server 2005 fn_trace_gettable DOES read SQL Server 2000 trc files
Can anyone else confirm this, or even better, tell me what i'm doing wrong?Thanks!!Jeff |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-27 : 00:57:45
|
| Yes, you can't open the 2005 trace files using 2000 profiler or fn_trace_gettable procedure where as you can opne 2000 trace in 2005 profiler and with fn_trace_gettable procedure too...MohammedU |
 |
|
|
|
|
|
select from ::fn_trace_gettable help