Comments
Sort by recent activity
I've looked through the FAQ plenty before. What I wanted to know was if there were other keywords that would be useful like $CURSOR$ is useful in placing the cursor in a particular place in the snippet.
For instance, if you had a snippet of code that had $DATE$ it would place the current date when the snippet is used. This could be useful in code or documentation (file headers).
Does that make sense? / comments
I've looked through the FAQ plenty before. What I wanted to know was if there were other keywords that would be useful like $CURSOR$ is useful in placing the cursor in a particular place in the sn...
I disagree with that position. What I'm trying to do is script a procedure from a server. The server is a 2000 server and the object is currently owned by dbo. If I script the object from the server and then turn around to run the just generated script on the server, the script is no longer owned by dbo and therefore not the same object. What SQL Compare is doing is potentially going back in time and restoring the past state of who owns an object, not who currently owns the object.
There are many cases where you can create/alter an object, then use GUI tools to change that objects owner. Would this still script as the original owner and not the current owner?
I think this should be an option in SQL Compare. It is the default for how SSMS scripts objects.[/i] / comments
I disagree with that position. What I'm trying to do is script a procedure from a server. The server is a 2000 server and the object is currently owned by dbo. If I script the object from the s...
Thanks. I think this would really be a nice help to have the option of how to script the database object ownership. / comments
Thanks. I think this would really be a nice help to have the option of how to script the database object ownership.
Hi @Peter_Laws - after enabling Frequent Updates, I was able to update to this version. I can confirm this version, 15.0.5.23181, solved the issues I noted in this thread for both Sql Compare and Sql Data Compare. Thank you! / comments
Hi @Peter_Laws - after enabling Frequent Updates, I was able to update to this version. I can confirm this version, 15.0.5.23181, solved the issues I noted in this thread for both Sql Compare and ...
Looks like 14.8 may have been the first version where this bug was introduced. I'm going to try 14.7 eventually. https://documentation.red-gate.com/sc14/release-notes-and-other-versions/sql-compare-14-7-release-notes 14.8.0.21190 - Jun 14th, 2022 FREQUENT UPDATES RELEASE Features
Setting an Application ID is no longer needed to connect using Azure Active Directory Universal with MFA authentication
/ comments
Looks like 14.8 may have been the first version where this bug was introduced. I'm going to try 14.7 eventually.https://documentation.red-gate.com/sc14/release-notes-and-other-versions/sql-compare...
Hi, glad others see it too. Please let me know if you get anything useful from redgate support! / comments
Hi, glad others see it too. Please let me know if you get anything useful from redgate support!
Hi, thanks for the reply. Yes, that is quite an old file and on top of that it is from a third party product that we support. At least the initial solution of just escaping the keyword would not change the file too much, though we try to keep our customizations separated as a practice. / comments
Hi, thanks for the reply. Yes, that is quite an old file and on top of that it is from a third party product that we support. At least the initial solution of just escaping the keyword would not ...
I've had the same issue as well. Though the sprocs it can't parse for me don't have anything to do with xml. I'll pass some along to you and David Atkinson. / comments
I've had the same issue as well. Though the sprocs it can't parse for me don't have anything to do with xml. I'll pass some along to you and David Atkinson.
hi, I experienced the same behavior.
upgraded sql search from v2.x to 3.x (also within SSMS14)
rebooted
sql search displayed no results no matter what search I attempted (a very different behavior than in the past - I've used this for many years).
I uninstalled sql search
I upgraded sql prompt from 9.0 ish to 9.5.23
I reinstalled sql search 3.2.1
Sql search now returns results
One thing I noticed, when upgrading from sql search 2, the installer placed sql search 3 content into the sql search 2 path. When I reinstalled sql search 3 from scratch, it placed its content into the sql search 3 path. I'm not sure if this is the/part of the issue or not. Sorry I did not keep better track of version numbers.
/ comments
hi, I experienced the same behavior.
upgraded sql search from v2.x to 3.x (also within SSMS14)
rebooted
sql search displayed no results no matter what search I attempted (a very different beha...
Hi, this is a pretty old thread, but I ran into the same issue for specific extended properties that were not excluded by the standard extended prop. ignore option. To ignore extended properties sp_addextendedproperty N'sys_sensitivity_label_name' - I found the option by editing the project and checking "Ignore sensitivity classifications". Hope this works for you, though I doubt it's still an issue this far out! / comments
Hi, this is a pretty old thread, but I ran into the same issue for specific extended properties that were not excluded by the standard extended prop. ignore option. To ignore extended properties s...