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 |
|
antony_dba
Starting Member
26 Posts |
 Posted - 2010-11-30 : 01:19:32
|
| please suggest me how to create a login with default user as sa andhow to drop the login(username) for particular database say x,how to drop the login(username) for particular database say Xkris |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-11-30 : 03:08:57
|
| Please avoid cross posting.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153543http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=153544What you mean by default user ?sa is automatically created by sql server. If you have mixed login mode then you can connect with sa as userid and password of sa.http://www.google.co.in/#q=sql+server+create+user+and+login&hl=en&sa=2&fp=1969709c5fdeb503 |
 |
|
|
|
|
|
create,alter,drop login