I’ve created a table and then realised I made a mistake. SSMS wouldn’t let me update the table without recreating it, so I’ve deleted the table and then tried to create it again. It won’t let me do this, and I get an error dialog Table ‘dbo.Foo’ already exists. So I try to delete it […]
Is there any way to clear the Client Statistics table in Microsoft SQL Server Management Studio (2008 R2) besides create a new query?
On a per-object basis, SQL Server Management Studio has the option to script the object to clipboard, file, etc. Is there a way (at the database level) to do a “1-click” export of ddl AND data to a text file? Ideally I’d like to select a database and create a big text file containing the […]
Just to preface: I work in a small company that does ASP.NET development and uses SQL Server 2005 for all of our database needs. I was curious as to what were the pros and cons of using Visual Studio or SQL Server Management Studio for our development on the database side (i.e. table creation, stored […]
I am normally using SQL Server 2012 Management Studio to restore a SQL Server database from a “bak” file. I do this by overwriting an existing database. In the “Options” page, there is a check-box labeled “Close existing connections to destination database”, which I mostly check because the target database is always “in use”, even […]
I have a long query that I’d like to replace the , with a carriage return to put all the fields on their own line but I can’t figure out how to do it in the editor. It wont be fool proof, but better than doing it by hand.
Possible Duplicate: Lost the IntelliSense SQL Server 2008 Intellisense problem I’m new to SQL Server, so this is probably an easy fix. In SQL Server 2008 R2, I’ve just imported a new data table and/or renamed fields in an existing table (it happens either way). When I start to write some SQL, the intellisense doesn’t […]
I’d like to modify the appearance of the query window in SQL Server Management Studio based on which database I’m currently connected to. For example, using a yellow background for production databases. Is there a way to do this? Is there also a way to change the default color of the query status bar at […]
I have the full Visual Studio 2010 (not express) installed, with SQL Server that came with it as well: I was trying to locate SQL Server Management Studio (ssms) in order to follow this tutorial but I can’t seem to find it in my installation. I could theoretically download the 2008 Management Studio Express but […]
In the “datagrid” view of an open table of data, how can I type a new line character into an nvarchar field directly in SSMS? Is there an alt code?