Activity overview
Latest activity by schematech
Repository size
A data sheet I picked up at SQL in the City last week shows an Architecture diagram where it indicates the average db size for the repository as 94,000 MB. Is that really the case? What contributes...
OK. Forget this. After about 25 minutes, the install dialog popped up and it is now proceeding OK!! Personally, I blame Norton Anti-Virus for everything.... :?
Bob / comments
OK. Forget this. After about 25 minutes, the install dialog popped up and it is now proceeding OK!! Personally, I blame Norton Anti-Virus for everything.... :?
Bob
Update gets stuck on Downloading 98.9%
When I choose to update to the latest release, the downloading dialog appears, proceeds to 98.9% and goes no further. No messages, no nothing.
Any suggestions?
Edit - and clicking on Cancel Downloa...
Many thanks, Aaron, for your prompt reply and super-quick fix!
I have installed the build and it addresses both issues I raised.
Cheers,
Bob / comments
Many thanks, Aaron, for your prompt reply and super-quick fix!
I have installed the build and it addresses both issues I raised.
Cheers,
Bob
Semi-colon insertion problem with MERGE
We have some valid, working code that does not go through the Ctrl-B,C process. Here is a snippet of the affected statement, from within a much larger sproc that I cannot post here:merge CardPoints...
Thanks, Aaron - installed and functioning fine [image]
Bob / comments
Thanks, Aaron - installed and functioning fine
Bob
Thanks Aaron.
Before I install that, let me check something with you. I am already using v6.4.1.85 which was a 'private build' posted by David Priddle in response to a bug reported concerning the WAITFOR statement with Service Broker queues. As this is something we use a lot, I decided to use that version, rightly or wrongly.
Does your private build include this fix?
Regards,
Bob / comments
Thanks Aaron.
Before I install that, let me check something with you. I am already using v6.4.1.85 which was a 'private build' posted by David Priddle in response to a bug reported concerning the W...
Multiple semicolon insert
If I have code like this fragment:declare @old int, @new int
....
if @old <> @new
exec dbo.spSomeProc @new
Ctrl-B, C correctly adds a ; to the end of the exec statement. However, furthe...
How to enforce semicolon statement terminator
Sorry if this has been asked before, but I am trying to catch up on what we should have been doing for a while and adding semicolons to the end of statements;
I can't find how to tell SQL Prompt to...
ERROR - There was an entry in the default trace which ...
There was an entry in the default trace which did not have an associated user.
I get this every time I open a particular DB in SSMS Object Explorer. It is also displayed if I try to commit changes ...