Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Lock login/user in sql server

Author  Topic 

surenhr
Starting Member

5 Posts

Posted - 2007-08-07 : 10:30:49
can u plzz suggest a way to lock the login on sql server using various store procedures available in sql server OR any sql query ..
i want achieve it programatically.....

Is lock supported on sql server.

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-07 : 10:40:49
What do you mean by lock?
Have a look at alter login - disable

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -