Search results for query: *

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

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

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

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

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

So, this is not really a c# question but as I am going to create a CSV file or similar from c# I post this here anyway. I have some data that end user wants in a CSV file. Each entry has a parent node data and zero or more child node data. For example, parent node might contain Name, Id, Date...

I have this SQL: select c.Name,cu.CompanyName,OfficialId,OrderOption, c.code + o.VATId as VATId, cast(round(TotalPriceIncVATSEK,0) AS decimal(10,0)) as Price,pp.Name as PaymentProcessor from [order] o, customers cu, countries c,paymentprocessor pp where paid = 1 and o.vatid !='' and vatadded =...

I have developed a Task scheduler for Windows. I have been selling it for a while. About 50% of customers are from the US. The company is just me. I feel a strong need for marketing but I don't know how. I have of course been using Google adwords but I find that I want to reach out new ways. My...

I am able to create a dataset. But when double clicking on a table from Server explorer (to add it to dataset) I get error: "The specified module could not be found. (Exception from HRESULT: 0x8007007E)". This fails in my Visual Studio 2010 however it works in Visual Studio 2008. In both...

I have a table that consists of emails. As you know email consists of prefix@domain.extension. I wonder if it is possible to construct and sql thats sorts on the domain name and forward? For example: xerxes@domainA.com alpha@domainB.com thanks!

I have a lot of changes that I need to do manually. I have a very specific query I want to perform to pinpoint rows I need to edit. How can I make the grid editable on my custom query? I know that I can select "Edit Top N rows" but I do not want all rows, just rows from my specific query. There...

I am not sure what have happened but all Windows commands (in command window) like "telnet" and "ping" has stopped working with error: "'telnet' is not recognized as an internal or external command, operable program or batch file.". It might have something to do with environment Variables - I...

So, I started up my computer today and that wen't fine, checked mail, surfed the web. After 3 minutes the screen went blank. Here is what I have done so far; 1. I rebooted and no signal was sent to monitor 2. I ran to the store and bought a cheap PCIe graphics card - no difference 3. I...

I have 2 drives. My OS on C and other bigger drive on F. In my bios the F: drive is set for boot. When I try to change to C: it gives me boot error. It seems like some files or settings on C: is missing - I would like to boot from C: and cut the dependency to F: How can I do that? Thanks!

Hi, I need some help with a regular expression. I want to replace everything within a string except numbers and periods. In my example I am having a version string that looks like this: "3.5.4 (en-US)" I only want the remaining part to be: "3.5.4" Thank you for your help!

I am running a Windows service as localsystem. Sometimes I need to write and create files and use impersonation to do that to get permission. The problem I am having is that the impersonated user does not become the owner - but local system becomes the owner. How can I control this?