SQl statements
Exchange Server Forum Index Exchange Server
Discussion forums for Microsoft Exchange Server users.
Microsoft Outlook
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web ExchangeServerHelp.com
SQl statements

 
Post new topic   Reply to topic    Exchange Server Forum Index -> Development
Author Message
MS
Guest
Posted: Fri Nov 12, 2004 2:51 am    Post subject: SQl statements Reply with quote
Where is the good place for sql syntax for quering Exchange server. I need
sql to search thru emails in subject line for particular key. Also how do I
select all fields when using select statement in Exchange (like select * ...
in SQL server).

Back to top
Glen Scales [MVP]
Guest
Posted: Fri Nov 12, 2004 10:21 am    Post subject: Re: SQl statements Reply with quote
The Exchange SDK documents all the available SQL functions and syntaxes
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/e2k3/e2k3/_exch2k_sql_web_storage_system_sql.asp

Select * wont get you all the available properties on a message you better
of looking at Exchange Explorer (which comes with the SDK) and using Mdbvu32
or Outlook Spy (for MAPI properties) to work out which properties you want
to work with.

Cheers
Glen

"MS" <slavyan@hotmail.com> wrote in message
news:OESNkCDyEHA.3840@tk2msftngp13.phx.gbl...
Quote:
Where is the good place for sql syntax for quering Exchange server. I need
sql to search thru emails in subject line for particular key. Also how do
I
select all fields when using select statement in Exchange (like select *
....
in SQL server).

Back to top
 
Post new topic   Reply to topic    Exchange Server Forum Index -> Development All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




Windows Server Dedicated Servers
New Topics Powered by phpBB