*= Notation in 2005

Hi,
I've heard a rumour that the *= notation is no longer supported in SQL
Server 2005. I've searched through the knowledge base but can't find any
articles on it. If anybody who currently has 2005 could confirm whether it
is or isn't supported that would be great.
Thanks,
David.
Hi David,
*= and =* are NON-ANSI standard LEFT and RIGHT OUTER joins. THis is
supported only in the compatibility level 80 (SQL 2000) and lower versions.
If the database compatibility is 90 (SQL 2005) then you may need to right
the query using LEFT OUTER JOIN or RIGHT OUTER JOIN.
Thanks
Hari
"David" <David@.discussions.microsoft.com> wrote in message
news:6E05EAFB-595B-4E64-9267-563A825B0644@.microsoft.com...
> Hi,
> I've heard a rumour that the *= notation is no longer supported in SQL
> Server 2005. I've searched through the knowledge base but can't find any
> articles on it. If anybody who currently has 2005 could confirm whether
> it
> is or isn't supported that would be great.
> Thanks,
> David.
>

*.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