The cursor will hold the record set in tempdb...

if you are looping on the table using a identity or some such column - this should reduce the overhead of storing...

try this

SELECT *

INTO #WrkTable

FROM OPENROWSET('SQLOLEDB','server';'user';'pass','SET FMTONLY OFF EXEC master..sp_sproc_columns')

and yes,

The procedural code within sp's is interpreted , the query plan only contains the execution tree for the SQLs (SELECT ,INSERT etc)

Yes procedures need to be compiled prior to execution .. but such a compiled plan (query plan) will stay in the procedure cache and will be reused or aged out...

excellent solution , never thought of that..

Sorry ,

yes that is correct , you should probably use "SET FMTONLY OFF EXEC master..sp_who" , this would avoid the temp table problem

you could use a select into ...

SELECT *

INTO #WrkTable

FROM OPENROWSET('SQLOLEDB','server';'user';'pass','master..sp_who')

This would fail with sp's that return more than 1 result set as output

I do not know any native T-SQL method to do this .. this information would be available from the client though..

if you are restricted to a SQL Environment - a...

Aldon , Simon - thanks for your suggestions .. I Guess the client will have to upgrade their support level, The vendor keeps passing the buck to MS...The MSDN website...

sorry - other way round

the two scripts below should give you what you want, the first one uses the SQL dmo object - and the other isql

EXEC master..xp_cmdshell 'isql -L;'

DECLARE @AppObj int

DECLARE @NmList int

DECLARE...

had a similar problem with temp tables using openquery .Don't know if this will help , but the metadata retrieval phase in the openquery function errors if the sp has...

Also the select distinct is not required - union would return distinct rows by itself

John -

i'm used to using derived tables in my selects - bad habit i've picked up 🙂 thanks for reminding me

is this what you are looking for

SELECT number0 , number1

FROM

(

SELECT number AS number0

FROM indecontb

WHERE index LIKE @idx AND

month LIKE @month0 AND

...