Simple answer is that we don't: We leave our package unencrypted because there is nothing earth shakingly proprietary about it and clients own the data do there's nothing to hide....

The only criticism I have, and this is common to a LOT of technical articles, is that this does not consider the scenario that you have to deploy an package...

Word of warning:

I've just done this as I typed it out on a Win 2K3 server and it didn't work at first. I checked the reg key very carefully and...

Hi

I had a similar problem recently. It is most likely because although your AD user has rights on the server, it does NOT have rights to write to the system...

Thought I'd update this since I have re-visited the original script quite a lot recently and made some improvements. The major change is that when I ran this on real-world...

Hmmm...clearly some brain melt going on from my end. Serves me right for checking this on my phone whilst out drinking! I'm going to amend the script to grab include...

Cool, thanks for the info. Will test the same when I get a chance and confirm.

I hate to use the old developers refrain but...it worked on my db. There were several constraints which had been disabled and they were again afterwards. I will re check...

I hate to use the old developers refrain but...it worked on my db. There were several constraints which had been disabled and they were again afterwards. I will re check...

It already does pay attention to trusted/untrusted and enabled/disabled status - and generates all columns without the need for loops/cursor or temp tables.

Cheers

Good spot! I had fully intended to do include columns and forgot. That's something rather useful so I probably will add support for those. This was something of a rush...

I fully agree - I was going to add support for changing data types in stored procedures and UDFs too, but since the database I wrote this for used neither...

Actually, I think this is my bad for being a thicko. I've got my day of week shift thingy wrong - re-working it now.

Dynamic SQL isn't terribly easy to maintain and of course it has questionable efficiency. I usually find that there is another way if you look hard enough (although it has...

Hmmm...I figured as much. Sadly, dynamic sql is not something I'm keen on and it wouldn't be suited to the situation I was mulling, nor would the other suggested solution....