I created a trigger on server to capture the database roles. I want to capture the database roles on all the server but not on a database called "AAA". Can we do that ???
Jan 10 at 09:12 PM
Forgive me, just to clarify you created a server level trigger to track database role events? Can you post your code by chance?
code was too long Sorry, I don't know how to post that here in comment as its too long in Characters
Try using pastebin.com or something similar and then post a link back to it.
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Jan 10 at 09:12 PM
Seen: 48 times
Last Updated: Jan 12 at 01:28 PM
Reporting Database recommendation
SQL 2008 - Suspended - ASYNC_NETWORK_IO
full text search has changed in sql server 2008
Error 6513 Failed to initialize the CLR due to memory pressure
How to upgrade SQL express 2005 to SQL express 2008 in Windows 7 64 bit machine
sql query for data
Differences between TRUNCATE and DELETE for a table ?
How to tell if database is growing
Multiple counts with multiple tables.