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
> >
> >
>
>

Auditing Status of a Trigger in SQL Server 2005

I need to know when a DML trigger changes state (from enabled to disabled, and disabled to enabled).

I **assume** this info is not in any of the standard SQL Server 2005 loags and find no entry relating to triggers being enabled/disabled.

Therefore I also *assume* the best way to do this is create a DDL Trigger and populate a table when a trigger status is changed.

Am I on the right track?

Has anyone done this? Code samples/links to solution?

Is there a simplier way <i'm all about simple>?

Thanks in advance.

Thats exactly the right direction, if you need a quikc sample for using DDL events, take a look at the DDL event definition in the BOL and perhpas at the slightly different samples on my website: http://sqlserver2005.de/articles/2/

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de