Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
4
votes
3
answers
2k
views
Is it possible to enable Intellisense for SQL Server Management Studio Express 2012 (SSMS)?
I have installed SSMS to connect with my Old SQL Server 2005. Just want to test new features for new version of SSMS Express 2012. I use Right click on the Text Editor to enable Intellisense but I can'...
1
vote
2
answers
4k
views
SQL Server Management Studio: Database Attachment Failed
I have publish my website in IIS7. It is running in DefaultAppPool. The Identity of this app-pool is set to LocalSystem. The IIS is running and I can run the application from IIS without any problem.
...
2
votes
2
answers
2k
views
Configuring VM with SQL Express to be accessed using SSMS from host
I'm trying to configure my VM with SQL Server 2008 R2 Express so that I will only be able to remotely access SQL using SQL Server Management Studio from host machine.
VM configuration
running ...
0
votes
2
answers
4k
views
SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server
SQL Server Management Studio: network-related or instance-specific error while establishing a connection to SQL server.
Here's a screenshot of the error:
1
vote
0
answers
738
views
How do I migrate my registered servers in SSMS from one machine to another?
How do I migrate my registered servers in SSMS from one machine to another?
I tried copying %appdata%\Microsoft\Microsoft SQL Server\100\Tools\Shell over during my profile migration, but apparently ...
24
votes
6
answers
119k
views
How to Run an app as Administrator without the prompt?
When I start SQL Server Management Studio 2008, I get an error that's been around forever and is documented here. One of the suggestions to fix it that actually worked was to start SSMS with Run as ...
6
votes
1
answer
6k
views
How are SQL server management studio passwords saved?
If, when connecting to a database with sql server management studio and you select "remember password"... where and how is it saved?
I presume it is somehow encrypted using your windows login ...
34
votes
2
answers
109k
views
Anyway to use SSMS to connect to MySql?
I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection?
I realise ...
1
vote
2
answers
5k
views
How do I get a standalone SQL Server Management Studio (SSMS)?
I don't want to install the entire SQL Server (2005 or 2008) on my Virtual PC (saving space), yet I need the SSMS to connect to external databases.
What are my options?
0
votes
4
answers
1k
views
Tool to copy SQL Server Database [closed]
I am looking for a tool to copy a sql database tables, stored procedures, functions etc and also the data contained within the database from a server to my local pc. Both have sql server management ...
3
votes
1
answer
3k
views
Installing SQL server express 2008 SP1 on Windows 7
I'm installing (well trying to) SQL server express 2008 SP1 on Windows 7
This is not working for me.
I started by installing VS2010 B2, it installed SQL 2008 Express.
I went into the 'SQL Server ...
6
votes
2
answers
11k
views
Avoid "The source control provider associated..... could not be found" message in SSMS
Every time I open my *.ssmssqlproj in SSMS i get the message:
The source control provider associated
with this solution could not be found.
The projects will be treated as not
under source control.Do ...