Home Forums Article Discussions Article Discussions by Author Discuss content posted by Rafal S. Select from stored procedure RE: Select from stored procedure

  • July 24, 2008 at 6:28 pm

    #848160

    To connect to remote server:

    [font="Courier New"]select * from openrowset('SQLOLEDB', 'Uid=myUsername;Pwd=myPassword;Server=ServerNameOrAddress;Database=AdventureWorks2000', 'exec dbo.proc_simple')[/font]

    Riz