Ditto to the T-SQL script creation. Easiest and quickest way.

You could also try to use SSIS's Copy Database tasks. Though it tends to be messy and not create things in...

Gift,

I have an end user who does what you're describing. But in the end, no matter what numbers he plugs in to come up with his scenarios, he's still basing...

WHOOHOO!

Found the workaround.

Create a new database called ReportDesign. Give the report writers whatever perms they need on that database.

Give db_datareader and db_denydatawriter on the "source" databases (from which the...

That link just shows another question. It doesn't actually show what you did for a final solution.

But if you post the final solution in either thread, then reference that solution...

Julie Breutzmann (12/4/2009)

---

But what about the companies that received and made use of what was clearly stolen data; it's improbable that someone could purcahse data with renewal dates for customers...

Oh, yeah. Steve's line gives me an idea for a whole 'nother story. @=)

Gift, I'm sorry. I don't understand that sentence at all. Could you rephrase? Because the...

Gift Peddie (12/3/2009)[hrIf a DBA stops intermediate inserts which are needed in most complex reports the DBA will write the code to create that report because there are reasons why...

So it's not that Execute perms don't work, but that by the rules you can't use them?

Could you post some sample code for the resolution so that people who need this in the future can better understand your solution?

In my experience, the Compliance team (or whatever name the watchdogs have) are not tech people. If a DBA wanted to get away with something, it would be easy to...

laurav (12/3/2009)

---

I would tell my managers and IT security folks what I was doing and why, and they would look at me as though I had two heads. I...

Sorry about that. This is the same link Steve...

Seth,

Hate to break the news to you, but if they haven't already figured that trick out, they're either new to being T-SQL writer or they're not a very good one.

That's...

Actually, we don't allow anybody to write procs in production. We have a Dev environment, Test environment and QC environment to go through before things reach Production. Unfortunately, we're all...