What does the tablediff utility do?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does the tablediff utility do?

Answer
This utility will report the differences in data between two tables.

Explanation
This utility will report the data differences between two tables. They must be alike in structure and give back the T-SQL to bring the data in the tables to be the same for most datatypes.

(Continued on next question...)

Other Job Interview Questions

• What do you need to do now to ensure you can recover the routes in the event of a disaster?
• When a user on a remote SQL Server wants to execute a stored procedure through a linked server on your local server, what security context is used?
• In SQL Server 2005, which network protocols use endpoints?
• What is an index? What types of indexes are available in SQL Server 2000?
• How is Thesaurus data configured in SQL Server 2005 Full-Text Search?
• In SQL Server 2005, what does instance aware mean for a service?
• Which key does the OPEN MASTER KEY statement open?
• In SQL Server 2005, what does instance aware mean for a service?
• Which of the following datatypes can be represented in a SQL_VARIANT datatype?
• What message types exist in SQL Server 2005 Service Broker?
• More...