Viewing 2 posts - 1,411 through 1,412 (of 1,412 total)
Use a computed field. Something like:
CREATE TABLE foobar
(
a int IDENTITY(1,1)
, b char(3)
, c AS (b + REPLICATE('0', 4 - LEN(CONVERT(varchar(4), a))) +...
July 17, 2001 at 7:22 am
#417115
Are SQL Mail and SQL Agent Mail sharing the same profile, or are they using different (named) profiles?
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
July 16, 2001 at 8:59 am
#417087