sp_grantlogin, sp_denylogin and sp_revokelogin

sp_grantlogin, sp_denylogin and sp_revokelogin.

All these three are the system stored procedure used to manage windows account authentication. sp_grantlogin allows to add and grant access to windows account.
sp_denylogin denies user to access server without deleting windows account from SQL server. sp_revokelogin delete windows account from SQL server.
Write SQL query to retrieve all tables of the database
Select name from sysObjects where xtype=’u’.......
Define Local temporary table and global temporary table
Local temporary table is created by prefixing name with pound sign like (#table_name).......
When do we use the UPDATE_STATISTICS command?
UPDATE_STATISTICS updates the indexes on the tables when there is large processing of data........
Post your comment

Related Content

Follow us

▲