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 |
|
LearningBee
Starting Member
4 Posts |
 Posted - 2008-09-05 : 17:01:31
|
| I have two SQL servers (server A and B). I replicated a database from server A (publisher) to server B (subscriber). I could see the replicated database on server B but I cannot see the tables that are in the database. All there is is the System Tables (in the table folder). I have three tables that I wanted to access after I replicated the database to server B. Any help would be appreciated. Please and thank you! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-05 : 17:06:07
|
| What does replication monitor show? Are all of the jobs showing success? Did the snapshot get applied? Do you have the correct permissions on the subscription server?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
LearningBee
Starting Member
4 Posts |
Posted - 2008-09-05 : 17:23:38
|
| Yes, all the jobs were successfully replicated with no error message. And, I do have the correct permission on the subscription server. In the replication folder in server B I saw all the details of the local subscriptions and the database that was subcribed to. Can you please show me the steps to access the tables. Thank you so much for trying to help! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-09-05 : 17:48:26
|
| But what does replication monitor show?There is no difference between accessing the publisher tables or the subscription tables. They are just regular tables, so viewing is the same.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
Replication - how to access tables (MSSQL 2005)