Sounds to me like the front end app needs to be fixed.
WJS
----- Original Message -----
From: "Lucey Christine"
<mssqldba-ezmlmshield-x83853376.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Friday, June 30, 2006 6:14 AM
Subject: RE: automated stopping and restarting of sql services in 2000.
> Vendor recommendation to compensate for a problem the front end app has
with
> releasing locks. :-P
>
>
> -----Original Message-----
> From: Jumma Salim
> [mailto:mssqldba-ezmlmshield-x18316772.[Email address protected]
> Sent: Friday, June 30, 2006 9:10 AM
> To: LazyDBA Discussion
> Subject: RE: automated stopping and restarting of sql services in 2000.
>
>
> Dump question
> What does stopping & starting sql server agent & sqlserver do
>
> Whats the advantage & why its needed ???
>
> -----Original Message-----
> From: Lucey Christine
> [mailto:mssqldba-ezmlmshield-x55543874.[Email address protected]
> Sent: Friday, June 30, 2006 8:57 AM
> To: LazyDBA Discussion
> Subject: RE: automated stopping and restarting of sql services in 2000.
>
> If you're talking about scheduled stops & restarts, you can use Windows
> Scheduled Tasks to run simple batch files that do the job.
>
> The command within the batch files is: net stop (example: NET STOP
> SQLSERVERAGENT)
> or net start (NET
> START SQLSERVERAGENT)
>
> I have to do this nightly on one of my servers. I run the batch files in
> this order:
> 1. Stop SQLSERVERAGENT
> 2. Stop SQLSERVER
> 3. Start SQLSERVER
> 4. Start SQLSERVERAGENT
> The commands run about 5 minutes apart from each other.
>
> Probably there is a more elegant way to do this, but it works for me.
>
> --Chris
>
>
> -----Original Message-----
> From: Todd Stover
> [mailto:mssqldba-ezmlmshield-x40757602.[Email address protected]
> Sent: Friday, June 30, 2006 8:41 AM
> To: LazyDBA Discussion
> Subject: automated stopping and restarting of sql services in 2000.
>
>
> Anyone know how to reliably do this?
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> NOTICE: This transmission may contain confidential health information
> that
> is protected by special federal or state law or regulation. It is
> intended
> only for the use of the individual to whom it has been addressed. Only
> the
> person named in this transmission is authorized to view any information
> contained herein. Re-disclosure without proper consent is prohibited.
> Unauthorized use or disclosure or failure to maintain confidentiality
> may
> subject you to penalties under both federal and state law.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
> NOTICE: This transmission may contain confidential health information that
> is protected by special federal or state law or regulation. It is intended
> only for the use of the individual to whom it has been addressed. Only the
> person named in this transmission is authorized to view any information
> contained herein. Re-disclosure without proper consent is prohibited.
> Unauthorized use or disclosure or failure to maintain confidentiality may
> subject you to penalties under both federal and state law.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page