I don't know why your syntax isn't working, but you could try something like this instead. It's not mandatory to name your constraints, but I recommend you do so...

Goodness! Looks like two spam posts. I've reported them both.

Before you do anything else, please run DBCC CHECKDB against the affected database and post the results.

John

The FROM needs to appear at the end of your column list.

I recommend that you format your code with indentations and white space. It makes it easier to read...

Create a unique index on VhID and ExtID and on ExtID and PrID. You might consider converting one of them to the primary key. Remember your primary key...

Sam

Probably not all that easy. Please see this blog.

John

Do you get extra points for the readability of your code? If you do (and in fact even if you don't), I'd suggest putting a few line returns and...

Bill Talada (10/30/2015)

---

I have replaced all chars in my databases with varchars because of the weird object-like method handling they have:

-- funky handling of chars

DECLARE @c char(5);

SET @c = 'ab...

Have you looked at the execution plan? Please post it here if you're having difficulty interpreting it.

John

I suppose if your Log Reader Agent is reading from the logs then access is no...

Segregated from database files, not from other log files in the same database.

John

Just a word of warning - don't disable a clustered index. Because the clustered index is the table, disabling it will mean you won't be able to get to...

Toreador (10/30/2015)

---

The correct answer should be END TRY - the completion of the try, which scores 5 points in Union, 4 in League. The Try Conversion (TRY_CONVERT) then scores an...

Index names aren't unique across the database. You must have an index called part_needi17 on a different table.

John

Is it the name of the column in your result set you want to change? If so, do it in the way Chris first suggested, or in the way...

ALTER DATABASE

John