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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SSMS issue

Author  Topic 

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-03-24 : 21:14:17
Hi all,

I created a database on a remote server and trying to manage the database using a local SSMS. I am able to see the tables and other objects of the old databases residing on the same remote server, but not the new database. I have created the users similar to the other databases, have the exact same roles as the other databases.Not sure what I am missing here. Any suggestions??

Thank you

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-24 : 22:40:43
Did you connect to remote server after creating db?
Go to Top of Page

psangeetha
Yak Posting Veteran

95 Posts

Posted - 2008-03-25 : 08:44:33
Yes, I am able to connect to the remote server database newly created. But not able to see the tables and views except one system table dbo.dtproperties. Not sure what I am missing here
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-25 : 23:39:29
Did you create any table in that db yet?
Go to Top of Page
   

- Advertisement -