August 3, 2010 at 9:29 am
I have a two linked servers...
My one linked server lists all the db's under catalog.
Everything was working fine.
But I added an extra Db to my linked server...but I can't see it under catalog
I can see all the other DB's..just not the new one I just added.
How do I add this new DB to my catalog list?
August 3, 2010 at 1:24 pm
You created one more database? I did not get the question
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 3, 2010 at 2:17 pm
Do the login(s) which you are using to connect your linked server have permissions for the new database?
August 3, 2010 at 3:00 pm
yeah everythings the same I can see all the old DB's in the catalog
just not the new DB I just created.
August 4, 2010 at 3:53 am
which catalog ? try this select * from sys.databases where name = 'new Db name'
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 4, 2010 at 6:38 am
It was permissions!
Thanks guys!
Good karma to you all..
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply