Which system trigger fires?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Which system trigger fires?

Which system trigger fires?

Rate Topic

Display Mode

Topic Options

Author

Message

Aadhar Joshi

Posted Sunday, December 09, 2012 9:27 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:01 PM
Points: 1,044, Visits: 226

When system trigger fires when we use below code

sp_configure 'show advanced options',1
GO
RECONFIGURE
GO

i need to write insted of triggers on that

Post #1394440

GilaMonster

Posted Monday, December 10, 2012 1:30 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:08 AM
Points: 37,639, Visits: 29,893

There's no system triggers on the configurations view, and I doubt you can write triggers on a system view, even if you can, you should not.

What are you trying to do here?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1394477

Aadhar Joshi

Posted Monday, December 10, 2012 3:00 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:01 PM
Points: 1,044, Visits: 226

Thanks GilaMonster,

Actually i need to create trigger through which i can track every change happen in sys.configurations so later on i should know what value has changed of what attribute..

I searched many things but i am clueless. please help.

Post #1394509

GilaMonster

Posted Monday, December 10, 2012 4:16 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 11:08 AM
Points: 37,639, Visits: 29,893

Nope, that's not something you'd use a trigger for. That's something you'd probably use an extended events sessions for, or SQL Trace if you're using SQL 2005 or below.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1394535

Aadhar Joshi

Posted Monday, December 10, 2012 4:38 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 10:01 PM
Points: 1,044, Visits: 226

I'm using sql server 2008 r2.

I will check possible solutions as u mentioned tip..
anything that would help me more, please suggest..

Post #1394543

GSquared

Posted Monday, December 10, 2012 6:58 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:09 PM
Points: 15,439, Visits: 9,569

Here's a list of what you can track with triggers (DDL triggers, to be precise): http://msdn.microsoft.com/en-us/library/ms189871(v=SQL.90).aspx

Here's some data on Extended Events: http://msdn.microsoft.com/en-us/library/bb630354(v=SQL.105).aspx

As Gail mentioned, Extended Events are probably what you're looking for. But you might be able to get some use out of DDL triggers. Depends on what all you want to track.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Post #1394593

« Prev Topic | Next Topic »

Permissions