I think the big questions that come to mind are:

1 - are you fully patched?

2 - is the latest .NET installed?

3 - how are you calling the linked server?  Is...

To me it looks like it isn't a SQL Server issue, but something with "PIPC" or "pisdk".  Not sure what those are, but google makes it look like it is...

There is a lot of area to go with your question.  Not seeing high CPU, memory, or disk queue may or may not tell you much.  For example, if your...

Looks like a permission related error to me.  Since it works with the local account, it is probably configured to allow that account to view contents (browse at a minimum),...

Personally, this feels like a job for powershell, not SQL Server.

Just because SQL Server CAN do it, doesn't mean it SHOULD do it.

SQL Server is a database engine and you...

As a thought - are you sure it is the conversion that is causing the slowness?

What I mean is what if you take out the INSERT INTO statement and just...

I am not certain on the default trace, but I think you could set up an XE session to capture that.

How is the tool running the drop script?  I am...

Everything you listed plus support and more features (SSRS, SSAS, SSIS, etc) and scalability.

Commercial tools, in general, should perform better than the free tools when properly configured.  An improperly configured...

SSDT, if I remember right, allows for a lot of different things you can do with it including, but not limited to, SSRS, SSIS, SSAS, etc.

Knowing what type of project...

To me it looks like whatever process you have for populating the parameter (@DBName) is busted.

Now as to why it isn't working, you would need to look into what populates...

I agree with Grant and Piet here - there are no shortcuts with it.

One thing that can help though and I strongly recommend is to adopt a coding standard AND...

My approach would be to look at where the problem is and determine what you want to do to fix it.

What you indicated is that the string MUST end in...

If I am understanding your request properly, something like this should work, right:

WITH [cte]
AS
(
SELECT
[Mobile]
, [WorkTelephone]
, [HomeTelephone]
, [FirstName]
, [LastName]
, [PolicyNumber]
, COUNT(1) OVER (PARTITION BY
 [Mobile]
 , [FirstName]
 ,...

oh sorry.  I misunderstood.  I think that will be a bit more challenging as you are essentially going to need to rip apart the XML.  I think this may fall...

I don't see why you can't do this.  You already have it started, just need to expand on it to capture each and every element in the XML.  Something along...

• This reply was modified 4 years ago by Mr. Brian Gale.