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.
Tuesday, February 23, 2010
Extended stored procedure or not
at 12:41 AM
Labels: SQL Server 2005, SQL Server Test, SQL Server Tip
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment