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.
| Author |
Topic |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-06-19 : 04:58:38
|
| I know how to create a login using sp_addloginHow do you check if the login already exists and if it does not then use sp_addlogin to create it?Thanks |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-06-19 : 05:03:10
|
| select name from master..syslogins- Lumbago |
 |
|
|
|
|
|
if login exists