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 |
|
cwalston
Starting Member
25 Posts |
 Posted - 2006-02-08 : 11:49:30
|
| Coming from the Sybase world...is there a way in osql that you can do something like exec sp_showplan <spid> to get the showplan info for a current process?I am trying to setup something that will be able to be automatically run to capture bad queries and then log them back to a log file.Thanks!Chris |
|
|
romank
Starting Member
2 Posts |
Posted - 2006-02-08 : 15:12:53
|
| Hi Chris,You can use Profiler to capture all queries..However, it could be costly on server resources...Regards,Roman |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Quick showplan question