Sql Server 2000
In the Enterprise Manager under Security, Logins I have an existing user using Windows Authentication. The first tab, General, there's a Defaults section with either Database or Language.
Problem:
I have two databases School and SchoolII. School was the old database, and SchoolII is the new database. When I set the default database from School to SchoolII, my old VB6 app quits working. It can't find the tables. When I change the default database back from SchoolII to School, everything works. I have the same permissions on both databases.
Any ideas?
In the Enterprise Manager under Security, Logins I have an existing user using Windows Authentication. The first tab, General, there's a Defaults section with either Database or Language.
Problem:
I have two databases School and SchoolII. School was the old database, and SchoolII is the new database. When I set the default database from School to SchoolII, my old VB6 app quits working. It can't find the tables. When I change the default database back from SchoolII to School, everything works. I have the same permissions on both databases.
Any ideas?
