View the replicated tables in Microsoft SQL Server
This task guides you through viewing the tempdb
database in Microsoft SQL Server. You will see that this database now includes two new tables: HR.EMPLOYEES and HR.JOBS.
To view the replicated tables in Microsoft SQL Server:
- From the Windows Start menu, go to All Programs > Microsoft SQL Server > Microsoft SQL Server Management Studio.
- In the Object Explorer, find the Microsoft SQL Server target computer you are working with.
- Expand the databases folder for that computer, then expand the System databases folder, then expand the tempdb database. The
EMPLOYEES
andJOBS
tables should now appear in the list. - Right-click the
EMPLOYEES
table and select Select Top 1000 Rows. Check that there is data in the table. - Right-click the
JOBS
table and select Select Top 1000 Rows. Check that there is data in the table.