locked
how we can keep track of server activities in slq server RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi

    i have dought that some of my linked server have been deleted from two days earlier. now due to huge listing of linked server in my server i am unable to point out which linked servers i have lost. as we dont have any provision of finding this by going to flashback like ORACLE, So this is a serious issue with this.

    Can you please suggest how can we keep eye on these types of activities,

    can we write any Server level trigger on these types of activities or let me know if any other provision we can can keep track of these types of activities??????????????????

    can we have any Trigger or any other option susing which i can cath the user Activities on sql server,

    suppose in my case if i want to track the user who deleted/Edited my server level things like Linked server/Database indexes etc.

    please guide , your ASSISTANCE IS HIGHLY APPRECIABLE

    • Edited by Shanu_Shri Friday, April 29, 2011 9:11 AM
    Wednesday, April 20, 2011 8:47 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote
    A DDL trigger or Event Notification should be able to log these events. I would go for Event Notification, and if that for some reason don't cut it to DDL trigger. And, if you are on SQL Server 2008 and Enterprise Edition or higher, consider the new Server Audit functionality.
    Tibor Karaszi, SQL Server MVP | web | blog
    Wednesday, April 20, 2011 9:03 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Here is a nice article for finding the details of the linked server

    http://support.microsoft.com/kb/203638

    Thanks and regards, Rishabh
    Wednesday, April 20, 2011 8:50 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    A DDL trigger or Event Notification should be able to log these events. I would go for Event Notification, and if that for some reason don't cut it to DDL trigger. And, if you are on SQL Server 2008 and Enterprise Edition or higher, consider the new Server Audit functionality.
    Tibor Karaszi, SQL Server MVP | web | blog
    Wednesday, April 20, 2011 9:03 AM
  • Question
    Sign in to vote
    2
    Sign in to vote
    Amitesh,
    I already replied to this on your another thread

    http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/0896f125-e75e-4734-b1bf-95697f59dbf5
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Wednesday, April 20, 2011 9:26 AM