February 10, 2010 at 10:59 am
Hi,
Can someone help me in creating a job to get alerts for any changes in settings in sql server?
Thanks,
February 10, 2010 at 11:08 am
I think for this the best way would be to use Policy Based management. With this you can set it up to prevent or notify.
Just my 2 cents
-Roy
February 10, 2010 at 11:19 am
Hi Roy,
Thanx for your reply. Is there any other way we can do this in 2000 and 2005 versions of sql server?
February 10, 2010 at 11:35 am
Ah Sorry. I thought you were asking about SQL 2008. I did not look which forum it was. My apologies.
I do not know any other way other than database triggers. I think you can use it only in SQL 2005 and onwards. Check this article out to get an idea regarding it.
http://www.sqlservercentral.com/articles/SQL+Server+2005+-+Security/2927/
-Roy
February 12, 2010 at 3:50 pm
Thank you Roy!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply