Hi,

After creating the SP in server, under a database, when the sp is executed it is giving an error msg:

Invalid object name 'tempdb.sys.objects'.

I removed tempdb and made sys.objects as sysobjects, then when executed, it gives error:

(9 row(s) affected)

Server: Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near ' '.

Server: Msg 208, Level 16, State 1, Procedure SP_Get_Query_HTML, Line 37

Invalid object name '##tempHTML2'.

I am executing this statement:

exec SP_GET_QUERY_HTML 'select top 10 * from Sample '

What is wrong in this? Why is it not working?

Also, where is the output file generated?

-Anukul