could you explain what you mean by "extend(ing) Microsoft Outlook's tasks list system"?  There may be others (me?) that may want to do this as well.

PERFECT!  I feared it would be that easy...

When you change the account to the new user, I bet you had to stop and restart SQL, right?  I am thinking that SQL was in need of a restart. ...

Well, I have never really done this, so, I only offer the following suggestion...

I guess I would start by right clicking on the db -> All Tasks -> generate SQL script, then...

Jeff,

I thought I could do it, but yes, I need your help - I need the the 0 counts to show up as well.

TIA!

Cory

how does index maintanance take advantage of muliti cpus?  does it do this "out of the box"  can one define what processes use what cpus and when?

Thanks Tim!

I know about the net send, and that is boring!  What I had was the ability to run a t-sql statement while connected to their SQL Server, and it...

Okay - this may seem like a no brainer question...but it has me stumped at the moment...

I have seconds in my time, and this causes the sql to not quite...

inside the actual SP, I have tried it both ways.  The current version does not have that statement, I have tried adding it, the begin trans and commit, I have...

I have tried this on nearly every computer...and what has seemed interesting is that when the machines are on the same subnet and or domain, this works...however, the cross domain...

I still have not fixed this - would still love to hear some more ideas / thoughts / things to try...

Cory

I found this web site (http://support.microsoft.com/?kbid=839279) that said to do the following to reproduce the issue:

SET xact_abort ON

GO

USE  pubs

GO

BEGIN DISTRIBUTED TRANSACTION

SELECT  *  FROM <remote_server>.pubs.dbo.authors

COMMIT TRAN

GO

and that does not...

The MSDTC service is running on both machines.  That reminds me, the new box (server_b) is a clustered sever.

The network guys tell me there is not a firewall between these...

Stax,

I am not sure I follow you...?