Tuesday, February 23, 2010

Extended stored procedure or not

What will be the output of the following statements in SQL Server 2005?
SELECT OBJECTPROPERTY(OBJECT_ID('sp_executesql'),'IsExtendedProc')
SELECT OBJECTPROPERTY(OBJECT_ID('xp_grantlogin'),'IsExtendedProc')

A. 1, 1
B. 1, 0
C. 0, 1
D. 0, 0

Answer:[B]
Highlight to find out the answer.

No comments:

Post a Comment