MCSE-Microsoft Certified Solutions Expert Question & Answers
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|
- Related Questions