Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqllover
Constraint Violating Yak Guru
338 Posts |
 Posted - 2014-02-04 : 22:04:53
|
| Hi,I have two different databases in two servers(server1, server2). i would like to call the server2 database SP in server1 database SP. I know this can be achieved using linked server. but in my case i shouldn't be using linked server. but i know the domain and credentials of calling server(server2). So how to achieve this using credentials rather than creating linked server. please suggest me the way to achieve this |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-02-08 : 02:19:48
|
| It is possible through OPENROWSET and OPENDATASOURCE.Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Stored Procedure call