Viewing 15 posts - 1 through 15 (of 46 total)
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...
July 12, 2012 at 11:35 am
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.,...
July 12, 2012 at 8:40 am
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...
February 7, 2012 at 1:23 pm
Did you change the GUID (Subscription ID) in the calling procedure when you recreated the SSRS subscription?
February 3, 2012 at 11:28 am
Luis Salgado (2/3/2012)
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...
February 3, 2012 at 11:15 am
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...
November 29, 2011 at 2:55 pm
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' +...
November 29, 2011 at 11:18 am
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...
October 4, 2011 at 9:01 am
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...
October 3, 2011 at 12:11 pm
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...
December 9, 2010 at 10:10 am
Mark Gamble (6/3/2010)
June 3, 2010 at 1:30 pm
richardn-1128243 (4/21/2010)
I have a collection of IP Addresses in the Visitor_Log table, which I convert to an IPNum - no problems there...
April 23, 2010 at 7:35 am
Mark-101232 (7/24/2009)
Jeff Moden (7/24/2009)
Mark (7/13/2009)
create function dbo.ConvertIp2Num(@ip nvarchar(15))
returns bigint
as
begin
return ((cast(parsename(@ip,4) as bigint)*256+
...
April 16, 2010 at 8:19 am
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...
March 25, 2010 at 11:17 am
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...
March 25, 2010 at 10:14 am
Viewing 15 posts - 1 through 15 (of 46 total)