Does anyone know what the extended store procedures:
sp_cursorprepexec, sp_cursorprepare
what do they do?
what are they used for?
The sp_cursorxxx procedures are internal system stored
procedures used for API server cursors. They are invoked and
used by the data access APIs (ADO, ODBC, OLE DB etc).
There is more information on the specific functions of some
of these in books online under API Server Cursors.
-Sue
On Wed, 14 Apr 2004 04:41:34 -0700, "cs"
<anonymous@.discussions.microsoft.com> wrote:

>Does anyone know what the extended store procedures:
>sp_cursorprepexec, sp_cursorprepare
>what do they do?
>what are they used for?

Does anyone know what the extended store procedures:
sp_cursorprepexec, sp_cursorprepare
what do they do?
what are they used for?The sp_cursorxxx procedures are internal system stored
procedures used for API server cursors. They are invoked and
used by the data access APIs (ADO, ODBC, OLE DB etc).
There is more information on the specific functions of some
of these in books online under API Server Cursors.
-Sue
On Wed, 14 Apr 2004 04:41:34 -0700, "cs"
<anonymous@.discussions.microsoft.com> wrote:

>Does anyone know what the extended store procedures:
>sp_cursorprepexec, sp_cursorprepare
>what do they do?
>what are they used for?sql

Does anyone know what the extended store procedures:
sp_cursorprepexec, sp_cursorprepare
what do they do?
what are they used for?The sp_cursorxxx procedures are internal system stored
procedures used for API server cursors. They are invoked and
used by the data access APIs (ADO, ODBC, OLE DB etc).
There is more information on the specific functions of some
of these in books online under API Server Cursors.
-Sue
On Wed, 14 Apr 2004 04:41:34 -0700, "cs"
<anonymous@.discussions.microsoft.com> wrote:
>Does anyone know what the extended store procedures:
>sp_cursorprepexec, sp_cursorprepare
>what do they do?
>what are they used for?

*.msg files cannot be searched in SQL 2005 without extended MAPI

Hello,

I have a table where I store *.msg files. I wanted to use full text search capability within SQL 2005 to search within the *.msg files for its content. There are filters that I can use to do that.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=254432&SiteID=1

But, there is a problem - the problem is that for any of these filters to work one needs extended MAPI on the SQL Server Box.

This is highly undesirable to any DBA as the only way to install extended MAPI on a box is to either install the outlook client or an exchange tool.

Any suggestions as to what one can do - whether I am right in the first place regarding extended MAPI? Is there any other way to install it apart from what I have mentioned? Any clues?

Thanks in advance

Anshuman Singh

Have you looked at what is on offer at http://www.indexserverfaq.com/iFilters.htm