L' Eomot Inversé (3/8/2012)

---

Jack Corbett (3/6/2012)

---

Koen Verbeeck (3/6/2012)

---

cvyc06 (3/6/2012)

---

You are right. Not just here but in almost every forum I see an increasing number of questions on...

Yep, Jeff is correct. Scope_identity(), and understand that if the next identity value is 12, and the transaction fails, the next one inserted will be 13. The identity increments are...

Hope not, but more than a few have...

Be careful with this. Lots of people start out with this requirement and once they 50 emails in an hour, they decide it was a bad idea.

What you might want...

True, and we certainly would...

MiguelSQL (3/7/2012)

---

Hello,

Two things:

1- Restarting SQL in single mode (using the -m flag) will allow any person that is a member o the Windows Local Admin group to be automatically a...

Personally I like the DH and the offense it brings. With the specialization of pitchers hitting only once a week, it's almost like a wasted out in most cases and...

What browser/version?

You don't really "name" then the schema. I guess you reference them that way, but really you are grouping them, just like a role.

Objects have an owner, separate from the...

I prefer all feet to be kept away from my mouth.

Eric M Russell (3/5/2012)

---

So you're saying that the project requirements should include a document or Excel sheet that explicitly list what accounts / roles should be deployed in production and...

@eric, not knocking your process in terms of what it does. I'm more concerned with the issue of actually understanding what permissions are granted and potential holes. Comparing against a...

Slightly confused.

The maintenance task should be in an SSIS/Maintenance plan package. It isn't a job. The job would be the item that schedules and runs the package/plan.

Also, what changes did...

Eric M Russell (3/5/2012)

---

Databases have a much smaller surface area for security breaches than do Web applications. For a database, you're basically concerned with how accounts, role membership, or object...

Someone said last week that every Saturday until Oct will now have baseball.

First scrimmage yesterday. Good to be back on the field. Misjudged a deep fly in the wind, got...