If you specify @sync_type='none' in sp_addsubscription, it seems SQL Server does not call sp_MSrepl_setNFR and mess up your foreign keys. This comes up in a different context (replicating to...

Of course if your server has a case sensitive collation, you'll get an error because #Test <> #TEST.

Regarding Steve from Fairfax's function-based solution... I agree that it is clear and pretty simple. However I think it may have concurrency and possibly integrity issues. You can...

(Posted this before reading "page 2" of the discussion... looks like this is the same as Jason Hannas' solution):

Along the lines of athosfolk's note regarding use of a foreign key...

To Anjali regarding an Oracle version:

Going back at least to 9i, Oracle has Analytic functions that are designed for just this sort of thing. Here's how you could do...

Thanks for the article! It reminded me of an issue we encountered. If you happen to be using the JDBC driver with mirroring, there are problems with automatically...

First, thanks for the comment about object_id('tempdb..#t'): I did not realize that would reliably work. I was afraid if 2 sessions both had a #t, object_id() would have the...

Thanks for this enhancement! I have always been reluctant to use the "select @var=@var + col from tbl" construct, for fear of it stopping working in some future release....

In case anyone running SQL 2005 reads this thread, I want to note that there are other ways to do the delimited string thing in SQL2k5. For example, this...

Noticed the comment about monitors using as much with screensaver as running Office. Here in Wisconsin (USA) our public library system allows us to borrow a throughput meter (the...

Did you experiment with SQL 2005's xml indexes?  I wonder if they could be used in the sample last name query of the view...

Seems there should be some mention of the SQL Server bit data type, which internally is implemented as a bitmask.  I guess it's a matter of opinion whether a single...

It can be helpful to use the GetUTCDate() function, which returns current Universal Coordinated Time/ Greenwich Mean Time, based on the local time and timezone settings of the server SQL...

If you just need to identify IF a list of numbers is in sequence, but not where the gaps are, I believe you can do it in a single pass...