Post reply

Rename SQL Sever 6.5 Logins

  • January 7, 2004 at 11:55 am

    #358792

    Is there a way to rename SQL Server 6.5 Logins?  I would want to change the login name and the user name in each database while retaining all permissions.  I saw a script to do this in FAQ, but that was really written for SQL Server 7/2000.

  • January 7, 2004 at 1:53 pm

    #489040

    Not sure there's an easy way to do this in 65. Been a long time. I know modifying system tables worked easier in 65 and you might be able to do that. Force an update on syslogins and sysusers

     

  • January 7, 2004 at 2:38 pm

    #489050

    I've been experimenting, and it looks like modifying syslogins and sysusers will work.  I haven't found any problems so far.  If anyone has any further information -- you've done it and it worked, you've done it and you don't recommend it -- please let me know.

    Thanks.

  • January 7, 2004 at 10:51 pm

    #489076

    I've done it, and it works.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply