Tuesday, September 26, 2006
saAction
i know before this that we can debug all sql query and all kind of transction in sql server 2000 and 2005, but i don't know how to do this today i found some details about this.
We can debug every transction of sql server.
all this tool are avalable in 'Binn' folder of the sql server directory. like:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
these are important tools. suppose you are working in front end application and you want to know that which query fire to sql server you can show it.
We can debug every transction of sql server.
all this tool are avalable in 'Binn' folder of the sql server directory. like:
C:\Program Files\Microsoft SQL Server\80\Tools\Binn
- Start sql server from run : sqlservr.exe
- Start sql server query analyzer from run : isqlw.exe
- Monitoring with SQL Profiler : profiler.exe
- show chart view for sql server from : Administrative Tools/Performance
these are important tools. suppose you are working in front end application and you want to know that which query fire to sql server you can show it.
Posted in
0 comments :
Post a Comment