Anmelden
Google-Apps
Hauptmenü
Post a Comment On:
SqlInk
"Linked Servers for data from another database"
No comments yet. -
1 – 0 of 0
To select data from another server using MS SQL Server, you have to add it as a linked server, using the following stored procedures.
EXEC sp_addlinkedserver
@srvproduct= 'SQL Server'
,@server= 'srvname'
GO
EXEC sp_addlinkedsrvlogin @rmtsrvname = 'srvname'
, @useself = 'FALSE'
, @rmtuser = 'username'
, @rmtpassword = 'password'
GO
posted by Nitin Reddy Katkam at
7:15 PM
on Oct 30, 2006
Leave your comment
You can use some HTML tags, such as
<b>, <i>, <a>
This blog does not allow anonymous comments.
Google Account
You will be asked to sign in after submitting your comment.
Please prove you're not a robot
"Linked Servers for data from another database"
No comments yet. -