April 5, 2007 at 7:04 am
Would it be possible to create an agent alert that will notify me whenever a new object has been created?
We have an environment that is a bit unfortunate. I'm in the process of securing our servers but it will take some time and until then nearly everyone has sa password. Mysteriously, new items appear all the time even though it is against our policy.
April 5, 2007 at 7:26 am
No way I know of to set an alert on this.
What I've done is store the object list in a table and then run a job to compare current objects to this list every day (or twice a day) and email me differences.
http://qa.sqlservercentral.com/columnists/sjones/20010423065956_1.asp
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
April 6, 2007 at 8:06 am
With SQL 2005 you can easily implement a DDL-Trigger in the database.
like
CREATE TRIGGER log_ddl_statements
ON Database
FOR ALL_DDL_STATEMENTS
AS
"Code for raiserror with log and log into table"
AW
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
April 9, 2007 at 2:22 pm
I went through this a while back when I found out (for the second or third time) that once anyone in the development group has the sa password for any reason, they all have it. When I found the most clueless developers had servers registered in Enterprise Manager with the sa login/password (and never used anything else), I told the boss I was going to change it and he backed me up. There was a bunch of whining, and things broke for a while until they tracked down everywhere they had embedded the sa login, but there was no other way to get them to quit using it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply