Only somehow 'new forum' related, but...

I've noticed that sometimes when I click on the link in a notification mail, an existing instance of IE is used and sometimes a new one...

hmpf...I blame it on your bike, alzdba

That won't work. The identity property you can only declare on numeric columns like int, or decimal. Leading 0s will be ignored.

What do you want this for?

Look at BOL for 'Maximum Capacity Specifications'

Server: Nachr.-Nr. 8115, Schweregrad 16, Status 1, Zeile 1

Arithmetic overflow error converting IDENTITY to data type int.

Arithmetic overflow occurred.

So, you seem to need this for presentational purposes?

Well, use Jonathan's suggestion or, even better IMHO, do this in your application layer.

Would select cast(Elevation as decimal(8,2))/Height As TValue from Camps help?

oh, you can also use

alter procedure spGetProducts

as

....

Is even better, becuase you don't need to recreate permissions or dependent objects

Once you got the text from spGetProducts, use

drop procedure spGetProducts

go

create procedure spGetProducts

as .......

select Elevation/Height*1.00 As TValue from Camps should work, but why as this will always be .00?

Nice to hear that.

Good luck !

I might be wrong, but I have never heard of such a 'global' trigger.

I guess you have to use one trigger per table

Hi Ritch,

long time no see Everything's okay on your side?

Try http://www.dbforums.com/f82/ 

In this case look at 5409045121009 (consider changing your username, Len, see what copy and paste now yields

Hehe, I know. One of the few things I like about Germany.

Sunday morning in the summer, the Autobahn 31 heading to Emden. Almost 40 kilometres straight with no curve. That's...