Is DTC a requirement?

seaport (4/3/2015)

---

Thanks.

I did some googling and found out that I can use:

Netstat -ano

to list all listening ports.

Is there a range of ports that are rarely used? I checked my...

Can you expand further what you need to do?

As Grant said, there are many reasons why this can happen. My usual thinking would be locking, if there are other scripts, procs, etc. hitting the table at the same...

MadAdmin (3/31/2015)

---

When using Filtered indexes, just be careful of Procs where Quoted_Identifier is OFF for the update inserts.

You can find this by selecting * from sql_modules where quoted_identifier is off,...

Just in case, another option would be to set up a trace and look for the stored procedure, errors, etc. while the truncate runs. To me, it also sounds like...

Thanks' Grant, I'll do that.

Up to you but I would consult this page, http://www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.xhtml, to make sure you aren't using a port that other services/applications use.

Don't remove the partitioning form the Production server. My recommendation (there may be better options one of the more experienced DBA's knows about), but I would restore the database to...

I've gone through this recently. You would think that the SQL team would have developed an easy and automated way to do this. Unfortunately, that hasn't happened yet.

I use SSIS...

I haven't had to do any of this, but based on what I've ready,

In order to resume the harvesting of changes after failover, the stored procedure sp_cdc_add_job must be run...

You won't be able to get that granular from my experience. You will have to give more broad access to a database.

I don't use /netonly. When I run it that way, if I enter the wrong password, it just exits cmd. If I include /netonly and run it, it continues to...

There is a remote query timeout option that is set to 10 minutes by default within SQL Server. This could be the problem. Unless by connection timeout you're referring to...

I'm also not sure exactly how Crystal Reports works in terms of login, but if it's using a windows auth account per user, that user would also need to be...