Ans: First Run sp_addlinkedserver storedProc with the server name as
exec sp_addlinked server ServerName
Then write your query eg:
Select * from
-Arvind
Friday, November 21, 2008
How to excute Database query on remote server system
How to excute Database query on remote server system?
Ans: First Run sp_addlinkedserver storedProc with the server name as
exec sp_addlinked server ServerName
Then write your query eg:
Select * fromservername.DBName.Tablename
-Arvind
Ans: First Run sp_addlinkedserver storedProc with the server name as
exec sp_addlinked server ServerName
Then write your query eg:
Select * from
-Arvind
Subscribe to:
Comments (Atom)
Posts
