Since the XML file must be ready to be read when the package opens, I think it is hard to apply encryption to the XML file itself. What are you...

You should post the exact error messages, it would really help us to help you.

My first guess is that the package fails in validation. Try setting the DelayValidation property to...

The first hit on Google for the keywords sql server cpu bottleneck:

http://www.sql-server-performance.com/tips/performance_monitor_cpu_counter_p1.aspx

A little research won't harm you.

You should start a new thread for your question instead of hijacking...

Since your database is in full recovery mode, can't you take a tail log backup and do a point-in-time restore right before you deleted the data?

Good, but difficult question. I had to read quite some BOL pages to get this one right.

And only 1 point?

Brandie Tarvin (1/6/2011)

---

Jack Corbett (1/6/2011)

---

I also want to encourage all you who are PASS members to opt-in to the session voting for SQLRally. See my this post which has...

Thanks for sharing!

I thought this was a pretty accurate description:

😀 (an oldie but a goodie)

At first glance this seems like a situation that the MERGE statement could handle.

http://msdn.microsoft.com/en-us/library/bb510625(v=SQL.100).aspx

What have you tried so far? Any issues?

cengland0 (1/10/2011)

---

Koen (da-zero) (1/10/2011)

---

What kind of trigger? The question asks if it is possible with a trigger. So it is up to you to find out if there is a...

cengland0 (1/10/2011)

---

Got this one wrong because I didn't understand the wording of the question.

Is it possible, using a trigger, to update a data row before commiting the insert...

1) Usually you do the design in the database itself, using Management Studio. So you create the tables there and of course, while you create them, you give them names.

2)...

ALZDBA (1/10/2011)

---

Indeed, Antwerp was a mess this morning. Slippery roads and unadapted driving style causing "fun" traffic jams all over the place 🙁

Regarding the pastries, I was aiming for the...