I looked all through BOL. What did you search on? Thanks for the info.

I added an additional processor to our WinNT 4.0 Machine. Did not have any issues. What were some of the things you encountered.

I administer two 6.5 SMS databases...Nasty!

-jg

I am trying to get the Job to error out if the file is not present. Then I can attempt the retry in the advance tab. I Used Print, but...

Great advice above. Look for sp recompiling. Profiler will assist with a lot of whats going into your server, and per mon will let you know what your processor is...

Ditto....DTS!

I embedded the code in the Enterprise Manager>>Management>>SQL Server Agent>> Jobs.

In the graphical tool I added a step and choose ActiveX Script in step type, and the radio btn VB.

I...

Great Article! Currently I use a spread sheet and a naming convention on SQL Scripts to track changes to Prod, but I like the use of VSS that you have...

I have the solution. I combined the Stuff, Right finction to get the proper format.

convert(varchar(10), dateadd(dd, term, stuff(stuff(right('0' + sdate, 6), 3, 0, '/'), 6, 0, '/')),101)

Thanks for all the...

The right function works great, but I need to do a dateadd function to the col too. In order to do the dateadd I understand I must first put it...