Activity overview
Latest activity by weswinkler
Yes, I had "Qualify Object Names" ticked/checked.
When I uncheck that option, the square brackets behave as expected.
But, I still wish the interaction between the two could be separated.
I like having the objects qualified; in fact I need it sometimes when working with objects in a non-dbo schema. I just don't want SQL Prompt to mess with square brackets unless I explicitly ask for it.
I hope this is resolved in a future release. / comments
Yes, I had "Qualify Object Names" ticked/checked.
When I uncheck that option, the square brackets behave as expected.
But, I still wish the interaction between the two could be separated.
I like h...
Problem with square brackets in SQL Prompt 6.5.0.326
SQL Prompt 6.5.0.326 does not appear to honor my choice regarding adding or removing square brackets.
My option setting on the Format>Actions page has the "Add/remove square brackets" checkbox blan...
Ignore table DEFAULT constraints completely?
I know that SQL Compare provides options to ignore constraint and index names, and to ignore CHECK constraints.
But, is it possible to ignore all DEFAULT constraints on table columns?
I have some d...
Find invalid objects: false positive on $PARTITION statement
SQL Prompt's "Find invalid objects" feature incorrectly flags the use of $PARTITION function/statement as invalid. (SQL Prompt 5.3.4.1)
Repro: embed any valid statement calling the $PARTITION stat...
Comparison filter files compatible between versions?
Can a comparison filter file, e.g., MyFilter.scpf, which was created in and written by SQL Compare 10.x be opened and used successfully by SQL Compare 9.x?
I am confident that the filter files are ...
Ignore merge replication constraints?
I would like to selectively ignore check constraints on table columns when the constraint name matches a pattern. The particular pattern is a check constraint name like [repl_identity_range_*].
My...
Find invalid objects: false positive on sp_upgraddiagrams
Using SSMS 2008 R2, I have added database diagrams to a SQL 2008 database. This invoked some scripts that added new system objects to my database to support the diagrams.
Now, SQL Prompt (5.1.16.3...
Each certificate is defined in its own file, not as part of another object.
The files reside in subdirectories like \Schema Objects\Database Level Objects\Security\Symmetric Keys,
\Schema Objects\Database Level Objects\Security\Certificates, and \Schema Objects\Database Level Objects\Security\Master Keys. The example cites the entire contents of one such file.
Other files for database roles are successfully parsed from \Schema Objects\Database Level Objects\Security\Roles\Database Roles. All other SQL objects have their defining files in a directory structure under \Schema Objects\Schemas\dbo. / comments
Each certificate is defined in its own file, not as part of another object.
The files reside in subdirectories like \Schema Objects\Database Level Objects\Security\Symmetric Keys,
\Schema Objects\D...
We already have a source control system, and I can easily identify when and if changes were made to the overall definition of the database. I'm trying to determine when a particular object change was actually made to my database, not necessarily when changes were made to definitions in source control.
I'm working in an test integration environment. Not all changes made in source control are immediately applied to this database. Developers work on a series of incremental changes on their own copies of the database, and when they are ready, we deploy the group of changes to this test database all at once.
Also, some changes may be made on an ad hoc basis. In this case, the snapshots would help uncover an unintended change. A database user (tester or developer) may have unintentionally changed an object. Whoops!
I'll look deeper into the SQL Comparison SDK.
Thanks for your response. / comments
We already have a source control system, and I can easily identify when and if changes were made to the overall definition of the database. I'm trying to determine when a particular object change ...
Key and Certificate script files fail comparison
Using the suggestion from another post in this forum (Compare schema between TFS Project with Database), I made a comparison between the "Scheme Object" file directory in my local TFS source tree a...