SQL Server SP 2

[Amy]

I have installed the service pack 2 on a sql server 2000 standard edition.
When I went to run a sp_attach_db on some database files, the files attached
but the users (dbo and created user) did show up under logins. The users
were in the sysusers table. The non-dbo user was already created within
the instance.

Can anyone tell me what I might have done incorrectly on the installation
of the sp2 service pack. I installed the desktop version and then applied
the sp2 service pack...does sp1 have to be installed also? And of course..how
do I fix this issue?

Thanks for any help I recieve.

[Amy]

Turns out the user never loaded the service pack on the client machine causing
the user of the database not to be shown on the clients PC through Enterprise
manager.
Thanks


>
>I have installed the service pack 2 on a sql server 2000 standard edition.
>When I went to run a sp_attach_db on some database files, the files attached
>but the users (dbo and created user) did show up under logins. The users
>were in the sysusers table. The non-dbo user was already created within
>the instance.
>
>Can anyone tell me what I might have done incorrectly on the installation
>of the sp2 service pack. I installed the desktop version and then applied
>the sp2 service pack...does sp1 have to be installed also? And of course..how
>do I fix this issue?
>
>Thanks for any help I recieve.