One way to do it that I think should work would be to do a self join.  So something like:

SELECT
[t1].[empID]
, [t1].[empl_rcd]
, [t1].[jobcode]   AS [jobcode1]
, [t1].[joblevel]...

For me, with my android device, I like that I can turn off targeted marketing.  I forget where the setting is, but google allows you to disable it.  Turning it...

I can think of only 1 case where a BEGIN doesn't have an END - BEGIN TRANSACTION.  That requires a COMMIT or a ROLLBACK.   Otherwise I agree with Jeff here...

Few things I would try, but the first would be to connect to the server using the FQDN rather than the friendly name.

I would also make sure your connection string...

If the password to the SSIS service account is known to you, I would log in as that account and do a test run of the powershell as the SSIS...

Do you have access to the folder where backups are happening on the live system?  If so, restore the live database onto your test box and run some tests that...

@loaderror - I don't think that you need to have the server name match the SQL instance name as then you wouldn't be able to have multiple named instances on...

My first step - check the logs.

My second step - adjust the powershell script to write to a debug file so you can see where it is getting stuck.  That...

As far as I know, this is a manual process.  If you NEED to change the table but don't want to change all of the objects using that table, you...

With your ROUND, you are rounding to 3 decimal places so that is why you are getting a bunch of 0's.

So your options are:

1 - change your ROUND to be...

As a thought, are your SPN's set up correctly?

I know I hit that snag YEARS back and I found a SO article about that error message where they are reminded...

Might be a silly question but did you set up both the web portal and web service for SSL?

I would probably take this approach (although not that efficient, it is easy to read in my opinion):

where (p.JCCo=@Company and p.Job=@Job and substring(Phase,1,3) not in (' 00','...

I agree with Steve's view on this one.  I'd also like to add that SSL encryption is VERY fast and it only encrypts data in motion.  Websites using HTTPS is...

Did a quick google on this and found this link:

https://stackoverflow.com/questions/18996157/what-does-lock-communication-buffer-resources-mean

From what I am understanding from the above, the communication buffer in a deadlock means that there were multiple parallel processes...

• This reply was modified 4 years, 3 months ago by Mr. Brian Gale. Reason: added "edit" section