Verifying Table Formats in SQL Server

This section discusses two methods to verify tables formats in SQL Server:

• Method One

• Method Two

Method One

To verify tables formats in SQL Server using method one:

1. Run this SQL Server query:

   Select * from owner.filename
   

   where owner is the owner of the table to be verified.

   This query returns the records in the table as well as their columns. Use the information above to verify that the number of columns and record counts are consistent between the log file and the actual table. The information in the log file should be correct.

2. If you are verifying only the column layout, click Cancel to stop the query.

Method Two

To verify tables formats in SQL Server using method two:

1. Run the SQL Server Enterprise Manager Graphical Application.

   A tree view of the servers, databases, tables, owners, and other related information is displayed.

2. Find the table on the appropriate server or database.

3. Double-click the table.

   The columns that make up the table are shown graphically. Use the information above to verify that the number of columns and record counts are consistent between the log file and the actual table. The information in the log file should be correct.