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 |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
 Posted - 2008-07-07 : 07:36:35
|
| I want to store log of mine 5 store procedures against heavy work load. This log will give me output like [When it is called, which all are the parameters etc..]I dont want to run profiler...Is there any other way???-- RegardsPrashant Hirani |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-07 : 07:56:25
|
| You could add a line of code (into the sp) which logs this information into a table - of course this would add some workloadJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-07-07 : 07:58:15
|
| NOt getting you... |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-07 : 08:07:45
|
| Create a log table , with all the relevant columns. Insert a line of code within your stored procedure , e.g an INSERT statement that takes the relevant information that you need to store such as "name of sp" , "date" , "parameters" etc .Every the sp runs it will create a log record in your log table. Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
|
|
|
Store Procedure Log Write