Comments
Sort by recent activity
Hi Sxary,
I've been able to replicate the problem and I've raised a bug report with id SOC-8800. Do you also get the error
'HAS_PERMS_BY_NAME' is not a recognized function name.
when you try and expand the database node in the object explorer?
I notice that Microsoft don't support using SSMS 2014 or later to manage a SQL 2000 database, although clearly it's doable to an extent. / comments
Hi Sxary,
I've been able to replicate the problem and I've raised a bug report with id SOC-8800. Do you also get the error
'HAS_PERMS_BY_NAME' is not a recognized function name.
when you try and e...
I'm going to create a support ticket so that we can look further into this problem. You'll receive an email shortly. / comments
I'm going to create a support ticket so that we can look further into this problem. You'll receive an email shortly.
Are you both trying to connect to the same database on the same server?
What happens when you try and open a project from the other user? Are you getting an error message? If so, what error message are you getting?
Are you both using the same version of SQL Dependency Tracker? If not, try upgrading to the latest version to see if that helps. / comments
Are you both trying to connect to the same database on the same server?
What happens when you try and open a project from the other user? Are you getting an error message? If so, what error message...
Hi Gordon,
We don't technically support SSDT projects but they do work to an extent because the folder structure is similar to a Redgate SQL Source Control project. This is why the post-deployment script will not work with our tools, yet will work when you publish using Visual Studio itself.
Sorry. / comments
Hi Gordon,
We don't technically support SSDT projects but they do work to an extent because the folder structure is similar to a Redgate SQL Source Control project. This is why the post-deployment ...
That's great to hear! / comments
That's great to hear!
Hi Gordon,
I notice in that SQL query that we have CURRENT_TIMESTAMP() - this isn't meant to have parentheses afterwards. This is down to a bug in the parser (SC-8949). There is a workaround, and that is to replace CURRENT_TIMESTAMP with GETDATE() in your table definition.
Does that help? / comments
Hi Gordon,
I notice in that SQL query that we have CURRENT_TIMESTAMP() - this isn't meant to have parentheses afterwards. This is down to a bug in the parser (SC-8949). There is a workaround, and t...
If you're using migration scripts then you'll need to upgrade SQL Source Control as there is a new migrations solution. Have a look at this page for more information - https://documentation.red-gate.com/display/SOC5/Upgrading+from+old+versions+of+migration+scripts / comments
If you're using migration scripts then you'll need to upgrade SQL Source Control as there is a new migrations solution. Have a look at this page for more information - https://documentation.red-gat...
Sadly I think it's going to be a bit difficult to diagnose the problem without any specific details. I think your best course of action would be to create a support ticket through the Support section on the website, or by emailing support@red-gate.com. That way we can investigate in a lot more detail and try to diagnose the problem for you. If you can include any logs, that would be really helpful. / comments
Sadly I think it's going to be a bit difficult to diagnose the problem without any specific details. I think your best course of action would be to create a support ticket through the Support secti...
Hi Ramesh,
Unless you're using a much older version, there shouldn't really be an impact. The option is not available in the step template so you'll have to manually add the -IgnoreAdditional switch. / comments
Hi Ramesh,
Unless you're using a much older version, there shouldn't really be an impact. The option is not available in the step template so you'll have to manually add the -IgnoreAdditional switch.
Hi Ramesh,
In that case you might be using a version before this functionality was added. Can you try upgrading to the latest version? Here's a download link - ftp://support.red-gate.com/patches/DLMAutomation/13Mar2017/DLMAutomation.exe / comments
Hi Ramesh,
In that case you might be using a version before this functionality was added. Can you try upgrading to the latest version? Here's a download link - ftp://support.red-gate.com/patches/DL...