I'm sorry, this was never resolved.

The Service Broker piece was a small part of a massive corporate conversion project that had fundamental flaws. The entire project failed and never...

Despite both references (including MSDN) stating that the Database class can be used to create a master key, it doesn't appear to be an outright ability of the Database class....

The code posted does not gracefully handle empty strings and spaces in the fields. So, every column should be wrapped in NULLIF if there are not a column constraints...

Below is an example of how this might work. The calendar data that I entered reflects a typical US school calendar for January 2017, with holidays on January 2...

never mind, replying to post from 2012

The table tbl_bookings is outer joined. Thus, every reference to columns from that table must allow for the column to be NULL. The WHERE clause references to tbl_bookings must allow...

Seriously, get a new job ASAP.

Someone has been looking to "get you", and the new database gave that person an excuse. You told your boss that you can't do your...

Charles Kincaid (11/20/2016)

---

I do have a slight case for denormalization. I want to have an unchangeable representation of something historical. Where did we ship that order and to...

That would...

The maximum numbers are not near the thresholds, but rows that have been deleted and rolled back also increment the identity. Please run this query and post the results:

SELECT IDENT_CURRENT('MAP_MONTH')...

Googling this error gives widely varying results. There are different kinds of scenarios that cause it, some of which are fixed by cumulative updates.

I suspect this is SQL Server's way...

I see two possible issues here.

First (and most important), SQL is probably returning multiple errors, but you are only seeing the last one. When SQL does this, the first one...

I've been using Google Maps for "directions" every day, not because I don't know the way to to work, but because Google does a better job than I do of...

Memory optimized tables are fairly new to me, and apparently to the third party who has written these procedures. While investigating this issue, I saw the retry logic recommended. No,...

Surely this procedure exists elsewhere. Here are a few places to look:

- Source code control

- Database backups

- Local copies of this database on developers' computers

- Copies of this database on...