All INT DataTypes acting as Decimals 2

[Idokyoku2]

Anyone have an idea why every Tbl within every DB with an INT datatype is being displayed as if were numeric? This has only been within the last couple of days. It still functions as it should. I would love to eliminate the trailing zeros.

Thanks,
David

 

[donutman]

In QA?
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[Idokyoku2]

Correct.

 

[donutman]

Try it from another workstation or the server itself.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[Idokyoku2]

Can't just yet. . .one workstation - MSDE 2000.
D

 

[JamesLean]

In QA, go to Tools -> Options. In the Connections tab, untick "Use regional settings when displaying currency, number, dates, and times".

--James

 

[donutman]

Good catch James.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[Idokyoku2]

Thank you so much!!!

Gave you a star!

David