MSDTC error

Hi guys,
Im new to SQL Server development in general...Well, I've been trying to
work on an existing application that uses both ASP and SQL Server that
happened to be raising an error that is logged on the Event Viewer 15
minutes after closing the browser. Here it is:
Event Type: Information
Event Source: MSDTC
Event Category: (3)
Event ID: 4156
Date: 09/08/2005
Time: 12:56:28 PM
User: N/A
Description:
String message: Session idle timeout over, tearing down the session.
As it looks, it seems like a uncleared session state upon exiting the
ASP page. I then tried using Session.Contents.RemoveAll and
Session.Abandon methods but still got no luck on the ASP side...Is there
anyway this Informational Message won't get logged into the Event
Viewer? I dont really know if its ASP or SQL problem! hehe...
Your help will greatly be appreciated. Thanks!
*** Sent via Developersdex http://www.examnotes.net ***Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Check out http://support.microsoft.com/defaul...kb;en-us;290334 for
more information on the error. AFAIK, the message can't be suppressed.
Hope this helps.
Dan Guzman
SQL Server MVP
"jules remoreras" <losevilla@.yahoo.com> wrote in message
news:uQYosRRvFHA.2504@.tk2msftngp13.phx.gbl...
> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***|||Session is holding an object it should not hold. If it is database related,
it is likely a connection opened when a session starts that is never killed.
It is not necessarily SQL Server related.
I would post in the ASP group:
microsoft.public.inetserver.asp.general
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
"jules remoreras" wrote:

> Hi guys,
> Im new to SQL Server development in general...Well, I've been trying to
> work on an existing application that uses both ASP and SQL Server that
> happened to be raising an error that is logged on the Event Viewer 15
> minutes after closing the browser. Here it is:
> Event Type: Information
> Event Source: MSDTC
> Event Category: (3)
> Event ID: 4156
> Date: 09/08/2005
> Time: 12:56:28 PM
> User: N/A
> Description:
> String message: Session idle timeout over, tearing down the session.
> As it looks, it seems like a uncleared session state upon exiting the
> ASP page. I then tried using Session.Contents.RemoveAll and
> Session.Abandon methods but still got no luck on the ASP side...Is there
> anyway this Informational Message won't get logged into the Event
> Viewer? I dont really know if its ASP or SQL problem! hehe...
> Your help will greatly be appreciated. Thanks!
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
>|||Gee...thanks to both of you (Dan and Cowboy) for the input!!! :) At
least the input/link you posted somehow enlighten my heavily burden
mind. hehehe. Thanks again!
*** Sent via Developersdex http://www.examnotes.net ***

MS-DOS COPY problem

Hi,
I want to create a batch file which copies existing files in one directory to another directory(actually sub-directories in the second directory) based on the dates they were created using MS-DOS command.
Example:
File A created on Jan-10-03
File B created on Dec-12-97
File A & B are in C:/ drive and when I run the batch file the File A should be copied to d:/Jan & File B should be copied to D:/Dec

Please let me know!
Thanks.Use xp_cmdshell ...|||Could you please elaborate...I am kind of new to the IT field.
Thank you.

Originally posted by snail
Use xp_cmdshell ...|||xp_cmdshell allows you to issue commands to the operating system just as if you were at a DOS prompt. xp_cmdshell must be called from the Master database. Look it up in Books Online for syntax and details.

blindman|||Doing this with CMD commands is going to be tuff. For this type of work I would suggest a scripting language like PERL, PYTHON or even good old qbasic! Of course you could do this with TSQL but this is not always the best solution for system scripting. Knowing one of the above languages will make short work of this kind of task.|||Hi,

another possibility would be an ActiveXScript in a DTS package. For information about working with files in DTS refer to http://www.sqldts.com/default.aspx?292

Bye,
Carsten