Posts
Sort by recent activity
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...
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...
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...
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 ...