Post reply

Quering across database machines

  • May 4, 2006 at 8:55 am

    #114525

    Is is possible to run a query across different machines from a stored procedure.

    i implemented a solution where i created a .net dll which i wrapped with vb.6 [sql2000].This takes a sql query ,database , machine UID and PWd as parameter.

    the object connects to and returns a table with the above which i inserted into a temp table.

    but i was wondering if their is a easier way which i do not  know.

    thanks

    satz

  • May 4, 2006 at 9:32 am

    #635989

    You might want to look into 'linked servers'. Here's one article on them...

    http://www.databasejournal.com/features/mssql/article.php/3085211

    Ryan Randall

    Solutions are easy. Understanding the problem, now, that's the hard part.

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

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