Comments
Sort by recent activity
Thanks for your post.
I would imagine the problem is that another object in your project had a dependency on the role and it's being brought back in.
By default, we bring back dependent objects, as they're probably required or it's likely the script will fail or it will leave your database in an inconsistent state.
If you want to ignore dependencies, you can use the option 'IgnoreDependencies'
I hope this helps. / comments
Thanks for your post.
I would imagine the problem is that another object in your project had a dependency on the role and it's being brought back in.
By default, we bring back dependent objects, as...
Thanks for your post.
SQL Prompt 5 should be able to co-exist with the native intellisense. There are a few features (like parenthesis matching) that the native tool supports that we don't, so they can both be enabled.
However, the candidate list pop-up should only be enabled for one of them, or they will interfere with each other.
It sounds like for some reason Tools > Options > Text Editor > Transact SQL > General > Auto list members is still enabled, which would cause the native list to pop-up as well.
The main advantage over the native intelisense is the additional formatting and non-code completion features: http://www.red-gate.com/products/sql-de ... ure-matrix
There is also advantages in the way SQL Prompt makes suggestions for code completion, but I have to say I'm not entirely sure how sophisticated the native intelisense has become to confirm if we still have an advantage in that area.
I hope this helps. / comments
Thanks for your post.
SQL Prompt 5 should be able to co-exist with the native intellisense. There are a few features (like parenthesis matching) that the native tool supports that we don't, so they...
Thanks for your post.
I'm afraid we don't have support for formatting FETCH NEXT statements, which is why the behavior isn't completely predictable.
I've added you as another vote for SP-3019. / comments
Thanks for your post.
I'm afraid we don't have support for formatting FETCH NEXT statements, which is why the behavior isn't completely predictable.
I've added you as another vote for SP-3019.
Thanks for your reply. The good old turn it off and on again trick to the rescue.
I hope it behaves from now on. / comments
Thanks for your reply. The good old turn it off and on again trick to the rescue.
I hope it behaves from now on.
Thanks for your post, and sorry you're having trouble with the migration scripts.
In order for SQL Source Control to consider the migration script, the database revisions need to be correct in the database level extended properties, and the database needs to be linked to the exact same repository. We don't currently support cross branch migration scripts, so if something doesn't match up, then we err on the side of caution and ignore it.
Can you take a look at 'CompassionWeb 11234 to 11466.migrationScript' and also at the linked database's extended properties and see if the repository locations all match up? / comments
Thanks for your post, and sorry you're having trouble with the migration scripts.
In order for SQL Source Control to consider the migration script, the database revisions need to be correct in the ...
Thanks for your post.
I've seen this sort of thing occur with some minor corruptions in the database schema before. The most recent one that springs to mind was related to extended properties.
When you receive the error, are you able to submit the error report with your email address? That should hopefully give us a clue to where the process is failing. / comments
Thanks for your post.
I've seen this sort of thing occur with some minor corruptions in the database schema before. The most recent one that springs to mind was related to extended properties.
When...
Thanks for your post.
Which version of SQL Server are you using? This doesn't appear to happen when I tested it with SQL 2008 and SQL 2012.
Are you restoring using native SQL or something else?
What does sp_who2 show you for the connection to the database you're trying to restore? / comments
Thanks for your post.
Which version of SQL Server are you using? This doesn't appear to happen when I tested it with SQL 2008 and SQL 2012.
Are you restoring using native SQL or something else?
Wha...
Hi,
I'm afraid this is quite an old issue dating back to 2013, and occurred before we had any GIT support in the product. I can't say for sure (as I no longer work on the tool), but I would suspect what you're experiencing is a new/different bug.
If you submitted an error report with your email address, our support team should be able to look it up and see if this is a know issue and/or if there are any workarounds that would help.
You can log a request at https://redgatesupport.zendesk.com/home or send an email to support@red-gate.com.
Thanks,
Chris / comments
Hi,
I'm afraid this is quite an old issue dating back to 2013, and occurred before we had any GIT support in the product. I can't say for sure (as I no longer work on the tool), but I would suspect...
I've had confirmation that this issue should be addressed in the next release. I can't give an exact date, but it should be within about a month or so. / comments
I've had confirmation that this issue should be addressed in the next release. I can't give an exact date, but it should be within about a month or so.
Thanks for your post.
This appears to be a reproducible bug when relinking a database using the shared model. I've informed the development team and sent them some reproduction steps, so it should be something we can fix fairly quickly. Our internal reference for this is SOC-4566.
I think the only workaround I can suggest at this stage is either use the dedicated model when you link, or to take a copy of the database and then link to the new folder. You could use SQL Compare to copy the schema to a new blank database, or restore a backup.
I hope this helps.
Sorry for the inconvenience. / comments
Thanks for your post.
This appears to be a reproducible bug when relinking a database using the shared model. I've informed the development team and sent them some reproduction steps, so it should ...