Showing posts with label SQL Management Studio. Show all posts
Showing posts with label SQL Management Studio. Show all posts

Wednesday, March 26, 2008

Click the hyperlink in the Message column for details

One of our colleague, Gábor wanted to attach a database using the Microsoft SQL Management Studio, when he got this surprising message:
An error occurred when attaching the database(s). Click the hyperlink in the Message column for details.

It would be less complicated if the actual error message displayed in the popup.

Wednesday, December 19, 2007

Cool scrollbar

My colleague, Attila got a nice fixed size error popup from SQL Server Management Studio.


I also like scrollbars with 5 pixels height.

Monday, September 3, 2007

14 rows

Microsoft SQL Server Management Studio Express has cool "half" translations if you use non English local settings such as Italian:

Multilingual message box from Microsoft SQL Server Management Studio ExpressThanks Gusty for this screen.

Wednesday, August 8, 2007

Cancel in SQL Management Studio

Unfortunately, this message appeared in Hungarian language, however the English version of SQL Management studio was installed to my computer. It has the following meaning: "The user chosen the cancel option inside the saving dialog."


This is the most unimportant message what I ever seen.

Editing large scripts with Sql Management studio

Sometimes it is required to manage large SQL scripts, especially if you want to migrate data by hand. Let's see how it is look like with Microsoft Sql Management Studio:

I had the SQL script and opened using the file open function. I wanted to reorganize the file using the copy/past feature, when this dialog appeared:

You are attempting to copy more than 194049 lines to the Clipboard. This may decrease performance. "You are attempting to copy more than 194049 lines to the Clipboard. This may decrease performance." 194049 lines didn't seem to a large amount of data (in the end of 2006).

Anyway I was able to copy/paste, but it was terribly slow. After the modifying the file I also wanted to run it:

Insufficent memory to continue the execution of the program.The memory was not enough, my PC had 1 GB. Check the details of the exception, it was a usual .Net stack trace:
System.OutOfMemoryExceptionFinally, I manged to execute the script in multiple smaller parts, but after I wanted to save it:

The operation could not be completed. Not enough memory."The operation could not be completed. Not enough memory." - at least the second part of the error message was translated to Hungarian.