Try changing the job owner to something else, and then back to sa.  This sometimes happens when moving domains and when the owner can't be resolved, it's displayed through EM as...

hmmm, sorry, I missed the fact that you mentioned ALL occurences of POLYGON.  It gets a bit more complicated, and the following code won't win you any points for "high performance...

Hi James,

I don't know if this is useful, but this example assumes a PK (or UNIQUE identifier) called "id" on the table....

create trigger tr_MyTable
on MyTable
for insert, update 
as 
if not...

James,

A bit trickier than normal triggers because TEXT fields aren't made available in the INSERTED table, and also the problems associated with manipulating TEXT fields.

For each row in INSERTED you'll...

1. There's a "firehose cursor" in SQL 2000.  It's a phenomenon arising from the interaction of SQL2000 and clients (generally Enterprise Manager).  It's something I've come across only a couple...

This is the sort of syntax I usually use:

declare @rows1 int

exec sp_executesql N'select @rows2 = count(*) from master..sysobjects', N'@rows2 int output', @rows2 = @rows1 output

select @rows1

I've used variable names...

It will work with a cluster.  In a default instance, all nodes - when active - will listen on port 1433.

In a named instance, nodes will listen on another chosen port...

The following KB article does discuss nvarchar, but only in giving an example.  Hope it helps.

http://support.microsoft.com/default.aspx?scid=kb;en-us;827366

To add to that, your consultant would probably have UDP port 1434 exposed to the Internet as well, so that EM on your developer's workstation could "discover" which TCP port...

I'd suggest using profiler to capture all SP:StmtStarting and SQL:StmtStarting to see where it's hanging. 

Of course, try this with an appropriate hostname filter or when there's zero/minimal other activity on...

I think there's a bug in the QOD engine. 

I'm sure I chose "There is no difference as they both exist in tempdb" option,...

Paul,

Did you try disabling your LAN connection?

Congratulations MVP Kalis.  A well-deserved honor, and a bit of payback for the selfless help you've given others over the years. 

And congratulations on the new baby Kalis too.  If...

I wouldn't think it's possible.

I'd say you're better off with one of the several "log mining" utilities available.

When doing a manual transfer of the small data sets (up to 30MB) on each node, is there any significant difference in speed/throughput?