Your post wasn't showing up on the active threads.

You can't quite do that the way your are trying. Dynamic sql runs in its own batch so when you execute your...

This article should give you a jump start. http://msdn.microsoft.com/en-us/library/aa337396.aspx

When you send the email you put that guid in a table. Then the webpage checks the table for the existence of that guid when it loads. If it doesn't...

If you are going to pass multiple values in a single parameter you will need to split that parameter inside your sproc. For one of the best methods of splitting...

Something had to disable the triggers. They just can't disable themselves. Maybe somebody disabled them accidentally?

You might find this article[/url] a good starting point if you want to try to tackle it on your own.

I would be happy to help but I need a bit more details. ddl, sample data (inserts), desired output based on your sample data. And of course the dml of...

Ninja's_RGR'us (10/14/2011)

---

If you really want to go completely to the dark side and use something "incorrectly" you can do this.

Create a report with a parameter. The datasource should be...

Freeman-674288 (10/14/2011)

---

Crazy question indeed... Is there a way to trigger an SQL Job, or run a Stored Procedure (with parameter) by sending an email to the SQL Server somehow?

This is...

You probably need to use separate variables instead of reusing the same one.

The bigger question, can you get rid of the cursor? Can you get rid of the dynamic...

HUH?

Are you saying the triggers are disabled by no interaction? No code, no UI work?

Sure you can do that.

create table #ConstraintCheck

(

ID int not null identity,

FK1 int,

FK2 int,

MyVal varchar(25)

)

go

alter table #ConstraintCheck

Add constraint chk_ConstraintCheck CHECK ((FK1 is not null or FK2 is not null) and (FK2...

I see you are new around and sounds like fairly new to sql. It is pretty much impossible for anybody to give you the stored procedure code. We need a...

Back to the topic after the commercial break...

It doesn't really matter if you link your tables or not. If it were my project I would not link the tables at...