There are other solutions for sure, but they include risk.  For example, you can take the database offline and modify it in a hex editor to correct the bad data.

If...

A lot of my advice still applies.  I would try connecting by the FQDN name of the server as well as the port.

You ruled out DNS because you can RDP,...

Can your client machine see the servers?  Could be firewall issues (that would be one of my first guesses) or network related.  I would try connecting by the full name...

To add to what Johan said, I'd also check to make sure your database owner is a valid, enabled user.  I've had service broker fail to send messages because my...

Did a quick google and came up with this link:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a68b2f5-a033-44a5-ab1b-ec76967ebfd4/protocol-error-in-tds-stream

Which suggests turning up the remote execution timeout period at the SQL server side OR hardware/network issues.  Since the query runs...

I am pretty sure that the problem is with that buffer pool size as the error indicated.  The error is saying that the connection was closed by the remote host. ...

I believe the reason it is skipped is because the next restore step MAY include the steps that the undo phase would have undone.  If you use NORECOVERY, SQL is...

The master key password is used to decrypt the master key.  If you change the password AND you are decrypting it by password (as opposed to decrypting by the service...

looking at it, to me it appears that it is slow because you are looking at a LOT of data to review and then update a single row.  Mind you...

An alternate, but similar, approach would be to add a sequential integer column to the table rather than the row_number approach.  This should have better SELECT performance than row_number() at...

What I am seeing is it failed validation.  If I remember right, failed validation is thrown when metadata changed.  So you will need to edit the SSIS package to update...

Grow TEMPDB is another step where possible.  I try to ensure I have enough disk space to allow for autogrowth and I try to monitor for abnormal autogrowth on all...

For the database itself, our naming convention is to either name it after the application that uses it, or if multiple applications are using it, then the processes that are...

"best" standards really depend on your environment and how often objects will change and how your team works.

For example, I like naming my tables with the name of the entity...

My approach would be to get this working in TSQL then put the TSQL into SSIS as your source.

My approach (likely not the most efficient) would be to do it...

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