Could someone please remind me hoe to change the date format in the output
grid when I run a query within Management Studio.

I'm sure this must be possible. I remember doing it for Query Analyzer under
SQL 2000, but can't find the setting within Management Studio.

Many thanks.

Stephen

Have you tried "SET DATEFORMAT"
"Stephen E-G" wrote:

> Could someone please remind me hoe to change the date format in the output
> grid when I run a query within Management Studio.
>
> I'm sure this must be possible. I remember doing it for Query Analyzer under
> SQL 2000, but can't find the setting within Management Studio.
>
> Many thanks.
>
> Stephen

It is not a Transact SQL statement that I require.

In Query Analyzer (on the old SQL Server 2000), under options, connections
tab, there is a setting that says 'Use Regional Settings when displaying
currency, numbers, dates, times'.

I'm wanting to find the same setting when running a query in Management
Studio.

Thank you.

"Greg Larsen" wrote:

> Have you tried "SET DATEFORMAT"
> "Stephen E-G" wrote:
>
> > Could someone please remind me hoe to change the date format in the output
> > grid when I run a query within Management Studio.
> >
> > I'm sure this must be possible. I remember doing it for Query Analyzer under
> > SQL 2000, but can't find the setting within Management Studio.
> >
> > Many thanks.
> >
> > Stephen