Comments
Sort by recent activity
I usually line them up somewhere around the 80th column.
This is also useful when using the little known ALT + <select text> to get a box select for copying to excel/notepad++ / comments
I usually line them up somewhere around the 80th column.
This is also useful when using the little known ALT + <select text> to get a box select for copying to excel/notepad++
By flickering I mean that it attempts to show the tooltip, but if there is nothing to display it disappears. If you are moving the cursor up and down then you get a ton of this happening.
If I do the same over objects, the tooltips are populated and they remain (as expected)
ssms version:
Microsoft SQL Server Management Studio (expires in 119 days) 10.0.1300.13 ((SQL_PreRelease).080207-2350 )
Microsoft Analysis Services Client Tools 2007.0100.1300.013 ((SQL_PreRelease).080207-2350 )
Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 7.0.5730.11
Microsoft .NET Framework 2.0.50727.1433
Operating System 5.1.2600 / comments
By flickering I mean that it attempts to show the tooltip, but if there is nothing to display it disappears. If you are moving the cursor up and down then you get a ton of this happening.
If I do t...
True.
But I have lots of tables with similar prefixes = lots of scrolling or having to type more of the prefix including the "_" when the prompt shows / comments
True.
But I have lots of tables with similar prefixes = lots of scrolling or having to type more of the prefix including the "_" when the prompt shows
i can send the query that is causing the error (by email)
you've already got the .snp of the db i'm using... / comments
i can send the query that is causing the error (by email)
you've already got the .snp of the db i'm using...
i did manage to hide the objects and only show the dependencies, but then to list out the unique objects i had to export this as xml, open in excel using the 'xml maps' function and then use an autofilter-copy unique to get the data out
not ideal / comments
i did manage to hide the objects and only show the dependencies, but then to list out the unique objects i had to export this as xml, open in excel using the 'xml maps' function and then use an aut...
http://www.red-gate.com/messageboard/vi ... 5397#25397 / comments
http://www.red-gate.com/messageboard/vi ... 5397#25397
Both these ideas sound good.
The 'automatic join' feature is currently very frustrating in that it only tries against the previous object. / comments
Both these ideas sound good.
The 'automatic join' feature is currently very frustrating in that it only tries against the previous object.
Actually, if you click on the 'name' bar at the top (by the 'objects in selected database'), it sorts stuff alphabetically (kind of) / comments
Actually, if you click on the 'name' bar at the top (by the 'objects in selected database'), it sorts stuff alphabetically (kind of)
I can't seem to get /ignoremissing to work at all via the command line.
I also can't seem to find it documented anywhere.
The syntax
/options:IgnoreMissing
does not work at all
Help! / comments
I can't seem to get /ignoremissing to work at all via the command line.
I also can't seem to find it documented anywhere.
The syntax
/options:IgnoreMissing
does not work at all
Help!
I have a database.
I have an empty folder.
I compare the database to source control i.e. the empty folder
All the scripts are created and work correctly.
i.e. the database's objects are correctly dropped
However
If I recreate the database using scripts, then the DROP script no longer works due to unique constraints that have been scripted for dropping.
I have tried various 'ignore' checkboxes but still the unique constraints are scripted for deletion
Am using SQL Compare 8.5.12.20 against sql server 2005 / comments
I have a database.
I have an empty folder.
I compare the database to source control i.e. the empty folder
All the scripts are created and work correctly.
i.e. the database's objects are correctly d...