Tagged Questions
0
votes
0answers
46 views
SQL Server 2000 Trace Template for SQL Server 2008 R2 Upgrade Advisor
My current database is SQL Server 2008 R2 with compatibility level 80 (SQL Server 2000). I need to upgrade compatibility level to 100 (SQL Server 2008/R2). I have installed SQL Server 2000 Enterprise ...
0
votes
1answer
170 views
Running a sql server Trace of 1 GB using sqlcmd
I am load testing two sql server instances. I have a trace file from sql server 2000 database with a file size of little less than 1 GB. I am running this using the sqlcmd utility and it is been ...
0
votes
1answer
104 views
sql 2000 trace : sp_releaseschemalock
For a SQL 2000 server, is it bad to see too many
exec sp_releaseschemalock 1
events in a SQL trace file?
