Which of the following classes provide the conte

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

(Continued from previous question...)

Which of the following classes provide the context of the caller to SQLCLR Assemblies? Submitted by Michael Coles

Answer: Microsoft.SqlServer.Server.SqlContext

Explanation: The answer is 1:Microsoft.SqlServer.Server.SqlContext
SQLCLR Assemblies can use the Microsoft.SqlServer.Server.SqlContext class - it is an abstraction of the caller's context. Objects exposed by SqlContext include SqlPipe, SqlTriggerContext, and WindowsIdentity.

(Continued on next question...)

Other Job Interview Questions

• What does the CREATE SERVICE statement do in SQL Server 2005?
• You have specified that a SQL Server 2005 login must respect the password policy on a Windows XP host. Which of the following are valid passwords for the user Kendall?
• you want to be sure that SQL authenticated logins must abide by the password policy.. .
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• What is the cost threshhold for parallelism in SQL Server 2005?
• You are performing a number of SELECT queries on one of your SQL Server 2005 Service Broker queues and you get a call that applications using the queues are running slowly. What can you do?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• Which of the following is true about the Raw File Source in SQL Server 2005 Integration Services?
• What is the scope of the control permission in SQL Server 2005?
• When the network service built-in account connects to a network resource, what is the context?
• More...