Does SET DATEFORMAT only set the format for the session?

Hello
Can anyone confirm that if I use SET DATEFORMAT that it
will only change the date format for the SQL session and
not permanently for the machine?
Thanks in advance
H
Hi -
The Transact-SQL programming language provides several SET statements that
alter the current session handling of specific information.
SET DATEFORMAT is one such SET Function which will chage the date format for
the SQL Session.
Thanks
-Surajit
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H
|||Yes, Only for that specific session( not for everyone). And it applies ONLY
until that session ends.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H

Does SET DATEFORMAT only set the format for the session?

Hello
Can anyone confirm that if I use SET DATEFORMAT that it
will only change the date format for the SQL session and
not permanently for the machine?
Thanks in advance
HHi -
The Transact-SQL programming language provides several SET statements that
alter the current session handling of specific information.
SET DATEFORMAT is one such SET Function which will chage the date format for
the SQL Session.
Thanks
-Surajit
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx
.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H|||Yes, Only for that specific session( not for everyone). And it applies ONLY
until that session ends.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx
.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H

Does SET DATEFORMAT only set the format for the session?

Hello
Can anyone confirm that if I use SET DATEFORMAT that it
will only change the date format for the SQL session and
not permanently for the machine?
Thanks in advance
HHi -
The Transact-SQL programming language provides several SET statements that
alter the current session handling of specific information.
SET DATEFORMAT is one such SET Function which will chage the date format for
the SQL Session.
Thanks
-Surajit
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H|||Yes, Only for that specific session( not for everyone). And it applies ONLY
until that session ends.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"H" <anonymous@.discussions.microsoft.com> wrote in message
news:19fbb01c44da7$b42e8000$a101280a@.phx.gbl...
> Hello
> Can anyone confirm that if I use SET DATEFORMAT that it
> will only change the date format for the SQL session and
> not permanently for the machine?
> Thanks in advance
> H

Does Reporting Services work with Novell Groupwise?

Can anyone please confirm how well e-mail delivered subscriptions of
reports work using Novell Groupwise as the mail solution?
There is a post in this forum that suggests Novell Groupwise suffers
from the same corruption of PDF and Excel attached reports as Lotus
Notes.We've run it with V6.5 GroupWise using PDF attachments without any problems
so far.
Julian
"Uncle Earnie" <david.roys@.nz.ey.com> wrote in message
news:5eeae37a.0409202028.750f4df9@.posting.google.com...
> Can anyone please confirm how well e-mail delivered subscriptions of
> reports work using Novell Groupwise as the mail solution?
> There is a post in this forum that suggests Novell Groupwise suffers
> from the same corruption of PDF and Excel attached reports as Lotus
> Notes.sql