Showing posts with label Microsoft SQL Server Interview Questions and Answers. Show all posts
Showing posts with label Microsoft SQL Server Interview Questions and Answers. Show all posts

Friday, August 16, 2013

Microsoft SQL Server Interview Questions and Answer


What is SQL Server ?
SQL Server is a DBMS system provided by Microsoft. SQL Server is sometimes mistakenly referred to as SQL.
Error severity 13 indicates what?
Transactional deadlock errors.
This level of error severity indicates a transaction deadlock error.
In which order do you perform an upgrade to SQL Server 2005 for replicated databases?
Distributor, Publisher, then Subscriber.
You always perform an upgrade in this order: distributor, publisher, subscriber.
How many Service Packs will be released for SQL Server 2005 in 2007?
Explanation: The answer is up in the air and this is more of a poll than a real QOD. Based on the ways things are going, the staff here sees just 1, though our hope would be that 3 or 4 would be released.
You setup a linked server from a SQL Server 2000 server to your new SQL Server 2005 server (with defaults), however you cannot execute procedures on the 2005 server. Why not?