When using the SQLCMD tool, what does the -V par

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

(Continued from previous question...)

When using the SQLCMD tool, what does the -V parameter do?

Answer: This specifies the lowest severity level that sqlcmd will report errors from.

Explanation: This parameter specifies the lowest severity level that sqlcmd will report when a T-SQL error occurs.

(Continued on next question...)

Other Job Interview Questions

• In the REPEATABLE READ isolation level, what phenomena is still possible?
• You want to be sure your database server if properly secured. You have two instances, a default instance and a named instance installed. Which ports do you need to open?
• Yesterday's QOD How are comments denoted in an XML document?
• Can you give me an overview of some of the database objects available for use in SQL Server 2000?
• Can a particular event in SQL Server 2005, such as the CREATE USER command, have more than one DDL trigger assigned to it?
• Where can you view the list of server-scoped DDL triggers?
• What does this return on SQL Server 2005? select NEWSEQUENTIALID()
• What is one of the downsides of using RAID 5 as opposed to RAID 1?
• In SQL Server 2005, if you want the keys securing your data to expire over time, what type of key encryption would you choose?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• More...