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 |
|
mcp111
Starting Member
44 Posts |
 Posted - 2004-04-08 : 14:31:20
|
| Is there any way to find out which database on the linked server is linked? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-08 : 14:33:49
|
| If you are linking to a SQL Server using server type of SQL Server, then you don't link to a database just to the server. So if the user that is being used for the linked server has master as the default database, then that will be the database of the linked server. If you are using Other Data Source as the server type, then the database is specified in that information.Tara |
 |
|
|
mcp111
Starting Member
44 Posts |
Posted - 2004-04-08 : 14:41:09
|
| What if I didn't do the linking and I can just see the linked server in my Enterprise manager? Can I find out which database is linked? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-08 : 14:44:17
|
| Can you click on properties on the linked server and see if Server Type is SQL Server. If this is the case, everything else will be grayed out.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mcp111
Starting Member
44 Posts |
Posted - 2004-04-08 : 14:50:31
|
| if I right-click on the linked server there is no properties menu. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-08 : 15:18:02
|
| Are you the DBA? If not, that's really who should be troubleshooting this.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
mcp111
Starting Member
44 Posts |
Posted - 2004-04-08 : 15:24:21
|
| There is no problem with the linked server. I just want to know if there is any way to see which database is linked in Enterprise manager. Just for my knowledge. I am not the DBA and do not have direct access to the server. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-08 : 16:03:08
|
| Ok. Without that access, there really isn't a way to. They should be able to tell you pretty quickly though. If you are using SQL Server as the access type, you have any access the "linked server" is using. If it's using trusted connection, they you have the access level of whoever is connecting.If they are using any other type of access for linked server, your workspace will be in one database. Although if the user described above has access, you can still run things from other databases using the EXEC database.owner.object format.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
|
|
Linked server database