Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_wedge
Starting Member
18 Posts |
 Posted - 2005-10-26 : 07:10:06
|
| Hi When I open a query analyzer window and I type use finance_db(lower case) I get the following error:"Could not locate entry in sysdatabases for database 'finance_db'. No entry found with that name. Make sure that the name is entered correctly."It is in the sysdatabases as FINANCE_DB.So there is some kind of case sensitivity going on .I applied SQL 2000 SP4 last night and this must have changed a setting.Any advice? |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-10-26 : 07:53:35
|
| Hi,what is your sql collation ?! -----------------------------------------------------------MSSQL Server encryption software http://www.activecrypt.com |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-27 : 01:53:46
|
| So ... if you type use FINANCE_DB it works? And it used to work OK with lower case?Its a bit scary if SP4 did this to you! so perhaps its something else.Do you have a case sensitive server anyway, and "finance_db" used to be in lower case and something has now changed that to upper case in sysdatabases?Kristen |
|
|
|
sql_wedge
Starting Member
18 Posts |
Posted - 2005-10-28 : 09:13:56
|
| False alarm -- the database in question has always been case sensitive I have just found out.It is running great plains as has always been like that.So it wasnt sp4 after allSorry about that |
|
|
|
|
|
|
Case sensitivity SQL 2000