hung?  how long did it run?  How many rows in each table?  Did you try to run a profiler trace to see if you can capture any additional troubleshooting information?

I understand that you are admin on the box, however is the account used in the Windows Installer service also admin on the box or using the "system account" ??

I would guess the only reason for this would be some kind of blocking.  Next time you get this 3 minutes wait, run sp_lock to determine if your TRUNCATE TABLE...

Is the column you are joining on a numeric or character column.  If it is a varchar or nvarchar, you may want to ensure that you have the Linked Server...

rather than using a "cast" in your print statement, use a STR function.

ok, I read it again and saw that I misunderstood the first time.

like this:

select MIN(code)

from yourtable

having count(code) > 1

select MIN(nbr), code

from yourtable

group by code

having count(nbr) > 1

is that what your talking about???

I think your best bet is to return the "summary" row as a separate recordset (separate query).  Is this something that can be done?

Your data is a bit fried I think.  It should be in the format 2005-10-31 19:50:52.567

Your data is a bit fried I think.  It should be in the format 2005-10-31 19:50:52.567

select username, groupname

from tbl_users u

inner join tbl_groupmemberships gm on gm.UserID = u.ID

inner join tbl_groups g on gm.GroupID = g.ID

sp_columns

Why not just use MSX as a central server to manage jobs and then use Foglight on that server only?

Use DTS.  When creating a DSN use MS Excel for your provider.  It handles csv files nicely.

Carl, sorry to say... but you're wrong.  See...

http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;296769