Yes you can do the same thing just substitute the field you want to use for the field that I have provided. AS long a sit is the same...

Maxim Picard (1/22/2009)

---

The problem is this would be a ressource monster with real data.

Just look at the estimated subtree cost ratio

0.0066852 (Left Outer Join)

0.0572076 (CTE)

In both cases it does a...

K. Brian Kelley (1/22/2009)

---

I won't disagree with the encryption tools. It's not exactly easy to get encryption working in SQL Server.

SQL Server supports TLS. Has since the SQL 2000 days....

K. Brian Kelley (1/22/2009)

---

If I'm a system administrator,...

Could you post some sample data and your expected results from that sample data. See the link in my signature for the best way to do it.

Do you mean the agent for a backup product like BackupExec? Or, Do you want to be able to schedule SQL Server Native Backups?

You can setup a linked server (see BOL) and then you can do the query like this:

ALTER PROCEDURE dbo.JanetsTest

AS

Insert into Products

(

ProductCode,

ProductDescription

)

...

I didn't go through the whole script, but you might want to submit it to the script library here.

All of the above issues are why I believe any encryption should be done in the business layer, not the database.

RBarryYoung (1/22/2009)

---

Exactly, Grant.

The general rule of thumb that you want to follow is: if columns in two different tables hold the same values and are intended to match each other...

You may want to take 5 minutes (maybe 10 if you have to register) and watch this video on JumpstartTV, http://www.jumpstarttv.com/parameterizing-the-execute-sql-task-in-ssis_500.aspx

Michael solution will work, but I always recommend going out and getting a tool that does this like ApexSQLDiff or RedGate SQLCompare. Long term it will be worth the...

I think the biggest issue is lack of true project management in IT. I know I struggle with taking all the information from users and accurately converting those to...

As Steve said, if you limit the events and columns traced and filter on the appropriate database(s) it should be very lightweight.

You do want to make sure that you are...

Well, apparently your patience is paying off. I don't think I could have lasted that long.