I am running W2K server and SQL Server 2000. I stopped all the service put them to manual. Rebooted the servers and started the services again.

I am confused,...

THANKS!

My sysxlogins table is now fixed.

Joseph

I found the login in the sysxusers table. Thanks.

Now when I try to delete it I get the message "can't directly modify system tables". I looked in the...

Got it. Thanks for you help

I was missing the -E.

Joseph

THANKS!

I got into the server and have changed the password. I am working on finding out how to setup the production server.

Joseph

The problem was database properties for backups.

Thanks to Greg Larsen.

Joseph

Thank you for your help.

I did finally find out that the logical and physical files can be done with an alter database command.

I will be going with Raid1 on the...

What is the web site for Microsoft Knowledge?

Thanks

I found out that the backups are compatible. Make sure the code page and character sets are the same between 4.2 and 6.5. Create the database in 6.5,...

Are the backups compatible if I create an enviroment with the same code page and character set? I just found out there are more than 100 tables.

What was the...

Thank you for the help.

I found the sp_msforeachdb in the object browser, but there is not any information from the "Help: online books".

Can you recommend a good reference book? ...

It worked, Thanks! I did an uninstall/install and made sure to pick the correct selection.

Joe Devereaux

Yes, you can make a good living working with databases. I found that it helped having been a developer for 5+ years. It also helps in knowing the...

I know that these two parameters (code page and sort order) are only set at the time of the sql server 6.5 software install.

I have to install sql 6.5 on...