roger.plowman (9/12/2011)

---

I keep seeing the chest-pounding developers who claim if you don't know how to implement low-level structures in C (or equally low-level languages) that you're not a real developer/CS...

Removed.

Here's a nice post on how to do that with PowerShell: http://www.simple-talk.com/community/blogs/laerte/archive/2011/09/08/103241.aspx

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...