Comments
Sort by recent activity
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...
Will the same technique work to transfer my personel settings between two different machines?
Also, where do I find the XML files on a Windows Vista machine? I have found some RedGate XML files in C:\Users\username\AppData\Local\Red Gate. But I have also found Red Gate directories at C:\Users\username\AppData\Roaming\Red Gate. / comments
Will the same technique work to transfer my personel settings between two different machines?
Also, where do I find the XML files on a Windows Vista machine? I have found some RedGate XML files in ...
I second the request. The functionality of the up and down arrows on the "Scripts to Execute" side would work fine for me.
If you can't provide it on the main page, please provide it on the "Configure" dialog, where servers and databases are chosen. / comments
I second the request. The functionality of the up and down arrows on the "Scripts to Execute" side would work fine for me.
If you can't provide it on the main page, please provide it on the "Config...
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 ...
I'd also like to see a confirmation step when removing object filters.
I had spent some time constructing a multi-clause filter on an object, and I wanted to edit it. But, by accident I clicked the red X instead of the green pencil. The existing filter clauses were lost, and I had to start over.
Could you add a confirmation step when deleting filter rules? Perhaps this could be invoked only if the filter rules were "dirty" or unsaved.
Thanks! / comments
I'd also like to see a confirmation step when removing object filters.
I had spent some time constructing a multi-clause filter on an object, and I wanted to edit it. But, by accident I clicked the...
I find the Summarize Script feature of SQL Refactor very useful. Please work to include this in SQL Prompt V5 as soon as possible.
Also, I would like to see the script summarization window become a bit more interactive. E.g., allow me to highlight a summary section, change to the query window to make changes, and then return to the summarization window and REFRESH the summarization. / comments
I find the Summarize Script feature of SQL Refactor very useful. Please work to include this in SQL Prompt V5 as soon as possible.
Also, I would like to see the script summarization window become ...
I'm using SSMS 2008 R2 on Windows Server 2003 R2.
I uninstalled SQL Prompt 4.x and installed SQL Prompt 5.x.
SSMS reported the same error as LanceAndrewes received:
The Add-in 'SQL Prompt 5.0' failed to load or caused an exception. Would you like to remove this add-in? If you choose yes, you will need to reinstall the Add-in to use it again.
Error message: <Unknown error>
Error number: 80131509
I also chose "Yes" and proceeded.
SQL Prompt 5.0 apparently loaded successfully -- at least into Visual Studio Team System 2008 (Version 9.0.30729.4462 QFE). The SQL Prompt 5.0 menu item is active, but the SQL Prompt 4.0 menu item, though disabled, still appears. Shouldn't this have been removed when I uninstalled SQL Prompt 4.0?
SQL Prompt 5.0 initially did NOT appear at all in SSMS. My old SQL Prompt 4.0 menu item was active, but none of its available actions would complete.
But, after rebooting and repairing the SQL Prompt 5.0 installation, I was able to proceed.
I then also received the error message about SQL Refactor.
Microsoft SQL Server Management Studio
The Add-in 'SQL Refactor 1.5' failed to load or caused an exception.
Would you like to remove this Add-in?
If you choose yes, you will need to reinstall the Add-in to use it again.
Error Message: Invalid pointer
Error number: 80004003
I answered "Yes" and proceeded. Both SQL Prompt 5.0 and SQL Refactor 1.5 are available and working now in SSMS. / comments
I'm using SSMS 2008 R2 on Windows Server 2003 R2.
I uninstalled SQL Prompt 4.x and installed SQL Prompt 5.x.
SSMS reported the same error as LanceAndrewes received:
The Add-in 'SQL Prompt 5.0' fail...
I routinely use SQL Multi-script to check on general database settings. Just run SELECT * FROM sys.databases
against the master database on different servers, and export the results to Excel.
It's a snap to scan the individual columns to fiind which databases have particular settings. Condidtional formatting of the Excel file will also quickly highlight any differences from your preferred settings. / comments
I routinely use SQL Multi-script to check on general database settings. Just runSELECT * FROM sys.databases
against the master database on different servers, and export the results to Excel.
It'...
Silly me.
Just set up a project with the same database on both sides.
First, unmap all the tables on the Object Mapping tab.
Then, re-map MyTable to MyTable_Copy, and select the columns I want.
This gives me exactly what I want. / comments
Silly me.
Just set up a project with the same database on both sides.
First, unmap all the tables on the Object Mapping tab.
Then, re-map MyTable to MyTable_Copy, and select the columns I want.
Thi...