Comments
Sort by recent activity
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...
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
• General information about my PC
o CPU type and speed
Pentium 4, 3Ghz
o Amount of physical memory
1G
o Hard disk size and free space
75G, 25G+ Free
• Operating system, version, and any service packs installed
XP Pro SP2
• Publisher/version of any anti-virus software you have installed
Trend Micro Office Scan Corporate Edition 5.58
• SQL Server version and service pack information, and also
N/A for this bug
o Whether the server is a local or remote instance
o Whether it is a default or named instance
• Editor being used: either SSMS or QA, and the SQL Server service pack version if this differs from that on the server
N/A for this bug
• MDAC version
MDAC 2.8 SP1 on Windows XP SP2
• The SQL script you entered that caused the problem, and an indication of where the caret was in the script when the problem occurred.
N/A for this bug.
• A copy of the SQL Prompt 3 Beta log, which you can access via the SQL Prompt > Log menu option in either editor. You will need to grab this before you exit your editor since the log is recreated at the start of each editor session.
As it didn't run, cannot supply the log.
The program launches succesfully from the Program menu now though.
Adrian / comments
• General information about my PC
o CPU type and speed
Pentium 4, 3Ghz
o Amount of physical memory
1G
o Hard disk size and free space
75G, 25G+ Free
• Operating system, version, and any service...
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...