Bob,

if you do select name from sysuser you would be able to correct all of them.  Also make sure all the logins are created on the server first before you...

That is how sql internal function.  It assume you are looking for dbo.table name unless you qualify it.

mom

That should be ok don't you think?

OK here is what you told me.  When you create a login, the application create another one for it's use so that mean for...

It is normal that user login would be all messed up.  To correct the action there are a couple way to fix your problem. 

1. EXEC sp_change_users_login 'Update_One', 'Mary', 'NewMary'

2....

put your result into a long text field.  After you got the result, you will notice what the format look like.  I try to look for how the row are...

What type of tools does your company has for you to use.  I like to us DB Artisan by Embarcadero to migrate table, stored proc, views etc. from SQL 6.5...

because it was looking for dbo.tblinfo table.  That is the problem all the time when you don't create the table with dbo.tablename.  It is sometimes a hasle to clean up...

How about shutdown all internet traffic to that server at the firewall.  Also allow only the intranet traffic to talk to that server.

mom

I don't know how to restrict the db file restore, but I know of a way in which to restrict the access to those file.

That is how it works on osql or isql.  There is nothing much you can do, at least I just deal with it and don't read the first character.

If you...

It scared me to think that sys admin has sa password and is the key keeper in your case.

I do respect what sys admin does and how much stuff they do.  They...

This is very interesting.  Why would you load norton virus check on your sql server.  I though that nortan might take the database file over and turn your database unavailable...

Well that'w what I mean when I said remove the registry

mom

hm let me ask you a set of questions first.

1. What operating system do you have for your server?

2. What sql version did you previously have.?

I know that if you...

I think it is a personal preference.

mom