Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Sending SQL Notifications with CDOSYS

    Works great, just do not forget to remove the space in this line!

    EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas. microsoft.com/cdo/configuration/smtpserver").Value', 'MailServerName'

  • RE: How to get Time from Getdate()

    How about something like:

    print Convert( Char(30), GetDate(), 108)

    print Convert( Char(30), GetDate(), 109)

    See BOL for a complete list with format numbers

Viewing 2 posts - 1 through 2 (of 2 total)