Gianluca Sartori (9/12/2011)

---

I re-read my reply and I see that it violates the "if you don't have anything nice to say, don't say anything at all" rule.

Steve, can you delete...

In terms of documentation, I think that roles provide some level of self documentation. You name them something related, then group objects/users and match permissions with them. Typically you have...

It's not so much needing a new schema, but more the complexity from two security implementations.

I think we're on the same page, but let me put an example out there.

I...

Rude is a matter of taste and I do try...

I should say that depending on how complicated your situation is, perhaps you can use print statements or temp tables to help you debug what is happening?

AFAIK, the debugger for 2008 only works against 2008 instances. Visual Studio has a debugger for 2005.

http://blogs.msdn.com/b/billramo/archive/2009/04/11/transact-sql-debugger-for-sql-server-2008-part-1.aspx

Jeff Moden (9/11/2011)

---

I'm definitely the wrong one to ask on this. My belief is that users should only have 2 privs on a production box... PUBLIC and the EXECUTE...

If you don't need to go out of row, you don't want to. Especially with index reorganize restraints. I agree with Florian. If you don't access the data often, then...

You haven't well framed the question. Is this a one time transfer? Are they the same format? Do the names of the files change?

Setting up a one time transfer is...

I'm not...

rmechaber (9/12/2011)

---

But...

Aaron N. Cutshall (9/12/2011)

---

I am the Sr. Data Architect at Indiana Health Information Exchange, the nation's largest and oldest exchange of medical and health data. Security and accuracy are...

Ray K (9/12/2011)

---

Steve Jones - SSC Editor (9/11/2011)

---

that was cool. I happened to turn on the last 2 min of the UM/ND game last night to see a stunning finish:...

GilaMonster (9/11/2011)

---

I'm seriously contemplating, early next year when I have some spare time again, ripping all the drives out of that machine, replacing them with 2x1.5TB and setting up a...

WayneS (9/11/2011)

---

The last sentence says it all about...