yes it does check if the server is alive, but I think polling is to check if the SQL Server Agent is running. We have mutilple scheduled jobs running on different...

Thanks a lot for your assistance I totally give up

all these errors are just becoming to frustrating

Thanks again!

ERROR ERROR ERROR ERROR ERROR ERROR ERROR ERROR

(Server: Msg 103, Level...

I realy apreciate you help thanks a lot i'm sure this must be becoming irritating

but although the query runs but the correct results are not displayed and their is...

It does go through all the servers but then returns the the entire select statement

example this is what it returns: any help

Exec [Testsrv3].Exec sp_Msforeachdb @command1 =  "Select o.name,u.name,o.uid   from [?]..sysusers...

Pasted as is

it returns the whole select statement

It doesnt seem to work even if i remoServer: Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'EXEC'.

Server: Msg 170, Level 15, State 1, Line 4

Line...

It doesnt seem to work even if i remoServer: Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'EXEC'.

Server: Msg 170, Level 15, State 1, Line 4

Line...

Thanks alot guys

esp Kumar Singh ur sp works fine just needed to insert an @command1 after the SP thanks a mill

set nocount on

create table #owned (objectname varchar(500))

set nocount on

create...

Thanks a lot guys

appreciate the help