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 |
|
jamm
Starting Member
2 Posts |
 Posted - 2008-01-31 : 05:27:27
|
| Hello, im new to sql server 2005. Ive been handed the task to register a database from server A virtually on server B.I don't know how this is done. Can anyone please help meThanks in advance Jamm. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-01-31 : 07:27:54
|
| regsiter....as in be able to acces remotely?look for info here on the topic of linked-servers....there's a "system" SP which will allow you to register serverb on servera so that you can query serverb from servera (the registration process is NOT bi-directional, so you may have to repeat the process in reverse IF you need such reporting capabilities.) |
 |
|
|
jamm
Starting Member
2 Posts |
Posted - 2008-01-31 : 07:33:07
|
| Thank you thank you. My day is saved now :)Jamm |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-02-01 : 07:46:51
|
| :-) x2 |
|
|
|
|
|
|
Registering database Virtually