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 |
|
malikjaved
Starting Member
21 Posts |
 Posted - 2008-02-06 : 07:57:52
|
| Hi, is there any simple way to execute script on remote server database. acutally i got the script in a varible and i want to execute this script on other server database.Thanks and looking forward. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-06 : 08:29:46
|
| Set up a linked server. |
 |
|
|
malikjaved
Starting Member
21 Posts |
Posted - 2008-02-06 : 08:38:45
|
| Thanks for reply, but actually what i want to do is another way, i have a store procudur in which some varible has some values of updat/alter the structure of table and procudure, i want to run that on the remote server database remaining into that procudurethanks and looking forward.-MALIK |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-02-06 : 08:42:25
|
| If you can, then connect to the server using EM or osql. Otherwise you will only be able to do this through a linked server. |
|
|
|
|
|
|
Execute on Remote server