how long before sleeping connections disappear

Using SS2000 SP4. How long does it take after a user logs out before their
"sleeping connection" in EM/Current Activity/Process Info disappears? Is
there a way short of rebooting or stopping/starting services to get it to
disappear sooner?
Thanks,
--
Dan D.Hello,
The inactive connections will be removed from SQL Server based on the
application time out setup in appllication layer. Sleeping status doesnt
mean that status is orphan
connection, because most of the time if the process wait for a user Input
or waiting for a lock will be in sleeping mode. It can go for Running
status any time.
Take a look into the below URL:-
http://support.microsoft.com/kb/Q137983
Thanks
Hari
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||The connections are held until the application closes them. Many
applications use connection pooling so that closed connections are pooled
for reuse. These will disappear after a short period, IIRC 30-60 seconds.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||These connections are persisting longer than that. Maybe the application has
changed the timeout. Thanks.
--
Dan D.
"Dan Guzman" wrote:
> The connections are held until the application closes them. Many
> applications use connection pooling so that closed connections are pooled
> for reuse. These will disappear after a short period, IIRC 30-60 seconds.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> > Using SS2000 SP4. How long does it take after a user logs out before their
> > "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> > there a way short of rebooting or stopping/starting services to get it to
> > disappear sooner?
> >
> > Thanks,
> > --
> > Dan D.
>|||Interesting article. Thanks.
--
Dan D.
"Hari Prasad" wrote:
> Hello,
> The inactive connections will be removed from SQL Server based on the
> application time out setup in appllication layer. Sleeping status doesnt
> mean that status is orphan
> connection, because most of the time if the process wait for a user Input
> or waiting for a lock will be in sleeping mode. It can go for Running
> status any time.
> Take a look into the below URL:-
> http://support.microsoft.com/kb/Q137983
> Thanks
> Hari
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> > Using SS2000 SP4. How long does it take after a user logs out before their
> > "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> > there a way short of rebooting or stopping/starting services to get it to
> > disappear sooner?
> >
> > Thanks,
> > --
> > Dan D.
>
>

how long before sleeping connections disappear

Using SS2000 SP4. How long does it take after a user logs out before their
"sleeping connection" in EM/Current Activity/Process Info disappears? Is
there a way short of rebooting or stopping/starting services to get it to
disappear sooner?
Thanks,
Dan D.
Hello,
The inactive connections will be removed from SQL Server based on the
application time out setup in appllication layer. Sleeping status doesnt
mean that status is orphan
connection, because most of the time if the process wait for a user Input
or waiting for a lock will be in sleeping mode. It can go for Running
status any time.
Take a look into the below URL:-
http://support.microsoft.com/kb/Q137983
Thanks
Hari
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.
|||The connections are held until the application closes them. Many
applications use connection pooling so that closed connections are pooled
for reuse. These will disappear after a short period, IIRC 30-60 seconds.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.
|||These connections are persisting longer than that. Maybe the application has
changed the timeout. Thanks.
Dan D.
"Dan Guzman" wrote:

> The connections are held until the application closes them. Many
> applications use connection pooling so that closed connections are pooled
> for reuse. These will disappear after a short period, IIRC 30-60 seconds.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>
|||Interesting article. Thanks.
Dan D.
"Hari Prasad" wrote:

> Hello,
> The inactive connections will be removed from SQL Server based on the
> application time out setup in appllication layer. Sleeping status doesnt
> mean that status is orphan
> connection, because most of the time if the process wait for a user Input
> or waiting for a lock will be in sleeping mode. It can go for Running
> status any time.
> Take a look into the below URL:-
> http://support.microsoft.com/kb/Q137983
> Thanks
> Hari
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>
>

how long before sleeping connections disappear

Using SS2000 SP4. How long does it take after a user logs out before their
"sleeping connection" in EM/Current Activity/Process Info disappears? Is
there a way short of rebooting or stopping/starting services to get it to
disappear sooner?
Thanks,
--
Dan D.Hello,
The inactive connections will be removed from SQL Server based on the
application time out setup in appllication layer. Sleeping status doesnt
mean that status is orphan
connection, because most of the time if the process wait for a user Input
or waiting for a lock will be in sleeping mode. It can go for Running
status any time.
Take a look into the below URL:-
http://support.microsoft.com/kb/Q137983
Thanks
Hari
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||The connections are held until the application closes them. Many
applications use connection pooling so that closed connections are pooled
for reuse. These will disappear after a short period, IIRC 30-60 seconds.
Hope this helps.
Dan Guzman
SQL Server MVP
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
> Using SS2000 SP4. How long does it take after a user logs out before their
> "sleeping connection" in EM/Current Activity/Process Info disappears? Is
> there a way short of rebooting or stopping/starting services to get it to
> disappear sooner?
> Thanks,
> --
> Dan D.|||These connections are persisting longer than that. Maybe the application has
changed the timeout. Thanks.
--
Dan D.
"Dan Guzman" wrote:

> The connections are held until the application closes them. Many
> applications use connection pooling so that closed connections are pooled
> for reuse. These will disappear after a short period, IIRC 30-60 seconds.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>|||Interesting article. Thanks.
--
Dan D.
"Hari Prasad" wrote:

> Hello,
> The inactive connections will be removed from SQL Server based on the
> application time out setup in appllication layer. Sleeping status doesnt
> mean that status is orphan
> connection, because most of the time if the process wait for a user Input
> or waiting for a lock will be in sleeping mode. It can go for Running
> status any time.
> Take a look into the below URL:-
> http://support.microsoft.com/kb/Q137983
> Thanks
> Hari
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:04CB0892-63B1-4B6F-8E7F-5E5581A73563@.microsoft.com...
>
>

How know when one Table was droped? HELP-ME

Hi all,
I have one Data Base,
Today one strange thing occur, one table of my data base disappear , I didnt
drop it, then i would like know if have way to determine when this occur;
The last week same thing occur whit one store procedure.
Any one knows, how to help-me.
I use SQL Server 2005 SP1
Thanks to allIn SQL Server 2005 you can use DDL Triggers. Using these triggers you can
record the time the object was deleted, the login and user name used to
delete the object and the command executed, among other things.
See BOL for more information.
Ben Nevarez, MCDBA, OCP
Database Administrator
"retf" wrote:
> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I didnt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>
>|||Hi
It sounds like you may need to review your security settings and who has
access to this system! If this is a development system then you should also
be keeping code in a version control system.
John
"retf" wrote:
> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I didnt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>
>

How know when one Table was droped? HELP-ME

Hi all,
I have one Data Base,
Today one strange thing occur, one table of my data base disappear , I didnt
drop it, then i would like know if have way to determine when this occur;
The last week same thing occur whit one store procedure.
Any one knows, how to help-me.
I use SQL Server 2005 SP1
Thanks to all"retf" <re.tf@.terra.com.br> wrote in message
news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I
> didnt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
>
Look at the schema change history report in Management Studio.
David|||Where I find this?
Thanks for the help.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
> "retf" <re.tf@.terra.com.br> wrote in message
> news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
>> Hi all,
>> I have one Data Base,
>> Today one strange thing occur, one table of my data base disappear , I
>> didnt
>> drop it, then i would like know if have way to determine when this
>> occur;
>> The last week same thing occur whit one store procedure.
>>
>> Any one knows, how to help-me.
>> I use SQL Server 2005 SP1
>
> Look at the schema change history report in Management Studio.
> David
>|||SS Management Studio, Summary Tab, Report, Schema Changes History.
Ben Nevarez, MCDBA, OCP
Database Administrator
"retf" wrote:
> Where I find this?
> Thanks for the help.
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
> mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
> >
> > "retf" <re.tf@.terra.com.br> wrote in message
> > news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
> >> Hi all,
> >>
> >> I have one Data Base,
> >>
> >> Today one strange thing occur, one table of my data base disappear , I
> >> didnt
> >> drop it, then i would like know if have way to determine when this
> >> occur;
> >>
> >> The last week same thing occur whit one store procedure.
> >>
> >>
> >> Any one knows, how to help-me.
> >>
> >> I use SQL Server 2005 SP1
> >>
> >
> >
> > Look at the schema change history report in Management Studio.
> >
> > David
> >
>
>|||Hi,
Thank you very much...:o) :o) :o) :o)
"Ben Nevarez" <bnevarez@.sjm.com> escreveu na mensagem
news:54A60353-0816-4335-839F-50D6682BFFB4@.microsoft.com...
> SS Management Studio, Summary Tab, Report, Schema Changes History.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "retf" wrote:
>> Where I find this?
>> Thanks for the help.
>> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
>> mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
>> >
>> > "retf" <re.tf@.terra.com.br> wrote in message
>> > news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
>> >> Hi all,
>> >>
>> >> I have one Data Base,
>> >>
>> >> Today one strange thing occur, one table of my data base disappear , I
>> >> didnt
>> >> drop it, then i would like know if have way to determine when this
>> >> occur;
>> >>
>> >> The last week same thing occur whit one store procedure.
>> >>
>> >>
>> >> Any one knows, how to help-me.
>> >>
>> >> I use SQL Server 2005 SP1
>> >>
>> >
>> >
>> > Look at the schema change history report in Management Studio.
>> >
>> > David
>> >
>>

How know when one Table was droped? HELP-ME

Hi all,
I have one Data Base,
Today one strange thing occur, one table of my data base disappear , I didnt
drop it, then i would like know if have way to determine when this occur;
The last w same thing occur whit one store procedure.
Any one knows, how to help-me.
I use SQL Server 2005 SP1
Thanks to allyou can have a DDL trigger defined for DROP objects.. Don't know the exact
syntax..
you can check the BOL..
In this DDL trigger you can select the event details and insert it to a
table.|||You can DDL trigger for logging and Event Notification in S2K5.
"Retf"?? ??? ??:

> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I did
nt
> drop it, then i would like know if have way to determine when this occur;
> The last w same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>|||SQL Server 2005 has an always running trace - called "default trace". All ob
ject drop/alter/creation is audited (among other things). It keeps the histo
ry in up to 5 separate trace files with a limit of 20 MB per file. Since on
every SQL server restart a
new file is created the history is limited also by the last 5 SQL Server res
tarts. Here is how to get the information (assuming you have the default fil
e layout):
SELECT * FROM fn_trace_gettable
('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log.trc', default)
If you have lots of trace files under your LOG folder, find the last bunch o
f continuous file numbers and use the first file number. For instance if you
see log_154.trc, log_155.trc, log_156.trc, log_157.trc, use:
SELECT * FROM fn_trace_gettable
('C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\log_154.trc', defa
ult)
Thanks,
-Ivan
--Original Message--
From: hongjujung
Posted At: Friday, May 19, 2006 10:21 PM
Posted To: microsoft.public.sqlserver.programming
Conversation: How know when one Table was droped? HELP-ME
Subject: RE: How know when one Table was droped? HELP-ME
You can DDL trigger for logging and Event Notification in S2K5.
"Retf"?? ??? ??:

> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I
> didnt drop it, then i would like know if have way to determine when
> this occur;
> The last w same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>

How know when one Table was droped? HELP-ME

Hi all,
I have one Data Base,
Today one strange thing occur, one table of my data base disappear , I didnt
drop it, then i would like know if have way to determine when this occur;
The last week same thing occur whit one store procedure.
Any one knows, how to help-me.
I use SQL Server 2005 SP1
Thanks to all"retf" <re.tf@.terra.com.br> wrote in message
news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I
> didnt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
>
Look at the schema change history report in Management Studio.
David|||Where I find this?
Thanks for the help.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
> "retf" <re.tf@.terra.com.br> wrote in message
> news:eZ59$B5eGHA.2076@.TK2MSFTNGP04.phx.gbl...
>
> Look at the schema change history report in Management Studio.
> David
>|||SS Management Studio, Summary Tab, Report, Schema Changes History.
Ben Nevarez, MCDBA, OCP
Database Administrator
"retf" wrote:

> Where I find this?
> Thanks for the help.
> "David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escreveu na
> mensagem news:%23k73bO5eGHA.1260@.TK2MSFTNGP05.phx.gbl...
>
>|||Hi,
Thank you very much...:o) :o) :o) :o)
"Ben Nevarez" <bnevarez@.sjm.com> escreveu na mensagem
news:54A60353-0816-4335-839F-50D6682BFFB4@.microsoft.com...[vbcol=seagreen]
> SS Management Studio, Summary Tab, Report, Schema Changes History.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "retf" wrote:
>

How know when one Table was droped? HELP-ME

Hi all,
I have one Data Base,
Today one strange thing occur, one table of my data base disappear , I didnt
drop it, then i would like know if have way to determine when this occur;
The last week same thing occur whit one store procedure.
Any one knows, how to help-me.
I use SQL Server 2005 SP1
Thanks to allIn SQL Server 2005 you can use DDL Triggers. Using these triggers you can
record the time the object was deleted, the login and user name used to
delete the object and the command executed, among other things.
See BOL for more information.
Ben Nevarez, MCDBA, OCP
Database Administrator
"retf" wrote:

> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I did
nt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>
>|||Hi
It sounds like you may need to review your security settings and who has
access to this system! If this is a development system then you should also
be keeping code in a version control system.
John
"retf" wrote:

> Hi all,
> I have one Data Base,
> Today one strange thing occur, one table of my data base disappear , I did
nt
> drop it, then i would like know if have way to determine when this occur;
> The last week same thing occur whit one store procedure.
>
> Any one knows, how to help-me.
> I use SQL Server 2005 SP1
> Thanks to all
>
>
>