I don't believe this is possible. It seems like when RS exports the data, it does data only... and sometimes does some interesting things with column spanning cells too....

@@ROWCOUNT returns the number of rows impacted by the last statement, which in this case is the OPEN. The OPEN didn't impact any results, and that is why you...

I noticed a couple things that might help

The trigger is on oe_hdr, but you never reference that table, nor the INSERTED or DELETED tables. So the trigger will execute...

I'm not sure what to tell you then. We're storing the credentials since users did not have direct access to the database, so our environment really isn't the same....

That is probably right. It sounds like you've run into this problem before. Are all the boxes (client, RS, DB) on the same domain?

Chad

Looks like authentication. Does the Windows account you are using on the remote computer have access to the database? Try switching the connection in the data source from "Windows...

Both @@IDLE and @@CPU_BUSY sum idle and busy across all CPUs. @@TIMETICKS enables you to scale to the processor, but you have to divide by the number of processors...

Thanks Ninja, it's nice to have a list. I'm going to set a goal to post regularly, and I should catch up with you in... well... never. But...

Let me clarify a little bit....

sp_monitor returns multiple resultsets, which are tough to deal with inside MSSQL... a little easier if you are using a client, but that's probably not...

Could you add the cpu_busy and idle from sp_monitor? You would have to parse it a little to get the value total values....

Chad

Can you combine all the queries into one? Create a view that incorporates both the query for creating TableA and the comparison with tableB? That would give you...

Does this work for you:

where TAG like '%' + @EnterAlarm + '%'

Thanks,

Chad

Can you connect if you type the name in directly? If it is a named instance, check to see if the SQL Browser service is started on the server.

HTH,

Chad

I don't think these will necessarily return the same results, but I'd have to go back and study up to really be sure. You've maintained all of the logical...

I'm not sure I completely understand, but I think this will give you the result you have in the last table:

SELECT t2.c1, ISNULL(t1.c2, 8)

FROM t2 LEFT JOIN t1

ON t2.c1 =...