Jeff Moden (9/13/2011)

---

I have to ask... where do students get the money to travel from Australia to Europe, spend a couple of weeks doing whatever they want, and then travel...

grumble, grumble

#$%$^#$%$# Steelers

Grant Fritchey (9/12/2011)

---

Chad Crawford (9/12/2011)

---

Woohoo. Attended my first SQL Saturday and spoke there as well. Was as nervous as <fill in your favorite joke here>, since the...

Chad, I'll work on something. It gets a little hard to handle prizes, which is the main thing we charge the tickets for. The casino is covered by SQLServerCentral, but...

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