I thought maybe we could do this with EVENTINFO() in a trigger, but the calling proc isn't included in the schema (would be nice!).

Looking at the docs, it seems maybe you...

>>As long as the trigger is enabled you can make sure that the logic will work.

Maybe could also create a database-level trigger using the same technique, to make sure that the table...

>>In the end, what I'd like is to simply have another method of delivery (via printer) that any subscription can use to print to any printer on our lan.

I...

Well, Rod, I'm sorry to hear that your environment doesn't support you... and you didn't hit a nerve except maybe for the one that says "didn't I explain all this...

'Scuse me, Rod, but I understand why your ASP.NET server is outside the firewall, I do understand the purpose of separating out these functions, working with partners, etc.  I am not...

You haven't really explained anything about your ASP.NET application or where it's situated on your network.  But the fact that it "uses SSL" doesn't change anything in the equation, or...

i'm not sure I can debug this from your example, because a lot would be determined on how you had installed RS on the server, I guess... but I'll give...

To do this really well, you are going to have to nest TRY/CATCH blocks in each called proc, I think...

The nested CATCH blocks in each called proc can call...

>>so I found that the joins were the issue here, and I needed to re-think the way my query was to work.

OIC, sorry, then can you use PeterHe's EXISTS suggestion and bring...

>>

Actually, PatIndex does need the wildcards as it performs a pattern search much like the keyword LIKE. Without the wildcards, the entire strings would have to be exact matches. You...

JIC... are you sure you're not looking at the build information at the end of the @@version that applies to the version of the OS, not the version of SQL...

Yes, you can access the report through a URL (I'm attempting to answer your second question) programmatically.  The actual URL that your application uses can contain all necessary parameter values,...

Followup thought: I think in your situation you don't need the '%' wildcards in the PATINDEX expression, just the embracing commas.

Sorry if that was confusion/red herring.

>L<

>>Can anyone think of a better way of ...

>>dbo.IsInCommaList(@subject_list, sub.id) = 1

>>works fine, but I cant use it because of the issue with the joins.

Not sure if this is...

Mark, as you know from previous conversations, I don't have RS2000 available to check this.. JIC you don't hear from somebody who does, here is how I would try to...