Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Monitoring and Recording DDL changes on SQL 2005 (NARC) Expand / Collapse
Author
Message
Posted Tuesday, October 14, 2008 7:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:20 AM
Points: 24, Visits: 295
I love this article:
http://www.sqlservercentral.com/articles/Auditing/64176/

However, I would like to know how do you audit sp_rename?

Or to most DBAs this isn't important.
Post #585416
Posted Wednesday, July 07, 2010 12:47 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:15 PM
Points: 42, Visits: 177
Look here for a full solution: http://www.sqlservercentral.com/Forums/Topic948331-149-1.aspx
Post #948338
Posted Monday, December 06, 2010 6:18 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 31, 2014 9:20 AM
Points: 24, Visits: 295
I am looking for this page
http://www.sqlservercentral.com/Forums/Topic948331-149-1.aspx

What happened to it?
Post #1030555
Posted Monday, December 06, 2010 6:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:15 PM
Points: 42, Visits: 177
You can see an alternative "article" I wrote for this at:

http://www.sqlservercentral.com/Forums/Topic947481-391-1.aspx
Post #1030581
Posted Monday, September 26, 2011 4:54 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, March 21, 2014 6:16 AM
Points: 126, Visits: 361
How are you guys handling when the server trigger kicks off when a user is in the dbcreator role but doesn't have access to insert into the table that houses all the ddl trigger events? Thks!
Post #1181425
Posted Wednesday, September 28, 2011 3:39 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, March 20, 2014 1:15 PM
Points: 42, Visits: 177
create trigger ServerAuditTrigger
on all server
-- Audit server level and database level into dbadata.dbo.ServerAudit
-- The database level is also audited into <database>.dbo.DatabaseAudit
with execute as ''server_audit''for ddl_events
Post #1182300
Posted Thursday, October 18, 2012 10:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 14, 2013 10:27 AM
Points: 1, Visits: 13
@fracionero (5/6/2008)

My insert command:

INSERT INTO [SRSQL1001\MANAGEMENT].[DBA_AUDIT].[dbo].[ENV_SRV_INS_DB_CHG]
([ENV_SRV_INS_DB_CHG_Server]
,[ENV_SRV_INS_DB_CHG_Name]
,[ENV_SRV_INS_DB_CHG_EventType]
,[ENV_SRV_INS_DB_CHG_PostTime]
,[ENV_SRV_INS_DB_CHG_Login]
,[ENV_SRV_INS_DB_CHG_TSQLCommand]
,[ENV_SRV_INS_DB_CHG_Completed])
values(@ServerName,@DBName,@EventType,@PostTime,@login,@TSQLCommand,@comp)

errors set

Msg 3984, Level 16, State 1, Line 1
Cannot acquire a database lock during a transaction change.
Msg 3985, Level 16, State 2, Line 1
An error occurred during the changing of transaction context. This is usually caused by low memory in the system. Try to free up more memory.
Msg 3984, Level 16, State 1, Line 1
Cannot acquire a database lock during a transaction change.
Msg 3985, Level 16, State 1, Line 1
An error occurred during the changing of transaction context. This is usually caused by low memory in the system. Try to free up more memory.


I have checked if I delete insert command database is created without errors.

Thanks in advance for your help

F.Racionero


Has anyone figured out a solution to this? My trigger record is being inserted into the other server, but I sill get these error messages.

Thanks!
JMB
Post #1374489
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse