microsoft sql server 2000

[sreenivasa]

i wanted to restore user DB from one sql server to another sql server ,
one database is having so many table and have user called digi
he is created so many SP and some tables., when i restore the db it
restored without any problem.,

after restoring application is not working

how to ensure that restored DB is having same security as the original
for that user .

when i tried to run the script of that db over that restored DB

it was showing user digi does not exist. but i have creted user digi

where can i get the useful information about this

/sreeni

--
srin
Posted via http://dbforums.com

[clockworkoi]

U¿ytkownik "sreenivasa" <me*********@dbforums.com> napisa³ w wiadomo¶ci
news:30****************@dbforums.com...

i wanted to restore user DB from one sql server to another sql server ,

<cut>
It's probably your answer - another sql so it means another master database.
You have user account in database wich was restored, but you do not have
user login (in master database - sysusers table) wich is connected to
database account.
You must drop database user and create new login - not recomended, or use
sp_change_users_login with Auto_Fix option.
regards
Marcin D