Hi

I need to view a log of all SQL scripts that were RUN in Sequel Server.
Is It possible to view some type of a log, which will show me the script
as well as when it was run.

Many Thanks
AQ



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Retroactively, no. Going forward, you can use SQL Server Profiler to catch
scripts as they run.

Look up SQL Profiler in Books Online for information about how to use the
tool.


"AQ Mahomed" <aq786 (AT) shoecrazy (DOT) co.za> wrote

Hi,

You can get the object creation date from sysobjects system table.

use dbname
go
select substring(name,1,35) as Object_name,type as Object_type,crdate from
sysobjects


Description for Object_type displayed in the above query
----------------------------------------------------------
C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
IF = Inlined table-function
P = Stored procedure
PK = PRIMARY KEY constraint (type is K)
RF = Replication filter stored procedure
S = System table
TF = Table function
TR = Trigger
U = User table
UQ = UNIQUE constraint (type is K)
V = View
X = Extended stored procedure


Thanks
Hari
MCDBA

"AQ Mahomed" <aq786 (AT) shoecrazy (DOT) co.za> wrote