Search results for query: *

Thanks, that worked! Here is the query I ended up with using: select Month(o.TradeDate) as TradeMonth, Year(o.TradeDate) as TradeYear, Count(*) as QtyNewCustomer from [Order] as o where paid = 1 and not exists (select 1 from [Order] as s where s.CustomerId =...

Thanks, but unfortunately that did not work. I got different errors. Missing group by. Also, the table name is [order] and not [orders]. The column orderid does not exist. I tried to fix to the following but no rows where returned: select Month(o.TradeDate) as TradeMonth...

I have an order table with customer id and tradedate. I would like to get statistics about number of new customers for each month. I defined a new customer by an order row with a customerid I have not counted before. I am not sure if this is possible through SQL only. Here is my sample query...

What does this output mean, that junk-filter is not enabled: [PS] C:\Windows\system32>get-mailbox webmaster | fl *junk* SCLJunkThreshold : SCLJunkEnabled :

Thanks!

How can I disable password expiration for one or more users?

Hi, an important email is moved to the Junk folder of a mailbox. I do have black listing enabled but I do not think it is that component that moves a specific mail to the Junk folder. 1. what process is moving it? 2. how can I exclude a specific sender? Thanks

Thanks, sorry for the late reply. I turned off anonymous and it started working.

Thanks, I found out this link which explains how: http://technet.microsoft.com/en-us/library/cc772007.aspx

Thanks! Please let me know if you can help me with my basic question about adding new domain as well? :(

I am new to Exchange 2013. I first created a default domain xxx.com. Then I wanted to add a second domain yyy.com. Here is what I did: Mail flow->Accepted domains->Add Mail flow->Email address policies->Added second domain Still, when I try to add a user I only have one domain I can...

Thanks, it was resolved!

I thought I did everything to get IMAP work working but apparently it is not enough. What I have done is to set services to auto start. I am able to telnet to port 143 on that server and it answers ok. I have verified that IMAP is enabled on the user in the administration console. The problem...

Great - thanks!

Thanks, do you know where to change the drive/folder?

Is it possible to control where the actual emails are stored?

Is it possible to control where the data files are stored?

I have a folder on my website I want to protect with Windows authentication. The problem I get is that the prompt is re-appearing - like the credentials are not correct. But when I look in the event viewer I see an audit success. I am using a local Windows user to authenticate. In IIS->On...

I was recently demoed prweb.com solution for entering a number of keywords and then be presented with twitter posts, rss feeds and other sources (do not remember now). I wonder if there is any good service for this, except prweb (maybe you have comments on that service as well). I basically...

Ok, thanks for the suggestion!