In SQL Server 2008 Management Studio, when I right click on a database table and choose "Select Top 100 Rows", I can then e.g. easily add a "ORDER BY " statement to the SQL. That works fine. But when I do choose "Edit Top 200 Rows", I don't have the ability to alter the SQL (which makes it hard to find and edit a record just added in th...
Hi, I have a question about scheduling a rebuild and reorganize of a SQL Server 2008 Full-Text Catalog. When I go to the catalog's Properties then Population Schedule, the wizard seems pretty straight forward except for I don't see a way to specify that I want a rebuild rather than a reorganize. I wanted to schedule a reorganize to be...
SSMS 2008 comes with a great set of standard reports, including one named Schema Changes History. When I run this report, I see all schema changes made since a certain date. My question is this. How is the date determined? For example, on one database for a particular server, the changes are as of 2/14/2010 1:35:15 pm. But on another dat...
Whenever I want to add a column to a table it usually goes something like this: Fire up SQL Server Management Studio (SSMS) Select "Design" on the table I want to add the column to Add the new column to the table Save Get an error that SSMS can't save because it would need to drop the table (and it can't because the the table has forei...
i already had 2008 express sql server but for some reason it came without management studio. how do i know? because i went programs->sql server 2008 and there was no GUI there. so i went here to download the entire thing again, supposedly WITH management studio: http://www.microsoft.com/downloads/details.aspx?FamilyID=7522a683-4cb2-454...
I recently upgraded to SQL Management Studio 2008 (full not express, if it matters). In 2005, when I was in the Query Editor, each tab (with an unsaved query) would have the servername-instance-query name or something like that, but all I cared about was seeing the server name there so I knew which server I was running my query on. In ...
I have a lot of sql server 2008 servers with many databases on each server. I usually forget which database is on which server. I want to create a batch file named after the name of the database that opens a connection to this database in the currently opened SSMS instance and not in a new instance. ...
I'm loading a sql script up to an SSMS 2008 add-in like so: ' create a new blank document ServiceCache.ScriptFactory.CreateNewBlankScript(Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptType.Sql) ' insert SQL statement to the blank document Dim doc As EnvDTE.TextDocument = CType(Service...
Hey, I am currently developing a vbs script, which installs SQL server 2008 + SP1. After the install I want to change the default settings in the Ssms, such as "Prevent saving changes that require table recreation" and such on. I can't figure out, where Ssms hides its settings. Currently I am looking at 1) My Documents\SQL Server Mana...
I was browsing around and found this blog post: http://erikej.blogspot.com/2010/04/version-3-of-exportsqlce-now-available.html (It is for a great add in if you user SQL Server CE.) On that post I saw an screen shot of SSMS with images in the results. How is this done? I have images in my database (PNG files that are serialized via ...
Running the following simple query in SSMS: UPDATE tblEntityAddress SET strPostCode= REPLACE(strPostCode,' ','') The update to the data (at least in memory) is complete in under a minute. I verified this by performing another query with transaction isolation level read uncommitted. The update query, however, continues to run for anot...
I would like to add custom folders to a Sql Server Management Studio 2008 solution. Currently only three folders are included: Connections, Queries, and Miscellaneous with no easy way to add or customize this folder layout. ...
I'm using SMS 2008 & I'm looking for where the registered servers are stores on my local machine. I have searched the registry with no luck. AHIA, Larry... ...
I've always relied heavily on Windows shortcuts to SSMS that include command-line switches allowing me to quickly open up a specific database on a specific server. For example Ssms.exe -S 123.123.123.123 -U sa -P goodpassword -d DbName or Ssms.exe -S . -E -d DbName These suddenly stopped working. I get this error from SSMS: Faile...
I need to know if the "Backup Database Task" in MS SQL Management Studio, maintenance plans, takes the free space into account or that it only backsup the data part. For e.g. if the db size is 100 MB where 60Mb is data and 40Mb is free space. Will take the backup of the whole db of size 100 or that it will take backup of the 60Mb data. ...
The problem is that I need to explain the different sizes of backups that are being made of a database in a plant. Sometimes the difference between the sizes is in negative, even though that there is no data being deleted from the system. Datum Backupfile-file Size KB Diff 6/1/10 backup201006010100.bak 3355914 ...
Does SSMS save these to a file location or are they managed internally thru SSMS? If there is a location where is it? ...
I have a table in which one column (type ntext) has data that includes carriage return and linefeeds. (CHAR(13) and CHAR(10)). If I right click the table in SSMS 2008 and choose 'Select Top 1000 rows' and the display mode is set to "Result to Grid" it seems that control characters (like TAB and CRLF) are converted to spaces for display...
I'm debugging a stored procedure via SSMS 2008. I have a uniqueidentifier variable that gets assigned from a select statement. I want to change its value while I'm debugging to NULL after the assignment. I can change the value to a different guid, but I cannot change it null. I've tried changing the value to NULL, 'NULL', (NULL), [NULL]...
Say, I have a script nicely formatted in SSMS and it's annotated with all kinds of comments in different languages. But when I copy and paste this nice thingy into Word with syntax highlighted I will get a syntax-highlighted message with those comments garbled, as if reading the source text with one code page and pasting it using another...