March 29, 2006 at 4:33 am
When running stored proc in restricted access single user I receive this message if the database is polled from another user or the sql Server Browse service is runnung when the polling stops the database continues. Microsoft access seems to be the worst offender.
The stored proc code doesn't seem to matters but it’s in an upgrade to a database application that it happens most often.
We need a fix to run our upgrades on client servers where the person running the database may not be a system administrator. I know that if I stop the browse the system will complete without error (if I control all my users and stop them from attempting to access the database)
Sql server 2000 has the same problem however there is no browser obviously.
37000:[Microsoft][SQL Native Client][SQL Server]Database 'NCTEST3' is already open and can only have one user at a time.
SQL Developer
James
Access Accounting Ltd
March 29, 2006 at 4:42 am
What is the issue here ?
Why do you want to have the database in single user mode for changing database application.
If you are modifying certain SP's, I don't think you need to make the database to single user mode.
Regards
Jay Mehta
March 29, 2006 at 5:15 am
If we put the database in single user mode the tables and stored procs we are upgrading and the data transfers hap in a fraction of the time. The database has over 800 stored procs and hundreds of table of critical info.
SQL Developer
James
Access Accounting Ltd
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply