Post reply

Can I connect another SQL Server DB without add Linked Server?

  • May 7, 2012 at 3:31 am

    #273587

    Can I connect another SQL Server DB without add Linked Server?

  • May 7, 2012 at 3:38 am

    #1484010

    Try OPENROWSET/OPENDATASOURCE

  • May 7, 2012 at 7:59 am

    #1484069

    a couple of basic examples:

    --connect via trusted connection using your domain credentials

    SELECT *

    FROM OPENROWSET('SQLOLEDB','Server=yourservernamehere;Trusted_Connection=Yes;Database=Master',

    'Set FmtOnly OFF; SELECT * from sys.tables')

    --connect via SQL username/password

    SELECT *

    FROM OPENROWSET('SQLOLEDB','Server=DEV223;Trusted_Connection=No;UID=Noobie;Pwd=NotARealPassword;Database=Master',

    'Set FmtOnly OFF;SELECT * from sys.tables')

    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 3 posts - 1 through 2 (of 2 total)

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