June 24, 2003 at 6:29 pm
At the moment, our SQL (7) is case insensitive. If I upgrade it to 2K, would the installation provide the chance to change it from case insensitive to case sensitive along the way? If it does, is there any other configuration required after the installation?
Thank you to all in advance.
June 25, 2003 at 1:17 am
If you do a straight upgrade, you don't have the option to change the collation. You have to install a named instance if you want to change that.
[font="Verdana"]Markus Bohse[/font]
June 25, 2003 at 10:01 pm
Thanks Markus. I found out when I did the upgrade installation. Anyway, I backed up the old SQL and had a fresh installation of SQL 2K. I then attached all databases from the .MDF files from the back up and every databases turned out with relevant login users. However, the Logins (in Security) does not contain any of those users but only admin and sa. I guess I can always recreate those users in this Security/Logins but I would have to enter password. The question is if I enter a password which is not the same with the existing one (as I dont know the password, someone else set it up initially), would it have any effect on the existing user or would it cause any problem. Or would I have to delete the existing user and then recreate it and give all relevant permission to it?
Cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply