It is what it said. You likely created the trigger with different SET settings than the table.

Change ANSI_PADDING, redo the trigger and then it should be OK.

My bet is a lot of what will come out of this is how to collect, manage, store, and anlalyze a tremendous amount of data.

You would use an UPDATE statement to change the data.

update tableB

set tableB.col = a.col

from tableA a

where TableB.othercol = a.othercol

The query syntax you have for SELECT would be...

There is no way you can get any level of code done that you're sure does this for US$395. Even at the cheapest rates you'd use way more than that...

Search for "cross tab" as well. That's what this is.

This looks like it will prevent deleting ONLY if there is a value of "1" in the Locked field. The row isn't necessarily locked.

also, this is an INSTEAD of trigger,...

Is there a restore operation occurring? It could be in STANDBY, which would allow read connections to it. You would need to remove those connections. Either tell people to disconnect...

I think it's a transient error. I know I got notified of a PM yesterday in email.

You can delete PMs, so the link isn't guaranteed to work. You can click...

Jim

Agree with you there. I was surprised to learn this, but I also wouldn't want my instance stopping because of tracing. The data is lost, perhaps there should be some...

An out-loud chuckle was heard in the office this morning. Very nice story!

You don't need separate endpoints.

For the witness, it can be anything, including a desktop running Express. No reason not to run one somewhere.

I'd agree with David that in the short term, on a project or two, the mega hours help you. I've worked overnight on SQL issues at times and I've learned...

Hey, I have a lot of those skills!

Actually going to work on them now as a break from work. See what the horses have left. :w00t:

This isn't T-SQL code. It's VB Script, so you can't use CAST. You could use a VBscript function, such as CDBL

http://msdn.microsoft.com/en-us/library/3ca8tfek(VS.85).aspx

SQL server has a listener that must respond to connection requests. The listener has to "take" a port from the OS when SQL server starts up. If you look in...