connection pooling

Remove the "fix minor problems" option of the integrity part.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason" <jasonlewis@.hotmail.com> wrote in message news:OHtJLbEkGHA.2200@.TK2MSFTNGP05.phx.gbl
..
> Hi,
> Is there a way to do maintenance like integrity checks if there is still
> a (sleeping)connection to a database? My maintenance jobs where you need
> to be in single user mode fails. In our multi-tier environment we use an
> applicationserver which uses connection pooling and a databaseserver
> (SQL2K).
> I've looked at dbcc opentran, but that doesn't work for me. The solution
> i'm looking for is to check if there are any connections for a
> particular database. If so, i want to disconnect it, but leave it in a
> state so that the applicationserver doesn't have to restart it's
> services (this is a manual proces).Tibor Karaszi wrote:
> Remove the "fix minor problems" option of the integrity part.
>
Hi Tibor,
If i do that, how do i know if there are any errors to be fixed? I've
read that in sql 2005 that option is removed.|||he purpose of DBCC CHECKDB is to *find* errors. The command will return erro
r messages which will
cause the job to fail which you can be alerted for.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason" <jasonlewis@.hotmail.com> wrote in message news:uYBZsQFkGHA.1296@.TK2MSFTNGP05.phx.gbl
..
> Tibor Karaszi wrote:
> Hi Tibor,
> If i do that, how do i know if there are any errors to be fixed? I've read
that in sql 2005 that
> option is removed.
>|||Hi,
Is there a way to do maintenance like integrity checks if there is still
a (sleeping)connection to a database? My maintenance jobs where you need
to be in single user mode fails. In our multi-tier environment we use an
applicationserver which uses connection pooling and a databaseserver
(SQL2K).
I've looked at dbcc opentran, but that doesn't work for me. The solution
i'm looking for is to check if there are any connections for a
particular database. If so, i want to disconnect it, but leave it in a
state so that the applicationserver doesn't have to restart it's
services (this is a manual proces).|||Remove the "fix minor problems" option of the integrity part.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason" <jasonlewis@.hotmail.com> wrote in message news:OHtJLbEkGHA.2200@.TK2MSFTNGP05.phx.gbl
..
> Hi,
> Is there a way to do maintenance like integrity checks if there is still
> a (sleeping)connection to a database? My maintenance jobs where you need
> to be in single user mode fails. In our multi-tier environment we use an
> applicationserver which uses connection pooling and a databaseserver
> (SQL2K).
> I've looked at dbcc opentran, but that doesn't work for me. The solution
> i'm looking for is to check if there are any connections for a
> particular database. If so, i want to disconnect it, but leave it in a
> state so that the applicationserver doesn't have to restart it's
> services (this is a manual proces).|||Tibor Karaszi wrote:
> Remove the "fix minor problems" option of the integrity part.
>
Hi Tibor,
If i do that, how do i know if there are any errors to be fixed? I've
read that in sql 2005 that option is removed.|||he purpose of DBCC CHECKDB is to *find* errors. The command will return erro
r messages which will
cause the job to fail which you can be alerted for.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jason" <jasonlewis@.hotmail.com> wrote in message news:uYBZsQFkGHA.1296@.TK2MSFTNGP05.phx.gbl
..
> Tibor Karaszi wrote:
> Hi Tibor,
> If i do that, how do i know if there are any errors to be fixed? I've read
that in sql 2005 that
> option is removed.
>