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 |
|
glenn_day
Starting Member
1 Post |
 Posted - 2002-01-21 : 18:54:18
|
| Hi there,Does anyone know of a parser , than can parse stored procedures, functions and views etc, to insert generic performance logging code, and error handling code?Regards Glenngday@tecbuild.com.au |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-01-21 : 19:19:07
|
| Nope - probably exists though.It's not difficult to write a VB app to do something like this though depending on what you want.Performance logging would be easy if you just want to log the start and end time (if you make sure the SP always exits at the end.Error handling is more difficult - it needs to be checked after every statement - how do you know where a statement ends? not so easy.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Stored Procedure Parser