Forum Replies Created

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

  • RE: DecryptByPassphrase where key has single apostrophe

    ok, managed to get this working by doing a replace on the parameter to replace ' with ''

  • RE: SSIS and web services

    That's the thing, I get the error even without any code written. it fails as soon as I add in the web reference (which it connects to fine).
    the web...

  • RE: sp_send_dbmail

    the whole string is as follows:
    set @querytext = replace('BEGIN:VCALENDAR~~VERSION:2.0~~METHOD: PUBLISH~~' + stuff((SELECT SelectString2 + '' FROM triage.dbo.vw_ExportLists_ics_2 FOR XML PATH('')),1,0,'') +  'END:VCALENDAR','~~', char(13));
    this prints in SSMS as:
    BEGIN:VCALENDAR

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