Re: How to reset after Alter Session

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 23 Jan 2003 21:06:09 -0800
Message-ID: <92eeeff0.0301232106.595f3d3a@posting.google.com>

samevan_at_hotmail.com (Sam) wrote in message >
> As Stephan mentined that the original state could be TRUE or False.
> How do I set this back to original state? "ALTER SESSION SET
> SQL_TRACE" is only the example for this question. There are many
> SESSION variables we can alter, which we should be able to set back to
> their original states.
>
> Thanks!
>
> Sam

Create a script (or use glogin.sql) with all SET or whatever statements that reflect your "original" or "desired" environment. When in doubt, run the script and you will always come back to square 1.

Regards
/Rauf Sarwar Received on Thu Jan 23 2003 - 23:06:09 CST