Not a problem

Your probably best getting in touch with Microsoft directly, I can't find no reference on the datazen website in relation to licensing.

Are they all in the same filegroup or different filegroups?

If different might be done for piecemeal restores.

Base

How are you changing the service accounts? Services.msc or SQL Server Configuration Manager?

My 2 cents

declare @stemp varchar(50) = 'fl,ca'

create table #csvtest (name varchar(5), states varchar(10))

INSERT #csvtest(Name, States) Values('Joe','CA,FL,HI')

INSERT #csvtest(Name, States) Values('Mark','FL,MI')

INSERT #csvtest(Name, States) Values('Greg','MI,AR,AL')

INSERT #csvtest(Name, States) Values('Mary','AL')

INSERT #csvtest(Name, States) Values('Frank','AL,AR,WI')

select * from...

Or you could try this aswell

http://www.sqlservercentral.com/scripts/T-SQL/69207/

Care to post the solution for others who may have the same issue?

To get Nexus to import trace file on my system I have to disable event requirement checks

johnwalker10 (11/2/2015)

Fix the statement to read like this:

ALTER...

Is this what you need?

create table #customer

(id int, name varchar(10))

create table #logs

(custid int, checked datetime)

insert into #customer values

(1,'cust1'),

(2,'cust2'),

(3,'cust3')

insert into #logs values

(1,'2015-11-01'),

(2,'2015-10-01'),

(3,'2015-01-01')

select

*

from

#customer c

left join

#logs l

on

c.id = l.custid and l.checked <=...

Sounds vaguely like a catch all query, where parameters can be null and not all need to be specified to execute the stored proc

Maybe Gail's article will help http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

S.P.E.C.I.A.L

Cross posted follow on question

http://www.sqlservercentral.com/Forums/Topic1732853-391-1.aspx

C:\Program Files\WinRAR\rar.exe a -r C:\bcp\customers.rar C:\bcp\Customers.csv

http://comptb.cects.com/using-the-winrar-command-line-tools-in-windows/