> Who's got info on this:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'Database'
> is already open and can only have one user at a time.
My guess is that, for some reason, the SQL Server has set the database to
run in single-user mode. This occasionally happens after failures of certain
types, I think. I'd search http://support.microsoft.com/ for more info on
the underlying reasons. To fix the problem right now, go into Enterprise
Manager, right-click on the database, select Properties, and clear the
"single-user" checkbox which is somewhere within that interface.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
