Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 URL in email

Author  Topic 

Rekha
Starting Member

14 Posts

Posted - 2008-07-29 : 05:33:55
Hi All,
I need to send below URL in email in store proc

http://corpusmdbdb1/Reports/Pages/Report.aspx?ServerUrl=http%3a%2f%2fcorpusmdbdb1%2fReportServer%3f%252fStandard%2bList%2bAudit%2bReport%252fStandard%2bList%2bDetail%2bAnalysis%26feed_id%3d9687%26rc%253aParameters%3dFalse%26rc%253aReplacementRoot%3dhttp%253a%252f%252fcorpusmdbdb1%252fReports%252fPages%252fReport.aspx%253fServerUrl%253d

Please let me know how can I have this URL with underline etc in xp_sendemail.

Thanks in Advance

jason7655
Starting Member

24 Posts

Posted - 2008-07-30 : 09:19:49
Look into this:

[url]http://forums.databasejournal.com/showthread.php?t=38151&highlight=HTML[/url]
Go to Top of Page
   

- Advertisement -