Posts
Sort by recent activity
Feature suggestion
often while creating update scripts between my dev SQL and a production SQL i find small things that i change in my dev SQL. after changing them i click refresh and have to wait for SQL Compare to ...
Fromat Error
SQL Prompt is unable to format a line like
DROP STATISTICS [dbo].[VehicleLastInputs].[stat_by_dta_318832398_1_2_3_5]
although this line came from the sync script of SQL Compare and it is able to ru...
Feature suggestion for SQL Prompt 5
the Invalid object list is great but lacks a few things:
1. Script selected object as drop
2. double click on item in the list to open it in the object explorer (just like sql search)
3. ability to...
Sql compare bug
i have a live sql 2008 DB with a field declared as nvarchar(max)
i took a snapshot from sql 2005 where the field exists as nvarchar(200) and used sql compare to compare the live db to the snapshot....
How to view variable values when an exception was thrown
i have a method call that threw an exception on one of many calls to it.
the method accepts a string and looks for it in a collection and then passes the object associated with that string to more ...
Bug on VB display
this line of code in C#
if ('\x007f' < ch)
is displayed on VB as
If (""c < ch) Then
the character inside the qoutes is not readable and in this case the line should have been
If (chr(&h7f) < ch) Then
exclude a trigget
i have a trigger on a table that runs when a new row is inserted or modified. how do i filter only this trigger out of the comparison (leaving the table in the comparison)?
feature request
after i rename a column on a dev machine and i compare the structure to a production machine, sql compare generates a script to drop the old column and add a new column. my idea: add an option to s...
feature suggestion
1. if i have a table with a string field and i am writing a SQL statement like this "Field=" i would like to see sql prompt add '' and put the caret in the middle of the tags. on unicode strings sq...
feature suggestion
i often use dependency tracker to find what sprocs are using some table. on some of these cases i then need to edit these sprocs to facilitate some changes made to the table. i think that a great f...