Changes, use DDL triggers.

Executions, either write your own logging Sprocs and include them or constantly trace for SP:Starting

My guess is there was a lock on the table.

Check sp_who2 next time this happens if you can catch it in the act. And see if something has the table...

How bout a constraint that if Count(*) >=50 then deny

Or insert trigger rather. Not sure if you can do that with a constraint.

You can do it with a check constraint....

If I were you I'd build a nested set representation of UserGroupUserGroups.

I'd then left join that to GroupUsers and left join your results to users.

Just do a search and replace for each single quote (') and make it 2 single quotes (''). 2 single quotes escapes one

Also, I know that Wheaties has no apostrophe....

I think what you're trying to do is insert a SQL string into a varchar text field.

You have to replace all the single quotes with '' to escape them [that's...

If I'm guessing right, you're trying to optimize for stored procedure recompiles.

If that is the case these aren't DDL (ie they don't CUD database objects).

Generally I've seen all DDL at...

Doesn't AdventureWorks come with a front end?

You can avoid sql injection by avoiding the use of dynamic SQL.

Don't have lines in your code like

set strCmd = "Insert into myMainTable(MostImportantInfo) ('" + Request.QueryString("hackmenow") + ")"

conn.Execute()

Replace these with...

Your accusation of a sweeping generalization is accurate, however in my experience there are more unskilled [read sloppy, inexperienced] generalists than specialists.

I haven't seen this as much of a problem. Yes I'm a specialist in portfolio analysis and financial data warehousing and reporting.

What does this really mean?

I'm a database developer, a...

Being familiar with both the nested set model [specifically Celko's push stack] and the CTE model, they each have their advantages and are relatively easy to set up. I recommend...

I call this one "Bear Sterns"

DEFAULT TRANSACTION

CROSS PUBLIC DECLARE DUMP GROUP

USE TRIGGER DUMMY