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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-24 : 07:49:10
|
| shreeman narayana writes "i want to have a profiler(sql) of my own.what i did is i took the spid from sp_who,the issued command against spid from dbcc inputbuffer and then concat it with the hostname(),hostid() etc and the insert the result into a table and to a text file using xp_cmdcell .now when i used this and defined it on a table by using trigger what i found is though i am getting all the commands it are not properly ordered i..e; the results are not coming against the respective spid i..e;for the spid and hostname the proper command issued by them are not shown.i also have only 255 character for dbcc inputbuffer.i again tried this using fn_get_sql but the help in microsoft.com regarding fn_get_sql is not enough forme to accomplish my task.reqd help as soon as possible.,shreemansndshreeman@rediffmail.com" |
|
|
|
|
|
own profiler