Post reply

How to identify the ip address for who created object in sql server 2008 database..?

  • December 14, 2011 at 2:09 am

    #251964

    How to identity ip address for who created object in sql server 2008 database..?

  • December 14, 2011 at 2:11 am

    #1421103

    I need either Domain id or ip address..?

  • December 14, 2011 at 2:18 am

    #1421108

    If the object is already created, I'm afraid that information is lost already. However, for new objects you may implement DDL Triggers or Event Notification. DDL Triggers are the most easy to implement and can roll back changes, wheres event notification also can be used to log for instance user login.


    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]

  • December 14, 2011 at 2:18 am

    #1421107

    If it’s an academic question then answer is Triggers.

    Else DON’T do it. Why do you want to track IP addresses? The one who modified the objects is not sufficient to you?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply