Category "ssms"

How to recover missing SQL auto-recover files in SSMS (Microsoft SQL Server Management Studio) after unexpected shutdown

My SQL Server Management Studio (SSMS) closed unexpectedly. Many SQL files were open. When SSMS was restarted, it did reopen some auto-recover files, but not al

How to convert nvarchar to date from one column to another in SQL Server

I have a column called “Month Year Raw” that has multiple nvarchar type data like this: 202201 and I want to convert that to a column called “

linked server : "No transaction is active." and "unable to begin a distributed transaction"

I have a CRM software on my local machine. In the SQL DB of the software, I added a linked server (our test website with our test DB: Windows Small Business Ser

How to connect to a local database in SQL Server Management Studio?

I have downloaded the SQL Server Management Studio (SSMS) 2016 to recover a huge .bak file which is an old backup of a database. But first of all I need to conn

SSMS shows 'Querying transaction count' on closing the query window

My job usually involves starting SSMS in the morning. There are multiple query tabs open at any given time during the day. At the end of the day when I go to cl

Can't select column name from Eloquence database that has a forward slash in it (from a linked server in SQL Server)

My SQL Server instance has a linked server to an Eloquence database. I need to select data from one of the tables in the Eloquence database, but I need to do i

View created in SQL Server Management Studio but not visible in "Views" section

I created a view in SQL Server Management Studio 18 and I am getting the following message: "Commands completed successfully." which I guess means that the view

Showing "The Visual Studio cache is out of date" when click new query in SQL Server

I use SQL Server 2016 Management Studio. After I connect to the server and click on "new query", a message appears: The Visual Studio cache is out of date

Unable to open SQL Server Management Studio

To download and install Microsoft SQL Server 2008 R2, I followed these steps from http://www.microsoft.com/en-in/download/details.aspx?id=22985: Download and i