Post reply

Find connects to the linked server on a sql2012 server

  • December 4, 2014 at 11:05 am

    #313529

    I need find any servers, programs or db that connect to a specific linked server on a sql2012 server. the linked server is connect to Oracle from this SQL server.

  • December 4, 2014 at 12:51 pm

    #1762810

    for code within SQL server,it's actually pretty easy.

    there's a view that contains all references, but you have to run this command in every database:

    select *

    from sys.sql_expression_dependencies sed

    where sed.referenced_server_name is not null

    --and sed.referenced_server_name='MyOracle' ??

    for programs and otehr stuff:

    you have to open the projects/code of the programs, and string search for the string in question...much harder to do, but that's what I've had to do before...searching .vb, .cs ,.dbml,dtsx, files etc

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 1 (of 1 total)

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