Activity overview
Latest activity by WeeeBob
feature suggestion: Code sniffing
Just a wee suggestion that I think would fit into SQL prompt quite well.
Hows about Code sniffing? For checking code compliance with user defined standards. Like checking column names conform to a ...
Why are you using Ctrl + Enter ?? shouldn't you be using Ctrl + Space if you want to manually trigger suggestions?
Drop Table Ctrl+space works fine, but I too get the problem with Ctrl+Enter with version 5.3.6.28 in SSMS 2008r2 / comments
Why are you using Ctrl + Enter ?? shouldn't you be using Ctrl + Space if you want to manually trigger suggestions?
Drop Table Ctrl+space works fine, but I too get the problem with Ctrl+Enter with ...
Hi,
I ran the command above and it fixed the problem for me also. The short cut was missing from the menu and the CTRL B, CTRL L combo didnt' work either. now everything is fine.
I'm using Win XP 32 bit so I ran the command as below: "%ProgramFiles%\Microsoft SQL Server\100\Tools\binn\VSShell\Common7\IDE\Ssms.exe" /setup
Im using SSMS version 10.50.1600.1
SQL prompt version: 5.1.94.2 / comments
Hi,
I ran the command above and it fixed the problem for me also. The short cut was missing from the menu and the CTRL B, CTRL L combo didnt' work either. now everything is fine.
I'm using Win XP ...
[image]
Just installed SQL prompt 5.1.6.35 , and it caused same problems with VS2008 crashing out when trying to preview SQL2008R2 report.
Disabled as described above and at least I can get on with my work now!! / comments
Just installed SQL prompt 5.1.6.35 , and it caused same problems with VS2008 crashing out when trying to preview SQL2008R2 report.
Disabled as described above and at least I can get on with my wor...
I don't think that can be the case, as this problem tends to appear after I have ran SQL Compare to ensure the two db's schemas are in sync. So how could there be incompatible data types?
then every so often when you go into the SQL data compare and try running its gets this error.
Yesterday the events ran a little like this:
run SQL compare to bring our UAT inline with the DEV database.
used SQL compare to apply the changes, was only 3 columns that had been added to a table in DEV, so the compare script was just to add these to the UAT table
Run SQL data compare to check for static data changes.
error!
now the table that had the DDL changes, is not a table that is actually selected for the data compare ? so why would you get fieldmappings suddenly becoming invalid? is there some refresh problem in data compare when the DDL has been updated?
Our standard way to roll changes out now is to use SQL compare to sync the DDL between the two, then run SQL data compare on a subset of tables (all fairly static lookup tables) to sync up any data changes.
Usually works very well, but every so often this problem pops up and it just makes it a pain to recreate the data compare project, espiecally as I have to go through and reselect only the tables we want and switch to some custom keys.
If you could improve the actual error data compare is returning to tell what field mappings are invalid that it would certainly help! the logs are useless for trying to gleam anything either from what I've seen. / comments
I don't think that can be the case, as this problem tends to appear after I have ran SQL Compare to ensure the two db's schemas are in sync. So how could there be incompatible data types?
then ever...
I just recreated the compare from scratch and it works fine again (just hope I have all the same stuff comparing).
I've just done a visual check between the old non working file and the new one, everything looks pretty much the same, except for the "TableActions" section of the xml file. Old non working file has 134 'value' s , the new one only 32. I haven't gone into any of the details as yet..
I can send the files to someone if they are interested? / comments
I just recreated the compare from scratch and it works fine again (just hope I have all the same stuff comparing).
I've just done a visual check between the old non working file and the new one, ev...
thats a real disappointment, as I'm getting the exact same problem between two db's. I had the error before and ended up having to recreate the data compare from scratch for it to work. Since Feb has there been any idea of how to resolve this issue? I don't want to have to spend another hour or so recreating this compare only to have to do it again in a week or two! :evil: / comments
thats a real disappointment, as I'm getting the exact same problem between two db's. I had the error before and ended up having to recreate the data compare from scratch for it to work. Since Feb h...
Extreme Video corruption with Quadro FX1700 Video cards ??
Hi,
I recently changed my video cards in my precision T7400, to dual Nvidia Quadro FX1700 's so I could use three monitors.
Trouble is I now get some wonderful video corruptions when SQL prompt app...
Interesting.
Decided to remove and reinstall SQL refactor and SQL Prompt (as I am running the latest versions)
After reinstall the shortcut keys are working again! joy!!
bizarre how they stopped working, but least its sorted.
:P / comments
Interesting.
Decided to remove and reinstall SQL refactor and SQL Prompt (as I am running the latest versions)
After reinstall the shortcut keys are working again! joy!!
bizarre how they stopped wo...
Shortcut keys no longer work? and 'funny' version
When I downloaded SQL Prompt (and SQL refactor) to do my 14 day trial. I'm sure there where shortcut keys to do important things, like CTRL+ B +L to layout sql.
I recently downloaded and installed ...