Posted by Greg D. Moore \(Strider\) on 01/28/07 02:07

"javelin" <google.1.jvmail@spamgourmet.com> wrote in message
news:1169944694.026131.168800@m58g2000cwm.googlegroups.com...
> I'm having difficulty searching for an answer to this challenge. Can
> someone give me a clue on the right keywords to use to find a
> discussion on this subject? All of the ones I saw appear to touch on
> older versions. I'm working with SQL Server 2000, and need to backup
> and restore only tables, because the full backup/restore appears to
> mess up users/security, or something or another.

There really isn't. You backup and restore an entire database. Unless
you're using filegroups, etc.

However, most likely what you need is sp_change_users_login to reconcile the
users in the database with the logins on the server.

Check that out. It will most likely solve your problems.


>
> Thanks for the assist.
>

[Back to original message]