Outstanding article, Hugo. Very clear examples, both the overly simple one to illustrate the problem and the more complex one to show a real world scenario.

Hartelijk bedankt!

Good question. Learned something already this week -- and it's only Monday!

Replication often feels like a mysterious, black-magic operation that is too intimidating to understand. Your question highlights the fact that it is really just a bunch of tasks (agents) and...

Lowell is exactly right. I would just add the following:

You may need to be aware of what is expected by any applications that may access your table. Now, if you...

The referenced article states that you cannot perform DBCC CHECKALLOC or DBCC CHECKCATALOG on tempdb. I presumed that since DBCC CHECKDB performs both of those functions (cf. http://technet.microsoft.com/en-us/library/ms176064.aspx), one couldn't...

http://technet.microsoft.com/en-us/library/ms188332.aspx

The answer (in SQL 2012) is to use the 'WITH RESULT SETS' option on the EXEC statement.

See http://technet.microsoft.com/en-us/library/ms188332.aspx for specifics.

Good question. Thanks.

Great question. Learned something....again!

sneumersky (4/29/2013)

---

... Not much harm was done to the family, but I (re)learned two good lessons:

1. Haste makes waste.

2. Trust Microsoft documentation, but verify it as...

Great question, Hugo. Thanks.

Excellent question. Drives home the point that, even if an insert fails on a table with an identity column, the identity value is 'consumed'.

Well done.

Great question!

Thanks!

Great question. Thanks!

Chicago? (SQL PASS...