Skip to main content

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:

  1. From the Windows Start menu, go to All Programs > Microsoft SQL Server > Microsoft SQL Server Management Studio.
  2. In the Object Explorer, find the Microsoft SQL Server target computer you are working with.
  3. Expand the databases folder for that computer, then expand the System databases folder, then expand the tempdb database. The EMPLOYEES and JOBS tables should now appear in the list.
  4. Right-click the EMPLOYEES table and select Select Top 1000 Rows. Check that there is data in the table.
  5. Right-click the JOBS table and select Select Top 1000 Rows. Check that there is data in the table.