Had the same problem, I fixed it. Open SQL Server Configuration manager Click on the SQL Server Services (on the left) Double-click on the SQL Server Instance that I wanted to start Select the Built-in account radio button in the Log On tab and choose Local system from the dropdown menu Click apply at the … Read more
LocalDB was introduced in SQL Server 2012 CTP3. It’s basically a new version of SQL Express, with same functionality, dedicated to developers. So you don’t need to install any SQL server. If you have installed SQL 2012 or Visual Studio 11 then you already have it, and it runs over .Net 4 or higher. If … Read more
Quick and Easy way: Right click database Point to tasks In SSMS 2017 you need to ignore step 2 – the generate scripts options is at the top level of the context menu Thanks to Daniel for the comment to update. Select generate scripts Click next Choose tables Click next Click advanced Scroll to Types … Read more
Another answer here also mentions since 2012 you can remove Remove cached login via How to remove cached server names from the Connect to Server dialog?. Just confirmed this delete in MRU list works fine in 2016 and 2017. SQL Server Management Studio 2017 delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\14.0\SqlStudio.bin SQL Server Management Studio … Read more
In SSMS 2012 there’s an option for this, in Tools -> Options -> Query Results -> SQL Server -> Results to Grid, it’s called “Quote strings containing list separators when saving .csv results”. I don’t know how long such an option has existed for, but I’m baffled by two things: How come it’s not turned … Read more
I am totally unable to connect to localdb with any tool including MSSMA, sqlcmd, etc. You would think Microsoft would document this, but I find nothing on MSDN. I have v12 and tried (localdb)\v12.0 and that didn’t work. Issuing the command sqllocaldb i MSSQLLocalDB shows that the local instance is running, but there is no … Read more
DECLARE @v XML = (SELECT * FROM <tablename> FOR XML AUTO) Insert the above statement at the point where you want to view the table’s contents. The table’s contents will be rendered as XML in the locals window, or you can add @v to the watches window.
Right click the database itself, Tasks -> Generate Scripts… Then follow the wizard. For SSMS2008+, if you want to also export the data, on the “Set Scripting Options” step, select the “Advanced” button and change “Types of data to script” from “Schema Only” to “Data Only” or “Schema and Data”.
Late answer, but hopefully worthwhile: The Poor Man’s T-SQL Formatter is an open-source (free) T-SQL formatter with complete T-SQL batch/script support (any DDL, any DML), SSMS Plugin, command-line bulk formatter, and other options. It’s available for immediate/online use at http://poorsql.com, and just today graduated to “version 1.0” (it was in beta version for a few … Read more
Such unexpected problems can appear when you copy the code from a web page or email and the text contains unprintable characters like individual CR or LF and non-breaking spaces.