Thanks for that, but what i need is to incorporate it with the Osql -L so I get those details for every server on the network

Thanks, worked a treat

Thanks remi, works a treat

I have 2 queries.

select dept,count(user)

from dept

select dept, count(user)

from dept

where code = 'XP'

tried combining  -

select dept,count(d.user),count(e.user)

from dept d, dept e

where code = 'XP'

but I get the same results in...

Thanks Remi

but I will I the insert the data from the othe tables.

What I am after is a way to insert all the data ie. get the site_id,time_id and min value...

Marty, thanks for your help, but what I need is the actual T-SQL code, so what I declare, what the code is. I need help with the T-SQL.

Thanks

How would I write the trigger? what would be the T-SQL

Thanks

Thanks, hope you have a good weekend too

Tried logging on as 'sa', same result,

version : SQL Server 2000 standard  - 8.00.760

I am inclined to think it a Win NT4.0 workstation issue. I just need someone to confirm...

Different accounts,  but both had sysadmin permissions.  

Worked a treat

Thanks a lot

This is the error message when the job is run

error string:unspecified error

error source: Microsoft Jet Database Engine

help file:

help context:500000

error detail records: error -2147467259 (800004005);provider error 0(0)

error string:unspecified error...

Thanks for all your help, finally got it working

Thanks again

Cristiano, what is the error message?, it doesn't appear on the post