Re: Method to Determine the last time an SP was executed?

Article View: alt.comp.databases

Article #66

Back to alt.comp.databases Previous Next

#66

From: Ben McEwan
Date: Sat, 18 Apr 1998 00:00

17 lines
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

Technical Details

Message-ID: <MPG.fa29bd5393f19f5989769@news.global2000.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <MPG.f9ea277ec242ea8989683@news.earthlink.net>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104de1,6e4dd43b0f7cd6f6
X-Google-Attributes: gid104de1,public
X-Google-Thread: f6611,6e4dd43b0f7cd6f6
X-Google-Attributes: gidf6611,public
X-Google-Thread: 10f2ae,6e4dd43b0f7cd6f6
X-Google-Attributes: gid10f2ae,public
X-Google-Thread: fc5c9,6e4dd43b0f7cd6f6
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: 10a90d,6e4dd43b0f7cd6f6
X-Google-Attributes: gid10a90d,public
From: bmcewan@global2000.ANTISPAM.com (Ben McEwan)
Subject: Re: Method to Determine the last time an SP was executed?
Date: 1998/04/18
Message-ID: <MPG.fa29bd5393f19f5989769@news.global2000.net>
X-Deja-AN: 345395977
References: <MPG.f9ea277ec242ea8989683@news.earthlink.net>
Reply-To: bmcewan@global2000.ANTISPAM.net
Organization: Geist, LLC
Newsgroups: alt.comp.databases,bit.databases.mssql-l,comp.data.administration,comp.databases,comp.databases.ms-sqlserver

Reply to Parent Message