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 |
|
olspookishmagus
Starting Member
4 Posts |
 Posted - 2013-12-09 : 08:53:04
|
| Hello everyone.I was wondering on:Which was the last ClearTrace version to fully support SQL Server 2000?Thanks in advance. |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2013-12-09 : 17:41:42
|
| ClearTrace 2008 should read SQL Server 2000 trace files. ClearTrace 2012 may read them. I've never tested it and I'm not sure SMO will go back three versions.http://www.scalesql.com/cleartrace/download.aspx=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
 |
|
|
olspookishmagus
Starting Member
4 Posts |
Posted - 2013-12-10 : 02:53:11
|
| Well, I could read that from the download page, but thanks for your contribution anyway.Point is that ClearTrace 2008 would require something among: SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2, to be installed; which is not available.If there will be some answer specifying the last compatible version with SQL Server 2000, or for all future obsolete SQL Server versions, it would be nice FAQ material. |
|
|
|
olspookishmagus
Starting Member
4 Posts |
Posted - 2013-12-10 : 03:04:40
|
Oh, I see what you meant with your last sentence.Quoting from SQL Server Management Objects (Wikipedia):quote:
SMO objects come with SQL Server 2005, and are included in the Express version.
So I guess if ClearTrace begun with SQL Server 2005 (and it's SMO), inquiring for whether there was ever full SQL Server 2000 compatibility, is eligible material for a dbareactions gif. Hope I don't make it there.Pardon me. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2013-12-11 : 00:26:54
|
| I think I better see what you're asking. You need something with SMO installed to read the trace. That would be 2005 or higher. But it will read 2000 traces. If you only have 2000 I'd look for a utility called Read80Trace from Microsoft. That does the basis of what my utility does.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
olspookishmagus
Starting Member
4 Posts |
Posted - 2013-12-11 : 15:09:32
|
| Well, I'm kind of moving forward on this topic, and I will come back with a full post with my findings.Seems SMO it's not totally incompatible with SQL Server 2000, but I wouldn't like 'monologuing' in this thread so I kept back until there were some responses.Thanks graz, for your answer, I was actually trying to locate your e-mail address before posting this thread - so I'd appreciate it if you PM'ed me that. |
|
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2013-12-12 : 16:09:57
|
| Actually I'd prefer to have the discussion here. That way others benefit from whatever we discuss. If you really want to email me it's just my username at this domain. But I'd prefer any discussion take place here.And I should clarify something. There never was a version of ClearTrace that *fully* supported SQL Server 2000. There were some versions that could read those trace files but that was it.=================================================Creating tomorrow's legacy systems today. One crisis at a time. |
|
|
|
|
|
|
|
|
Last ClearTrace version to support SQL Server 2000