Tuesday, March 27, 2012

Auto close disabled

Hello :
I have a problem, in my database I found many messages " starting up
database 'xxx'", I have Auto_close Option Disable.
I don´t have any idea.
Can anyone help me?
thanks a lotI would double and triple check the auto close setting for all databases. Only time I've heard about
lots of these messages are when auto close is on...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Carlos A." <CarlosA@.discussions.microsoft.com> wrote in message
news:2DE5FBC3-33C4-4E29-960A-DA209EF4F7FB@.microsoft.com...
> Hello :
> I have a problem, in my database I found many messages " starting up
> database 'xxx'", I have Auto_close Option Disable.
> I don´t have any idea.
> Can anyone help me?
> thanks a lot
>|||Hi, Tibor.
I reviwed all databases and auto_close option is disable, but only one
database show "starting database 'XXX' ".
Any other idea?
thanks a lot for you help
"Tibor Karaszi" wrote:
> I would double and triple check the auto close setting for all databases. Only time I've heard about
> lots of these messages are when auto close is on...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Carlos A." <CarlosA@.discussions.microsoft.com> wrote in message
> news:2DE5FBC3-33C4-4E29-960A-DA209EF4F7FB@.microsoft.com...
> > Hello :
> > I have a problem, in my database I found many messages " starting up
> > database 'xxx'", I have Auto_close Option Disable.
> >
> > I don´t have any idea.
> >
> > Can anyone help me?
> > thanks a lot
> >
> >
>
>

No comments:

Post a Comment