Thread View: alt.comp.databases
2 messages
2 total messages
Started by Glenn R. Kurban
Wed, 15 Apr 1998 00:00
Method to Determine the last time an SP was executed?
Author: Glenn R. Kurban
Date: Wed, 15 Apr 1998 00:00
Date: Wed, 15 Apr 1998 00:00
7 lines
1116 bytes
1116 bytes
Is there any way to determine when a user-created (or otherwise) Stored Procedure was executed?...Does such a function exist in SQL Server 6.5? My inclination is to say No. However, if anyone knows otherwise I would be greatly interested. Thanks. Glenn K.
Re: Method to Determine the last time an SP was executed?
Author: Ben McEwan
Date: Sat, 18 Apr 1998 00:00
Date: Sat, 18 Apr 1998 00:00
17 lines
1560 bytes
1560 bytes
In article <MPG.f9ea277ec242ea8989683@news.earthlink.net>, gkurban@earthlink.net says... > Is there any way to determine when a user-created (or otherwise) Stored > Procedure was executed?...Does such a function exist in SQL Server 6.5? > My inclination is to say No. However, if anyone knows otherwise I would > be greatly interested. Thanks. AFAIK, there is no way to tell. Of course, you could always put something in the procedures, themselves. A simple insert to a separate audit table with user name, datetime, procname would suffice. -- Ben McEwan, President, Geist, LLC bmcewan@global2000. -ANTISPAM- .net
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads