If I had my way then they wouldn't have access at all.

The problem has occurred because we work in a large department with dozens of servers - they don't want us developers (although I'm...

#1: As you say he's moving from Dev to Test

#2: he doesn't but he writes instructions for our Delivery Team to do this. They are the team with access, unfortunately...

Isn't there a risk of losing trasactions if you delete the transaction log?

Thanks a lot, using a little bit of your suggestion I have managed a workaround. This involves two activeX script tasks. The first loads the variables and is run before...

It OK I managed it, its just DTSGlobalVariables.Remove("gv_myglobal")

Simple when you know how. Cheers

quote:

---

should be possible using dynamic sql.

You may take a look at sp_executesql in BOL

Cheers,

Frank

---

July 17, 2003 at 4:33 am