ssms

Get SQL Server 2008 Management Studio icons

I want to get icons from SQL Server 2008 Management Studio. Is it free ? If so where can I download it ? ...

See images in SSMS?

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 ...

Copy a Table's data from a Stored Procedure

I am learning how to use SQL and Stored Procedures. I know the syntax is incorrect: Copy data from one table into another table on another Database with a Stored Procedure. The problem is I don't know what table or what database to copy to. I want it to use parameters and not specify the columns specifically. I have 2 Databases (Master...

SQL Server Management Studio edit timeout

I am trying to run a query to edit records in SQL Server Management Studio 2008 and keep getting the error: "SQL Execution Error. Error Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding." I have set the following: Execution Time-out: 0 Set Lock Timeout: -1 Transact...

Auto-complete editor for SQL statement

Is there any plugings or text editor to auto-complete SQL statement? I am using SQL Server Management Studio (ssms) 90% of time, but most of time I have to type SELECT FROM WITH(NOLOCK) WHERE blahblah. Trying to find a more efficient way. Thanks. ...

Schema objects not visible in SQL Server Management Studio 2008

I'm experiencing a weird problem with a SQL login. When I connect to the server in Microsoft SQL Server Management Studio (2008) using this account, I cannot see any of the tables, stored procedures etc. that this account should have access to on a particular database. When I connect to the same server within Visual Studio (2008) with t...

How to remove empty lines in SSMS?

I have many .sql files with lots of empty lines e.g. WITH cteTotalSales (SalesPersonID, NetSales) AS ( SELECT SalesPersonID, ROUND(SUM(SubTotal), 2) FROM Sales.SalesOrderHeader WHERE SalesPersonID IS NOT NULL GROUP BY SalesPersonID ) SELECT sp.FirstName + ' ' + sp.LastName AS FullName, sp.City + ',...

XML Output is Truncated in SQL

Hi, I need to return my result set in XML and this works fine, but if the number of records are increased, my xml output is truncated here is my query select t.id,t.name,t.address from test FOR XML AUTO, ROOT('Response'), ELEMENTS However I have set some option to increase the output result set like.. Tools --> Options --> Query Resu...

ssms copy database

Hello, I have a local sql express server with DB A and remote server uXXX.mssql.domainname.com with DB B. using sql mangament studio 2008, I want to move copy DB A to DB B with all tables, data, dependencies and stored procedures. how to figure out this problem? I only had understood table and table data copying(using Tasks->Import D...

ssms cannot connect to default sql server instance without specifying port number

I have multiple SQL Server 2005 instances on a box. From SSMS on my desktop I can connect to that box's named instances with no problem. After some recent network configuration changes, when I want to connect to the default instance from SSMS on my desktop, I have to specify the port number. Before the network changes, I did not have to ...

SQL Server Management Studio execute shortcut & keyboard shortcuts

Is there any easy way to execute a chunk of code instead of moving cursor to the beginning of code chunk, and shift + down arrow to the end of code, then hit F5? Is there any keyboard shortcut to duplicate line (duplicate several lines), delete line (delete several lines)? Thanks. ...

SQL Server 2008 - Query takes forever to finish even though work is actually done

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...

SQL - SSMS2005 - How do I copy a database diagram to another database?

Is there a simple method for copying a database diagram from one database server to another? I have a diagram on a development server that needs to be moved to the production server. Thanks (Sql server 2005, SSMS2005 Express) ...

VS2005 SQL Syntax highlighting is incorrect for nested comments?

I'm working with VS2005, and SSMS 2005. SQL Server allows nested comments as follows: /* Comment 1 /* Comment 2 */ Some commented out code here */ This code runs fine. However if putting the above into a .sql file in VS2005, it incorrectly shows the commented out code as 'active', (its not green). It seems that StackOverflow has hig...

Problem with connection to MS SQL Server database using SSMS

I have a database on line with Godaddy (who uses SQL Server 2005). They provide basic management tools, but tell you that for more advanced tools you can connect directly using SSMS. I followed their instructions to ensure my online database will accept remote connections, and can apparently log in using SSMS with success (after giving m...

SSMS Ctrl+Tab Page Thumbnail Preview Add-on?

Hey Now, Is there a SQL Server Management studio add-on/plug-in that will enhance the tab switching dialog box when Ctrl+Tab is used to switch tabs to provide a thumbnail image of the tab? When we use Ctrl+Tab to switch tabs we see the list of tabs open. When we switch tabs in Visual Studio we get a small thumb nail preview screen of t...

Constant server polling by SSMS 2005

As part of our corporate security practices it has been suggested that we turn on successful and failed login auditing on our SQL Server. Unfortunately the successful logins flood the event log with what appears to be polling from the SSMS client. Does anyone know if this is true and is there a way to change the polling interval or sto...

SQL Server Management Studio with SQL Server 2000

How to use SQL Server Management Studio with SQL Server 2000 ...

problem with trying to create ssms add-in

I'm trying to create an add-in for SSMS 2008 and/or 2008 R2 but I've run into a problem straight away. I can get my add-in to work and on SSMS start-up get it to simply show a message box. However, after downloading various code-samples, when trying to reference Microsoft.SqlServer.Management.UI.VSIntegration.ServiceCache I get a null ...

View full filenames in SQL Server

I'm using SQL Server Management Studio 2005, and I hate the way that the tabbed interface displays the current database and filename. It crams both together in the tab title so that most tabs end up with a name like "databas...ccountQuery.sql". I've tried the MDI interface, but it is not much better. Is there any way to make SSMS disp...