David

You could dump what you need from Inserted and Deleted into a temp table and see whether you can access it from there. Be very careful what you do...

Good point. Wouldn't it be best, though, to use an international standard where it exists, even if it's in a different alphabet from the rest of the database? ...

That's a good catch, Anthony. In case it isn't that, I'd be tempted to write it out longhand, 26 times, just to avoid all those confounded quotation marks. ...

Sergiy (11/20/2015)

---

Sean Lange (11/19/2015)

I would hope that for lookup tables like states and currencies you don't use a guid as the primary key. The ANSI abbreviation is an excellent choice...

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...