Linked server creator

Posted on 2011-10-12
Last Modified: 2013-11-05

I've noticed a new linked server on one of our databases and am trying to find out who created it.

Is there a way to determine the username of the creator?

Question by:tdbj
    LVL 17

    Assisted Solution

    As far as I know, linked server information is kept in sys.servers table and it does not record who created the linked server.
    LVL 59

    Accepted Solution


    Unless you are auditing specific actions in SQL Server, I cannot think of a way to determine WHO created a specific Linked Server; however, here are some thoughts that may help.

    First, if you have not explicitly granted separate permissions to individuals to create linked servers, the culprit is one of the DBAs you have entrusted with sysadmin privileges; therefore, read through and you will find some scripts to determine which users are sysadmins and/or what permissions your users have specific to server-level access.

    Second, you can use the System view sys.servers to at least get the last modified date of the Linked Server. Given there is not much to change after a Linked Server has been established, my experience is that the modified date is analogous to the creation date.
    SELECT [name], [modify_date]
    FROM sys.servers

    Open in new window

    If you are auditing logins, you can get the last login time of each user. Short of this, you can just match up the time frame with the sysadmin who was around at that time -- hopefully it filters the list.

    Hope that helps!


    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Viewers will learn how the fundamental information of how to create a table.

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now