#sql-management-studio

Fixed: Is it possible to open a sqlite database from within microsoft sql management studio? #dev #solution #programming

Is it possible to open a sqlite database from within microsoft sql management studio?

Is there a way to open a .db file (sqlite database file) from within microsoft sql management studio?

Right now we have a process that will grab the data from a microsoft sql server database and put it into a sqlite database file that will be used by an application later on.

Is there a way to open the sqlite…

Answer: SQL Server Management Studio Color Schemes? #fix #answer #solution

SQL Server Management Studio Color Schemes?

Is there a way to apply color schemes and themes to SQL Server Management Studio? I really enjoy the ones for Visual Studio 2005/2008/2010 and would love to have something like that.

Color Schemes for Visual Studio:

Create and share Visual Studio color schemes

Edit:

I want to add that I mean color schemes of the editor, not the actual…

How to: Removing the remembered login and password list in SQL Management Studio

Removing the remembered login and password list in SQL Management Studio

I’ve recently used our company’s spare laptop (that has a general user set up) while mine was being repaired. I’ve checked the “remember password” option in SQL Management studio when logging in to the database. I need to clear the login and password information that i have used to prevent the next person that will use the…

Fixed Saving changes is not permitted in SQL Server #dev #it #asnwer

Saving changes is not permitted in SQL Server

When I create a table in SQL Server and save it, if I try to edit the table design, like change a column type from int to real, I get this error:

Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can’t be recreated or enabled the option…

Fixed Where is SQL Server Management Studio 2012? #dev #it #asnwer

Where is SQL Server Management Studio 2012?

I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop (we’re a training company – hence the need for multiple versions). I’ve installed SQL Server 2012 and have finally got SQL Server Data Tools to show up, so that I can create SSRS reports in Visual Studio 2010. However…

Although I’ve installed Management tools – many times – on two…

How to: Where is SQL Server Management Studio 2012?

Where is SQL Server Management Studio 2012?

I had SQL Server 2008 R2 and Visual Studio 2008 and 2010 on my laptop (we’re a training company – hence the need for multiple versions). I’ve installed SQL Server 2012 and have finally got SQL Server Data Tools to show up, so that I can create SSRS reports in Visual Studio 2010. However…

Although I’ve installed Management tools – many times – on two…