You are the administrator of a SQL Server 2000 computer named CorpSQL. The server is a member of a Microsoft Windows NT domain named CORPORATE. Franz maintains a local user account on CorpSQL and is a member of the local Power Users group. He requests access to the SQL Server databases that are stored on CorpSQL.You need to allow Franz to access CorpSQL. Which Transact-SQL statement should you execute?

Question

TuteeHUB · Accepted Answer

EXEC sp_grantlogin Franz

TuteeHUB · Answer

EXEC sp_grantlogin CorpSQL\Franz

TuteeHUB · Answer

EXEC sp_grantlogin [Power Users\Franz]

TuteeHUB · Answer

EXEC sp_grantlogin CORPORATE\Franz

1.	You are the administrator of a SQL Server 2000 computer named CorpSQL. The server is a member of a Microsoft Windows NT domain named CORPORATE. Franz maintains a local user account on CorpSQL and is a member of the local Power Users group. He requests access to the SQL Server databases that are stored on CorpSQL.You need to allow Franz to access CorpSQL. Which Transact-SQL statement should you execute?
A.	EXEC sp_grantlogin CorpSQL\Franz
B.	EXEC sp_grantlogin Franz
C.	EXEC sp_grantlogin [Power Users\Franz]
D.	EXEC sp_grantlogin CORPORATE\Franz
Answer» B. EXEC sp_grantlogin Franz

Discussion

No Comment Found

Related MCQs

Reply to Comment