Viewing 15 posts - 16 through 30 (of 402 total)
Hi Yes there is
Configure a second destination to a file or a table and set errored rows to redirect to this destination rather than fail the package
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 20, 2014 at 1:37 am
Both thank you for your time very helpful indeed , I was going with XML Explicit - am now on the right track
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 15, 2014 at 2:04 am
Hi Looks like your credentials are incorrect on the job:
"Login failed for user 'sa'."
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
May 14, 2014 at 2:48 am
Hi
Stab in the dark but I think your after:
WHERE (m.device='EM' or m.device IS NULL)
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
April 22, 2014 at 9:17 am
Hi Phil
Yep its really throwing me to and finding this is like looking for a needle in a haystack!
Tomorrow I will be trying This
Will post back once I've tried
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 20, 2014 at 10:55 am
Hi Phil
Again Thanks for taking time
Nope this is on the server and no, no other users can deploy and yep it affects all users and projects (admittedly there is only...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 19, 2014 at 11:28 am
Hi Phil
Thanks for the reply
All SQL Services use Windows authentication and I am logging in using Windows Authentication and have tried:
Running the ispak manually
Running the ispak from command prompt (Admin)
Running...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 19, 2014 at 10:16 am
Yep thats correct
You are only able to have 2 synchronous replicas and auto failover is only available on synchronous replicas
Its by design or you could auto failover with data loss...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
March 11, 2014 at 4:45 am
Run > type: Services.msc
Locate the service Right Click > Start
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
February 10, 2014 at 4:06 am
Koen Verbeeck (8/8/2013)
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 8, 2013 at 4:14 am
Hmm no takers? Looks like I will be the first person ever to try Partition Sliding with Always On..... 😉 :rolleyes:
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
August 2, 2013 at 1:57 am
Thank-You Abu, very interesting, I'l take a look through this.
I'm interested, do many people use this solution?
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 3, 2013 at 4:04 am
Hi
Difficult to help with the info given, perhaps this will point you in the right direction?
SELECT
e.BuProductName
,MAX(s.OrderQuantity) as Sold
,CAST(SomeDate AS DATE)
FROM
dbo.Product AS e
INNER JOIN dbo.Transact AS s
ON e. productID=...
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 3, 2013 at 2:41 am
Hi
Here is one way without using a CASE:
DECLARE @gross_amount VARCHAR (10) = '18'
SELECT CAST(COALESCE(NULLIF(@Gross_Amount,'NULL'),@gross_amount) AS DECIMAL(18,2))
Andy
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 3, 2013 at 2:34 am
I think there's a solution in one of the SQL Server Deep Dives books
Yep, this one
http://www.amazon.co.uk/SQL-Server-MVP-Deep-Dives/dp/1935182048
Excellent book!
==========================================================================================================================
A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe
July 1, 2013 at 4:38 am
Viewing 15 posts - 16 through 30 (of 402 total)