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
 Replication (2005)
 Replicating database

Author  Topic 

paulynnl
Starting Member

2 Posts

Posted - 2008-09-04 : 17:32:44

Hi,

I replicated a small (I'm new and learning) database to another sql server. How do I get access to the tables on the newly replicated database? Any help would be greatly appreciated.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-04 : 17:37:04
Grant yourself access on the subscription server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

paulynnl
Starting Member

2 Posts

Posted - 2008-09-04 : 17:51:14
I have access to the subsciption server but I cannot see the tables on the newly replicated database. Your help again, please. Many thanks!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-04 : 17:54:06
I don't understand the issue. Have you registered the subscription server in Management Studio? Tell us exactly where you are looking to make your issue clear. Also, are you getting an error?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -