My luck that Bowe won't get me 2 pts tonight. Probably pop a hammy on the first play, where he'll catch a 10 yard pass and leave the game

doesn't work.

http://connect.microsoft.com/SQLServer/feedback/details/333593/allow-activation-of-application-role-in-logon-trigger

My apologies for not checking this out first. I was thinking in text here.

The idea of preventing some users from changing things would be in a DML trigger, not...

You need to read about how Application roles work.

http://msdn.microsoft.com/en-us/library/ms190998.aspx

You would invoke the role for certain people from the login trigger.

You need to be sure more detailed logging is capture from the job. In the job steps, you can capture output to a table.

If this is VBS, you could also...

You could do this. My understanding of Windows Backup in the modern OSes is that it is VSS aware and you get a real SQL backup.

However the problem is granularity....

A login trigger may help you here, but in conjunction with an application role. You might be able to trigger an application role as part of the login trigger, whic...

MySQL is not SQL Server. These are different products. This site is devoted to Microsoft SQL Server. No idea what cpanel is or what error you're having, but you might...

Brandie Tarvin (11/6/2012)

---

Matt Miller (#4) (11/6/2012)

---

Brandie Tarvin (11/6/2012)

---

For my next SQL Saturdays blog post, I'm coming up with a list of acronyms & definitions for accidental / rookie DBAs.

Anyone have...

Nothing wrong with a PK being non-clustered.

The reasons for clustered v non-clustered have nothing to do with PK/FK. They are separate concepts.

djackson 22568 (11/9/2012)

---

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

---

The "where" votes are nice, and we are looking at new locations, but we're also interested in knowing what you want to learn....

NULLgarity (11/9/2012)

---

Steve -

Regarding topics... I'm becoming more of a fan of case-study style material. Something that walks through a story; the type of problem faced, how the problem was...

SQL Kiwi (11/6/2012)

---

Steve Jones - SSC Editor (11/1/2012)

---

Interesting discussion. Freedman does mention inserts and deletes, but he never wrote on the subject. Perhaps he was mistaken, perhaps he hasn't had...

GilaMonster (11/3/2012)

---

Nevertheless, it is the case. A...

Maybe we'll get a feature match at some point.

Congrats, Simon. Well done.