You could setup a vbscript to check if the service is running.... 

Something like this (for Apache Tomcat):

strComputer = "."

Set objWMIService = GetObject("winmgmts:" & _

 "{impersonationLevel=Impersonate}!\\" & strComputer & "\root\cimv2")

Set colServices...

Yes, the three metods (Stored Proc, view and table) Work very well... but if you put a "INSERT INTO" in front of it, only the "table" works!

But... Why this works

insert INTO MyTable

select MyID,Submitted,Reviewed

from TheOtherServer.TheOtherDB.dbo.TheTableName

order by MyID

But not this:

insert INTO MyTable

select MyID,Submitted,Reviewed

from TheOtherServer.TheOtherDB.dbo.TheViewName

order by MyID

???

Something like that?... you left-join and only return the record that did not have a parentID....

SELECT Question.QuestionTreeUID, Question.ProjectUID, Question.ShortDescription

FROM dbo.tbl_NSP_QuestionTree Question

LEFT OUTER JOIN (

 SELECT ParentUID

 FROM tbl_NSP_QuestionTree

 WHERE tbl_NSP_QuestionTree.QuestionNodeTypeUID...