-- Msg 7357, Level 16, State 2, Line 1
-- Cannot process the object "EXECUTE EAVTS0042.MSCRM.dbo.sp_who2". The OLE DB provider "SQLNCLI" for linked server "EAVTS0042" indicates that either the object has no columns or the current user does not have permissions on that object.
Is this the best way to process the resulting table from a sp? I'd prefer to avoid to create a temp #sp_who2Table, but if that is what it takes ....
SQL Server 2005, logged in as sa.
Last edited by Wim; 09-01-09 at 11:24.
With kind regards . . . . . SQL Server 2000/2005/2012
Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2. Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages