Viewing 9 posts - 61 through 69 (of 69 total)
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...
August 8, 2007 at 12:19 am
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...
August 28, 2006 at 2:57 am
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...
August 17, 2006 at 12:22 am
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...
August 10, 2006 at 11:43 pm
Pasted as is
it returns the whole select statement
August 10, 2006 at 8:37 am
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...
August 8, 2006 at 2:36 am
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...
August 8, 2006 at 2:36 am
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...
July 6, 2006 at 12:54 am
Thanks a lot guys
appreciate the help
February 26, 2006 at 11:35 pm
Viewing 9 posts - 61 through 69 (of 69 total)