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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

reset users

Status
Not open for further replies.
Badgers

Badgers

Programmer
Nov 20, 2001
187
US
Hi,

When moving a database from one server to another you have to reset the users accounts due to different sid's.

There is a system stored proecure which you can run to do this, does anyone know what this is?

Or, is there a better way of solving this ?

thanks
 
Sort by date Sort by votes
thread183-1510392

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mdProgrammer
  • Locked
  • Question
Running Total with a reset
Replies
1
Views
82
mdProgrammer
mdProgrammer
asmall
  • Locked
  • Question
Users Not Assigned to a Group
Replies
1
Views
48
johnherman
johnherman
PeDa
  • Locked
  • Question
Identfying current users of database
Replies
4
Views
38
PeDa
PeDa
SBTBILL
  • Locked
  • Question
MSSQL says there are other users when there aren't 2
Replies
4
Views
54
gbaughma
gbaughma
DougNaf
  • Locked
  • Question
Domain users connected to SQL database
Replies
2
Views
54
NoCoolHandle
NoCoolHandle

Part and Inventory Search

Sponsor

Back
Top