Ah, so essentially you pay less or more as you need to scale up or down, as the requirements (may) change throughout the day (or during a seasonal sale, for...

Maybe I'm just not understanding this whole "cloud" thing, but what's so special about using AWS or Azure instead of a regular web host using one or more VMs/VDSs, etc.,...

Unfortunately, I cannot figure out what may be causing your issues. Are you getting the "subscription" not found error, or "invalid parameter values" error?

I am currently not using DD subscriptions...

Did you change the GUID (Subscription ID) in the calling procedure when you recreated the SSRS subscription?

Luis Salgado (2/3/2012)

---

Returned the error:

1 “The subscription contains parameter values that are not valid”

Returned the error:

-2 “The subscription does not exist.”

I've tried everything, even new reports and new subscriptions but...

This sounds like you are attempting to send HTML in a plain text email, hence why the discrepancies. What are you using to send the physical email once the report...

Try this:

DECLARE @crlf char(2) = CHAR(13) + CHAR(10)

SELECT @emailBODY = 'first' + @crlf + 'second' + @crlf + 'third'

Note: for paragraphs, just double the @crlf, i.e.

SELECT @emailBODY = 'first' +...

Sure does seem like it's a bug. "æ" is NOT the same as "ae" nor is "Æ" the same as "AE". Why SQL Server thinks so when using Unicode is...

You can actually put a collation into the replace function, i.e.

SELECT test = REPLACE('Lock' COLLATE SQL_Latin1_General_CP1_CS_AS,'l','kn')

which in this example will return "Lock" since I set it to case-sensitive. This actually...

The UID needs to be hexadecimal. As such, there can't be a "Y" in there, hence the reason for the error. Not sure how the "Y" got into the sample...

Mark Gamble (6/3/2010)

---

Jason, Any word as yet on if this is supported in SSRS 2008.... I like it... but having issues getting it to work. Any assistance...

richardn-1128243 (4/21/2010)

---

This is great - despite the limitations on accuracy.

I have a collection of IP Addresses in the Visitor_Log table, which I convert to an IPNum - no problems there...

Mark-101232 (7/24/2009)

---

Jeff Moden (7/24/2009)

---

Mark (7/13/2009)

---

I think both functions can be simplified

create function dbo.ConvertIp2Num(@ip nvarchar(15))

returns bigint

as

begin

return ((cast(parsename(@ip,4) as bigint)*256+

...

Don't use the UPDATETEXT method. I recall people saying they were having trouble with that method. Refer to sample SQL given on page 5 and at http://spilich.blogspot.com/2007/11/using-data-driven-subscriptions-in.html for an alternate...

The code I used and rewrote some posts back worked in SQL2008 when I tested it at the time. Unfortunately I am not now actively using data-driven subscriptions. Perhaps try...