Chris,
Wow...
This is going to sound strange....
When I first got that message, I went into the enterprise
manager, and strangely about 5 out of the 20 or so databases were in
single user mode. I never selected single user mode in my entire life:)
I unchecked the "single user" option, and everything was fine for a
while. And I forgot about it. Today, when I first checked my email, I got
4500 messages from my server saying there is a problem (When I trap a
database error in CF, I do a cfmail to me to tell me about it)
I just went back in, and 2 of the databases were in single user
mode. One was the database for my busiest site, thethin.net.
The other was used infrequently, so I guess it didn't trigger any errors.
Nobody other than me has access to that server. I know I did not select
single user mode.
So the question is: How did it go into single user mode?
Is there a bug in SQL Server 7.0SP2?
Could it have been a hacker playing around with a cold fusion exploit in
some way?
thanks for the reply.. I will watch it closely.
Al
>Al,
>
>Go into SQLServer Enterprise Manager. Click on the entry for the database,
>select Database Properties, go to the Options Tab and deselect the Single
>User option.
>
>Chris
>------------------------------------------------------------------
>Chris Lomvardias
>[EMAIL PROTECTED]
>Syscom, Inc.
>400 E. Pratt Street, Suite 300
>Baltimore, MD 21202
>(410)539-3737 x1722 voice
>(410)539-7302 fax
>[EMAIL PROTECTED] (pager via email)
>http://www.syscom.com/
>------------------------------------------------------------------
>
>-----Original Message-----
>From: Al Musella, DPM [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, December 13, 2000 1:41 PM
>To: CF-Talk
>Subject: ODBC Error 37000
>
>
>
>I have been getting this error message a lot lately.. I have no idea where
>the problem is.
> When it happens, I have been rebooting the cold fusion server and sql 7
>server. Then it works for a while and then stops.
>
>
>ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC
>SQL Server Driver][SQL Server]Database 'thethin' is already open and can
>only have one user at a time.
>
>
>The most commonly executed querry is for a banner ad rotation I wrote,
>which calls a stored procedure. I am pretty new at stored procedures... so
>I may have blew this badly:)
>
>
><cfquery name="nextad" datasource="thethin" dbtype="ODBC">
> { call getad(#cat_id#) }
></cfquery>
>
>The procedure is:
>
>create procedure getad
> @cat_id integer
> as
> begin transaction
> declare @lastad_id int
> declare @nextad_id int
> declare @shown int
>
> set @lastad_id = (select lastad_id from category where category_id =
>@cat_id)
> set @nextad_id = (select min(ad_link) from ad_category_link where
>((category_link = @cat_id) and (ad_link > @lastad_id)))
> set @shown = (select shown from ads where ad_id = @nextad_id) +1
>
>
> if @nextad_id is NULL
> begin
> set @nextad_id = (select min(ad_link) from ad_category_link
>where (category_link = @cat_id) )
> end
>
> update category set lastad_id = @nextad_id where category_id= @cat_id
> update ads set shown= @shown where ad_id = @nextad_id
> select * from ads where ad_id = @nextad_id
>
> commit transaction
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
