Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
recreate user
Many thanks to dbmsguy and wjbburn for responding. The sp_change_users_login solution seems to have worked. Thanks a lot!- stephenUK
- Post #4
- Forum: Microsoft SQL Server: Programming
-
recreate user
Hi, I'm having a problem with a user account on SQL Server 7 that i am trying to recreate. Basically, I have deleted a user (sp_dropuser) which seems to have worked ok. But now, when I try to add the user again (based on a new NT account) it complains that the user already exists. It no...- stephenUK
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
