Activity overview
Latest activity by achamp
Ignore Options
Is there a way with SQL Source control that I can specifiy ignore options like I can with SQL Compare. e.g. I want to ignore Data Compression if that is the only diference on a table.
Currently us...
I am also getting random blue dots on databases where there are no changes to commit and where I know the database hasn't been changed behind the scenes.
I am running version 3.1.0.4829 so do I still need to downgrade to version 3.0.13.4214.exe / comments
I am also getting random blue dots on databases where there are no changes to commit and where I know the database hasn't been changed behind the scenes.
I am running version 3.1.0.4829 so do I sti...
This mainly happens on my larger databases which have approx 1000 objects in them.
However I just encountered this again when first connecting to the database server which connects me to the master database. It again locked management studio whilst it saved the snapshot, you should have this schema. I unfortunately can't send you our schemas as my boss said NO due to commercial sensitivity ~sorry.
My machine is a Pentium 4 ~ 3Ghz, with 1GB ram. Looking at my memory usage and the amount of virutal memory sqlwb.exe is consuming currently 256mb but I have seen this the mem usuage up at 500mb. I am suspecting now that I am low on available memory on my box. Could this be causing the problem. I am asking our tech support to see if I can upgrage my RAM to see if this alleviates the problem. I will feed back if this is the case.
Does SQL Prompt require a large amount of memory? / comments
This mainly happens on my larger databases which have approx 1000 objects in them.
However I just encountered this again when first connecting to the database server which connects me to the master...
Unhandled Exception when opening a large query.
Repeatedly when I open a large query I get an Unhandled exeption in Management Studio.
Message is:
Unhadled exception has occured in a compenent in your application. If you click continue, the app...
Saving Snapshot locks Management Studio for over 10 seconds
I have encountered several instances where the Management Studio locks for over 10 seconds and SQL Prompt reports it is saving a snapshot.
I think this mainly happens when I swap databases.
When th...
I can run SQL Prompt 3 in Managment Studio without tray app running.
Adrian / comments
I can run SQL Prompt 3 in Managment Studio without tray app running.
Adrian
Table name order when selecting a column in candiate list
When I am selecting a column in the candiate list that has the same name in multiple tables the tables are not displayed alphabetically.
At present I see:
Field1 int Table4
Field1 int Table1
...
Select top 10 on first line of new query tab
On a new query tab in SQL studio.
Typing SELECT TOP only brings up stored procedures in the candidate list.
This only does it if this is the first query you write in the Tab. If you write this as...
candidate window width
Could the candidate window be auto sized to show the fullname of the table when selecting a column. (Could this be a user specific option).
Another option would be to remember the size of the can...
Database list with use command
In SQL Prompt 2.0 when I typed use ... a list of available databases was presented.
This does not occur in this beta at present.
Adrian