Thank you. Now SP not found error has stopped. However, sometimes, I do get #table not available whereas the same is available or when the same function...

I have a situation where this happens as the store procedure is called from multiple places and a particular situation demands multiple transaction opening. The problem happens only...

Dear Kenneth

It is not actually giving sp_OAxxxx to public.  As an example I have given.  I have tried with Unicode, it does not work.   However, I have managed to find...

is there any document or any url link available which can be refered to sort this problem.

You can SQL Profiler to find out exactly where the problem is.  You can also use blackbox to find out where the problem is.  But blackbox tracking will slowdown the...

Thank you for the suggestion.

Thank you Ian....

Hi Sridhar

In the name box drop down after selecting the row/col specify the name as table1.  If you have 4 columns in your table then choose 4 cells e.g. a4...

Attach the Excel Sheet and then you can use it like a table.  In order to attach the Excel Sheet use the following :

CREATE PROCEDURE attach_excel

    @file_path nvarchar(4000),

    @alias_name...