Thanks both for the explanations.

Thanks I'll read the article.

Hi everyone. jrv found the solution to this one.

Changing the query to insert the values solved the problem.

$sql = "insert into STG_Results(ServerName,NodeName) VALUES('{0}','{1}')" -f $node.ServerName, $node.NodeName

Thanks again for your...

I'm sorry Thomas, I see now that I missed a line in the original script.

I had to define the variable as an array first like this

$results = @()

$results.GetType() returns this:

IsPublic IsSerial Name ...

Hi Gary. I never got it working.

Instead of inserting the ServerName and NodeName in the database it just inserts this for every line:

System.Data.DataRow.ServerNameSystem.Data.DataRow.NodeName

Howard

We found that opening the DTC transaction was part of the iBATIS Framework that the application was using. The developer changed the database command to execute the stored proc...

I see! Because it is ad hoc it is compiling a new plan each time it runs.

I have created a template from the query but the last component, TRANS_DATE_TIME >...

Thanks Kevin for responding. I'm not sure what is meant by textual.

So I think the reason it acts differently when run from the agent job is because the job history is showing what was returned by the remote server which is...

The sys_updated_on column is datetime2(7)

I think that the suggestions to explicitly format the data that is going into the varchar(10) column will solve the problem. It is really a...

it seems that it did maintain the LF character after all. It did not show up in Management Studio grid queries but when I output the query to text,...

That is a nice idea. I modified it a bit to make it more useful by excluding offline databases, combining the results, and adding the database name to...

For some reason, the min_memory_percent of the OLTPPool and ReportPool were both 50 which seems like a typo. That must have caused the system to be starved and lead to...

I found that resource governor had been enabled on on the instance in an attempt to restrict ad hoc queries from impacting the application. Apparently the configuration was starving the...