American date problem

Hi there,
I have just installed my MS SQL Server 2000 Box on a Windows 2003 server. I
have this database that came shipped with from my print management suppliers
that allow me track all printing activity. however one of the tables has a
field of a field type "datetime" which is recording all transaction dates in
american format. I have check my regional setting on the Windows 2003 box but
all is set to "Irish format". How can get my SQL box record dates in UK/Irish
date format rather than American format. Is there a setting that I'm missing.
Many thanks,
Liam
Datetime values are stored in a format that is independent of
language/regional settings. The client application is responsible for
formatting.
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>
|||Dates are not stored in any format -- they are stored as two numeric values.
So what you are seeing is how the client tool is showing the dates to you.
http://www.aspfaq.com/
(Reverse address to reply.)
"Liam Mac" <LiamMac@.discussions.microsoft.com> wrote in message
news:4BA679E3-55FC-46D1-8D32-99E7BCF82ACA@.microsoft.com...
> Hi there,
> I have just installed my MS SQL Server 2000 Box on a Windows 2003 server.
I
> have this database that came shipped with from my print management
suppliers
> that allow me track all printing activity. however one of the tables has
a
> field of a field type "datetime" which is recording all transaction dates
in
> american format. I have check my regional setting on the Windows 2003 box
but
> all is set to "Irish format". How can get my SQL box record dates in
UK/Irish
> date format rather than American format. Is there a setting that I'm
missing.
> Many thanks,
> Liam
>

Alternative to profiler

I can use the Profiler because my DB is on a Hosting, what alternative do I
have to monitor and make tuning to my DB
thks
Kenny M.
Do you have sa rights on the SQL Server? If so you might want to try using
Trace instead of profiler.
http://support.microsoft.com/?id=283790
Andrew J. Kelly SQL MVP
"Kenny M." <KennyM@.discussions.microsoft.com> wrote in message
news:D1004DB0-CE29-4CC5-9311-F94E47BB09F3@.microsoft.com...
>I can use the Profiler because my DB is on a Hosting, what alternative do I
> have to monitor and make tuning to my DB
> thks
> --
> Kenny M.
|||Kenny M. wrote:
> I can use the Profiler because my DB is on a Hosting, what
> alternative do I have to monitor and make tuning to my DB
> thks
You can start with tuning your existing queries using Query Analyzer or
any query tool and examining the execution plans. With QA, you can use
the Show Execution Plan option. From other tools you can use the SET
STATISTICS PROFILE ON / OFF.
David Gugick
Quest Software
www.imceda.com
www.quest.com