Posts
Sort by recent activity
Deployment freezes when linked servers are involved
I'm looking for some help here. I don't believe this is a problem with SQL Compare.When I have a number of changes for, say, functions that touch linked servers, when I execute the deploy script (...
git Branch management
Hi!I'm not entirely clear on the best way to handle branches using SC.Once I'm linked, can I just manipulate the repository from behind the scenes and then refresh? Or do I need to unlink, relink ...
Controlling Transaction Isolation level for deployment script
When deploying from SQL Compare, the script is wrapped in a transaction with the isolation level set to SERIALIZABLE.When altering or creating a proc that uses a linked server, SQL Server attempts ...
Rules for "system named constraint and index names"
Having the "Ignore system named constraint and index names" option enabled, it doesn't seem to be working all the time.It failed to identify [DF__ABCD__EFGH__3C02494A] as a system named constraint....
Using RG Source Control when deploying multiple copies with slight differences (IDENTITY)
So, I have a database schema. The code (procs and functions) are all identical. No problem there.The tables all have identical columns and indexes. But, they have different identity column initi...
Load-based multiple restore errors?
Hi!
I'm currently running 7.4.0.186, and I have a very annoying issue.
Every week I have a series of six DB backups that need to be restored to the same reporting/snapshot machine. All the backup ...
Auto adding WITH for table hints
I've been looking for a solution to help me migrate from an SQL 2000 database to something to run in SQL 2012. One of the key pain points is that the WITH keyword on table hints is now required.
I...
File browser unable to access local resource
I've got around a dozen servers running SQL Backup. We are upgrading one and I've got everything installed.
The backup agent is running as Administrator, and it's still in TRIAL mode, as I haven't...
SQB2MTFGUI fails on multi-threaded backups?
While I've never had a completed backup be bad, I suppose it might have been in this case, however...
I backed up a 17GB database, using compression 1 and two threads. When converting it to an MTF...
Failing on "not enough space" when plenty is available
Ok, so it might not be a flaky router.
I've had three backups fail to a remote share. In all three cases, the first error was from "backupmedium::reportioerror" claiming that there was not enough ...