Typically, you could create a temp table and run an INSERT INTO <tempTable> EXEC <YourProc>, but having to account for dynamic columns makes this approach not feasable.

You may...

What is the scope of the insert/update/deletes? Do they all impact one single row or mutiple rows in the destination tables?

Avatar Blue Ray.

Dead ant

Dead ant

You need to type cast your expression to a date datatype:

(DT_DBTIMESTAMP)(SUBSTRING(DateValue,1,4) + "-" + (SUBSTRING(DateValue,6,2) + "-" + SUBSTRING(DateValue,9,2) + " " + SUBSTRING(DateValue,12,2) + ":" + SUBSTRING(DateValue,15,2) + ":"...

Yes, it is possible; but I too would like to better understand your requirement before teaching you something that may not be the best approach.

I'm with Steve here. This is a change management issue. I would develop a process to deliver the SP changes to your client DBs.

This may be a candidate for Notification Services. You can have your VB or C# app 'subscribe' to a recordset and it will get a notification when that recordset...

fruitfully

multiply

In addition to what Brian and Elliot have said, here's Microsoft's opinion on backup security:

The best practice for protecting backups is to store backup tapes in a secure location or...

Can you post the table DDL for the 2 tables in question as well as some sample data? I have some recommendations for how to do that in the...

Greg Edwards-268690 (4/19/2010)

---

Lynn Pettis (4/19/2010)

---

Grant Fritchey (4/19/2010)

---

I use to have A which caused me to do a lot of C, so I'd have to choose D - none of the...

Surfactant

Glad to help.