Viewing 2 posts - 1 through 2 (of 2 total)
One thing Peter failed to mention is that if you want to see lots of job history, be sure the job history log is big enough (Job System within SQL...
November 16, 2007 at 2:13 pm
#751986
A much simpler way to always display 2-byte days and months is: select convert(char(10),getdate(),101) The 101 style will always give you mm/dd/yyyy
September 21, 2007 at 8:47 am
#735270