We're using sql server 2005 and already used the following sql to change the permission of one system extended store proc in production:
deny execute on sp_replwritetovarbin to public
Is there any log event to indicate the time of issueing the above sql?
Thanks and regards,
check from below cmd
select * from sys.all_objects where type='p'
Please click the Mark as answer button and vote as helpful if this reply solves your problem
I have select from sys.allobjects but the modified time column is same as create time column and cannot reflect the actual modified time
- Marked as answer by Chan Wai Yin Friday, December 27, 2013 1:11 PM