Hi Roust_m,

IMHO, introducing over-the-network distributed transactions is going to make your problems worse. And, what do I base this opinion on? Just gut feel, so you're well...

G'day Frank.

Absolutely. I turned it on once, for 5 minutes, just to see what we got. Yuk!

BTW: I'm no longer getting email notifications "whenever...

Try something along the lines of:

 

select InterviewDate, PostId, 

    Selected = ISNULL(SUM(CASE WHEN status = 'Selected' THEN 1 ELSE 0 END),0),

...

I used to do similar under SQL 7.0, but SQL 2000 made it much easier, with something like:

 

USE PUBS

ALTER DATABASE Pubs

   ...

I can't replicate the error. I don't have tbl_disk_SQL1, so I tried with Authors from Pubs. ie:

 

select * into #drive from pubs..authors...

Chris,

I know you said you don't need to, but I can't let go of this one ... You can make the code cater for both single- and...

In what way will the SELECT clause change? Just the column name and where criterion? Will it always be just the 1 column selected, and just 1 column...

Can you post your trigger code?

Cheers,

- Mark

It could be because you have remove BUILTIN\Administrators from login. In which case you see an item count of zero when you view the properties of the FT (StevenBCatalog)...