Comments
Sort by recent activity
I think you might be using SQL Data Compare rather than SQL Compare. Is that the case?
I believe the option you're looking for is actually called "Skip integrity checks for foreign key constraints". / comments
I think you might be using SQL Data Compare rather than SQL Compare. Is that the case?
I believe the option you're looking for is actually called "Skip integrity checks for foreign key constraints".
Thanks for the information! The developers have now reproduced the problem so I'll let you know as soon as I have any updates. / comments
Thanks for the information! The developers have now reproduced the problem so I'll let you know as soon as I have any updates.
Hi Sxary,
Could you let me know what version of SQL 2000 you are running? I was able to reproduce the problem using the RTM version, but one of the developers tried SP4 and it seemed to work. If you're not already on SP4, it might be that installing SP4 is a workaround for this. / comments
Hi Sxary,
Could you let me know what version of SQL 2000 you are running? I was able to reproduce the problem using the RTM version, but one of the developers tried SP4 and it seemed to work. If yo...
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...