Autocomplete on SQL Management Studio?
Does anyone know if there's an add-in that does autocomplete for queries on SQL Management Studio? ...
sql-management-studio
How can I enable Full-Text indexing using SQL Server Management Studio in SQL Server 2008 Express?
I did it using the commands as described here and it works but I want to do it using the SQL Management Studio. SQL Server 2008 Books Online says this: To create a full-text catalog: In Object Explorer, expand the server, expand Databases, and expand the database in which you want to create the full-text catalog. Exp...
Weird SQL Server Management studio behavior
I am currently using SQL Server Management Studio (Ver 9.00.3042.00) and click the "New Query" and wrote the following code: Select colA, colB, colC colD From table1 When I click the parse (checkbox) button to validate the SQL statement, it says "Command(s) completed successfully". Isn't the parse button suppose ...
What is this process in Sql Server Activity monitor?
There is a process that seems to be running all the time in SQL Server 2005 activity monitor. Double clicking on it produces the following query: CREATE TABLE #tmpDBCCinputbuffer ([EVENT TYPE] NVARCHAR(512), [PARAMETERS] INT, [EVENT Info] NVARCHAR(512)) INSERT INTO #tmpDBCCinputbuffer EXEC ('DBCC INPUTBUFFER(58)') SELECT [EVEN...
How do I get SQL Server Management Studio to stop processing on an error?
This seems like an incredibly dumb question to have to ask, but how do I get SQL Server Management Studio to stop processing a SQL script when it encounters an error? I have a long script and if there is an error at the start SSMS reports it and then blindly carries on, screwing up things even more. I can't use transactions because the ...
SQL Server 2008 - Go From Select to Edit Quickly
In server management studio 2008 you can right mouse click on a table and then hit the select the first 1000 rows. Is there a button or a quick way to edit one of the returned rows instead of having to right mouse click on the table again and click edit first 200 rows. ...
SqlDataReader executing TSQL is faster than management studio executing TSQL
If i run a TSQL Statement in management studio and run the same the query through SqlDataReader, the latter gives the result faster than the former... Any reason?? ...
At what point will a series of selected SQL statements stop if I cancel the execution request in SQL Server Management Studio?
I am running a bunch of database migration scripts. I find myself with a rather pressing problem, that business is waking up and expected to see their data, and their data has not finished migrating. I also took the applications offline and they really need to be started back up. In reality "the business" is a number of companies, and th...
sql server management plugins
Is there some kind of plug in you can get for Microsoft SQL management studio that will: 1) help you format your sql (configuration, so we can get it to match our codeing guidelines) 2) highlight syntax that does not match our coding guidelines For example if a tool could format the sql so that all selects look like: SELECT tbl1.[C...
Ctrl+F and Ctrl+H doesn't work in SQL management studio
I cannot use the Ctrl+F and Ctrl+H in my SQL Management studio. Even if I use the menu items it doesn't work. Haven't installed anything new or changed anything recently. Any ideas? ...
Changing the CommandTimeout in SQL Management studio
So far i have found how to change the ConnectionTimeout... But how can i change the CommandTimeout in SQL Management studio? ...
How get the T-SQL code to find duplicates?
MS Access has a button to generate sql code for finding duplicated rows. I don't know if SQL Server 2005/2008 Managment Studio has this. If it has, please point where If it has not, please tell me how can I have a T-SQL helper for creating code like this. ...
SQL Server Management Studio SSMS tries to "save to file" instead of execute on F5
This happens intermittently and seems to be related to accidentally hitting a key. Any ideas what causes this? ...
Visual Studio & SQL Management Studio: How to revert Ctrl+Tab behaviour to normal after using Microsoft Narrator?
By default, in Visual Studio and in SQL Server Management Studio, Ctrl+Tab opens a navigation popup which lists all the open windows. The idea is that you can press Tab multiple times while keeping Ctrl pressed; as soon as you release Ctrl, the navigation popup disappears and the selected document is activated. Unfortunately, as soon as...
Generate SQL server scripts from command line?
In Microsoft SQL Server Management Studio 2008 there is a "Generate scripts..." option under the Tasks menu. I'm just wondering if this tool is available from the command line somehow? It looks similar to the sqlpubwiz.exe command line tool that was available for SQL Server 2005, but I can't find this executable anywhere in the SQL 20...
Microsoft SQL Service Management Studio 2005 'Script XXX as CREATE To' problem
When using the 'Script Index as CREATE To' to duplicate an index from one table to another table I am not able to run the script. Without editing the generated code I get an error. I get the same error when working with any 'Script XXX as CREATE To' generated code. Any comments/suggestions to solve this problem? ERROR: Msg 170, Leve...
Find in Files command in SQL Server Management Studio
Is there way to use the "Find in Files" command for searching all of the stored procedures and views for a particular database in SQL Server 2005 Management Studio? Edit I want to search all of the stored procedures in database X for string Y. ...
SQL Server 08 - way to edit one specific row in the GUI
In Microsoft SQL Server Management Studio 2008 - is there not a secret to being able to edit one row based on a key? There's an option to do "Edit Top 200 Rows", but what if I want to select some other row and edit it in the data-grid? I would rather do that than code an update statement and risk messing up the where clause. Is th...
Hide/Filter tables in SQL Server Management Studio
I have a SQL database that has several hundred tables in it, but I only need to work with a few. Is there a way to hide most of the tables from view within SQL Server Management Studio 2008? Another option would be to create some sort of grouping that would only reference the tables I'm interested in. Filtering the tables works, but I...
Speed up SQL Management Studio's Object Explorer on a shared hosting SQL Server environment
Hello! When I expand the "databases"-folder in the Object Explorer in SQL Management Studio Express it tends to load ALL databases that exists on my shared host. This results in very long delays (the app freezes totally and sometimes also crashes). I just need to see the object tree of one database. Is there any way to overcome this i...