You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: “Invalid object name.” Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A) EXEC sp_defaultdb ‘Andrew’,’FinanceData’

B) GRANT ALL ON FinanceData TO Andrew

C) EXEC sp_addlogin ‘Andrew’

D) EXEC sp_grantdbaccess ‘FinanceData’,’Andrew’GOsp_addrolemember ‘db_datareader’,’Andrew’

View Answer
Option – A.