[Tutorial] Log queries using SQL Profiler

[Zombe]

Because the A9 was leaked, I figured it would come useful for people to figure out how the server communicates with the db, since the new db structure is probably a lot different.

It's quite easy, first start up SQL Profiler, it comes with MSSQL 2000.
Select new trace, select your server, login to it.
Go to events tab, add Objects, Stored procedures and TSQL, keep Sessions and Security Audit in there.
Click Run, you should see your trace started.

To test it, go to Query Analyzer and run some query, you should see it come up on your trace.

You can use this to compare the A2 and A9 server queries, this will help a lot with upgrading the current db.

[guesswho-.-]

thank you zomberd

[Zektor]

Originally Posted by Zombe

Because the A9 was leaked, I figured it would come useful for people to figure out how the server communicates with the db, since the new db structure is probably a lot different.

It's quite easy, first start up SQL Profiler, it comes with MSSQL 2000.
Select new trace, select your server, login to it.
Go to events tab, add Objects, Stored procedures and TSQL, keep Sessions and Security Audit in there.
Click Run, you should see your trace started.

To test it, go to Query Analyzer and run some query, you should see it come up on your trace.

You can use this to compare the A2 and A9 server queries, this will help a lot with upgrading the current db.

I remember seeing a thread similar to this posted by Janvier. Could have just bumped that one.

[janvier123]

too lazy to search

[Zombe]

Originally Posted by janvier123

too lazy to search

Didn't see that. I actually searched "profiler" before posting this, didn't come up with any relevant results, you can try it. Blame the epvp search engine :P

[janvier123]

i know