Questions tagged [ssms]
SQL Server Management Studio is an IDE for administering Microsoft SQL Server.
117
questions
2
votes
1
answer
2k
views
How can I connect to sql server from a different domain/network
I installed SQL Server 2008 R2 on 6 machines. They are to be placed in 2 offices, 3 in each.
I created a database instance and I used VB6 and was able to link both perfectly.
I was also able to ...
2
votes
1
answer
2k
views
Loading Files from My User Directory in SQL Server Management Studio 2012 Under Windows 8
I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible ...
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?
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.
...
1
vote
1
answer
383
views
SSMS view designer - how do I give a table an alias?
I'm struggling with getting SQL Server Management Studio to do what I want. Things that were totally simple and easy tasks in Enterprise Manager have inexplicably become hard or impossible.
Case in ...
1
vote
1
answer
471
views
Outlining while modifying a multistatement function in SQL Server Management Studio
When coding in an empty query window, IntelliSense gives me useful collapse/expand buttons on each BEGIN-END statement to hide underlying code, apparently called "outlining". However, when I ...
1
vote
1
answer
439
views
Live Filtering Object Explorer in SSMS
Are there any tools or extensions that all you to live filter database objects inside SQL Server Management Studio's Object Explorer?
Here's what Currently Exists
The Out-of-the-box functionality ...
1
vote
1
answer
742
views
Check Status of All SQL Services
I wanted to List all the SQL Services including Reporting Services.
Wmic service where (PathName like '%Binn\%sql%') get caption, name, startmode, state, PathName, ProcessId
This one will give all ...
1
vote
1
answer
166
views
SSMS 2008 is stuck because Connect to Server window is hiding
Launching SQL Server Management Studio 2008 after rdp or similar display config funny business, the Connect to Server window is sometimes hiding in the corner of a monitor. The program seems stuck, ...
1
vote
2
answers
6k
views
Errors during installation SQL Server Management Studio (ssms) on 64-bit Windows7
I have been trying to install SQL Server Management Studio (ssms) on a 64-bit Windows7 for two days now and it just doesn't work.
On a otherwise completely clean 64-bit Windows7 system I get the ...
1
vote
0
answers
233
views
Microsoft SQL Server Management Studio starts to consume 100% of CPU after a while when the VPN connection to the SQL Server is disconnected
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers.
This question does not appear to be about programming within the scope defined in the help center.
...
1
vote
0
answers
204
views
copy ssms query result and paste as table in ms teams
is it possible to copy results from ssms results and copy that results into ms teams chat as table? What I do now is that I copy data from ssms into excel and from excel I copy into MS Teams. But I ...
1
vote
1
answer
3k
views
How to open SSMS as a different user using username and NOT using email address?
I am trying to run SSMS as a different user and it is not letting me run as a different user. It is asking for email address instead. How to get around this issue?
Thanks in advance.
I have tried ...
1
vote
1
answer
708
views
Why are my Database Diagrams now blank after upgrading to SSMS 18.12.1
I upgraded SSMS this morning to 18.12.1, but when I open my database diagrams all of them are displayed as blank pages.
How do I fix this?
1
vote
0
answers
499
views
SSMS 18.9.2 Crashing shortly after loading
I'm running SSMS 18.9.2 on a Windows 10 computer.
SSMS crashes as soon as I start typing in an SQL template, as soon as an auto-complete list pops up.
I get the following from Windows Event Viewer
...