Stack Overflow
Stack Overflow

Questions tagged [ssms]

Microsoft SQL Server Management Studio is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server.

SQL Server Management Studio is a tool included with Microsoft SQL Server 2005 and later versions for accessing, configuring, managing, administering and developing all components within Microsoft SQL Server. The tool includes both script editors and graphical tools which work with objects and features of the server.

SSMS combines the features of Enterprise Manager, Query Analyzer, and Analysis Manager, included in previous releases of SQL Server, into a single environment. In addition, SSMS works with all components of SQL Server such as Reporting Services and Integration Services. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.

On Wikipedia: SQL Server Management Studio

7484 questions
2
votes
3 answers

Trying to connect to Azure Analysis Services through SSMS

I've been trying to connect to AZure analysis services through SSMS by using the server name found in the portal. However 2 things are strange: in SSMS the Windows authentication is grayed out and also it is causing me the error as below. Any…
Sambas23
  • 683
  • 1
  • 13
  • 27
2
votes
2 answers

in SSMS, is there any way to preview table contents without writing a query?

Browsing table contents in SQL Server Management Studio (SSMS) doesn't seem as easy as it should be. In contrast to other client software I have used, I can't find a way to simply click on a table and view its top rows (i.e. preview it). The closest…
Stephen
  • 8,508
  • 12
  • 56
  • 96
2
votes
1 answer

Compare SSMS settings

I am wanting to compare the settings of SSMS 2016 installed on two different machines is there an easy way to this instead of pulling up each setting and going through one at a time in the GUI.
Chad Portman
  • 1,134
  • 4
  • 12
  • 38
2
votes
3 answers

Generate create script of a existing database , without data - SQL Server 2008

Is there a feature in sql server 2008 management studio to generate database create scripts from existing database without data and with all the relationships maintained.
SRA
  • 1,681
  • 7
  • 27
  • 49
2
votes
1 answer

Why can't I connect to the SQL Server instance on my local machine?

I have just installed SQL Server 2016 (Developer Edition) database engine on my dev machine (Windows 10). When installing I named the instance CUBE, with Windows authentication using the current (only) user's credentials. I can see the instance…
Vinyl Warmth
  • 2,226
  • 3
  • 25
  • 50
2
votes
1 answer

List of all (User defined scalar) functions and their dependencies

I'm trying to select a list of all the functions in the database and their dependencies. (The dependencies that would appear if I were to view the dependencies manually and select the 'Objects that depend on [function]' option.) My main problem is…
Josh B
  • 324
  • 1
  • 3
  • 20
2
votes
2 answers

Incorrect syntax near 'for' SQL Server

I want to add a new Column to an existing Table that has already Data in it. The Column should be NOT NULL. Because of that i want to set a Default Value. But when i do it throws the following exception: "Incorrect syntax near 'for'" ALTER TABLE…
P.Haldemann
  • 46
  • 8
2
votes
2 answers

Database reports option is disabled in SQL Server

I restored the database from a .bak file by running a PowerShell script. Today, when I tried to check the database with "Reports", I noticed it had been disabled. See the screenshot: Not quite sure whether there is anything wrong with the script I…
user1888955
  • 626
  • 1
  • 9
  • 27
2
votes
2 answers

SQL Server Management Studio 2016: How to disable auto-capitalization of keywords

There was recently an update to SQL Server 2016 where keywords are automatically capitalized. While this is certainly convenient, I enjoy the freedom to capitalize words as I please (i.e. I don't always want keywords capitalized). Does anyone know…
user30625
  • 121
  • 5
2
votes
4 answers

Turn off display of header dashes in SQL Server Management Studio query results?

How can I tell SQL Server 2008 Management Studio to turn off printing of header dashes when displaying text results in a query window? Examples of header dashes being produced are: selectId, count(*) ContentCount from Table group by Id order by…
John K
  • 28,441
  • 31
  • 139
  • 229
2
votes
1 answer

SQL Management Studio 2014 auto-changing password for login

I have an issue where SSMS changes the password of a login after I have created it with a different password, and thus I am not able to log in with this new user, as I am not allowed to view the newly changed password. I looked around online and…
Leth
  • 1,033
  • 3
  • 15
  • 40
2
votes
0 answers

What are the 20 SQLEXPRESSnn users for?

I have SQL Server 2016 Express (13.0.4199.0) and my SSMS is 13.0.16106.4 I searched my PC (name Beethoven) user objects and found 20 SQLEXPRESSnn users as follows: Who are they and can they be deleted? I was actually looking for the usual…
Old Geezer
  • 14,854
  • 31
  • 111
  • 198
2
votes
2 answers

SQL Server Management Studio won't connect to Sql Server

I've installed Visual Web Developer 2010, SQL Server 2008 R2 and SQL Management Studio 2008, using the MS Web Platform Installer 2.0. But whenever I wanna login, with Windows Authentication, to SQL Server with the Sql Management Studio it throws me…
Shaoz
  • 10,573
  • 26
  • 72
  • 100
2
votes
4 answers

URL to make SSMS start and connect to a db?

It would be nice to have a bunch of reference links somewhere, that could also be used to start SSMS. Is this possible? and get it to use an already open instance? e.g. sqlwb -E -S Server\instance but I'm not sure if you can do this in the form of a…
adolf garlic
  • 3,034
  • 7
  • 39
  • 54
2
votes
3 answers

SQL using while loop to calculate values for multiple elements

I am trying to calculate an average daily stock of each item in a warehouse using Ms SQL. Every incoming and outgoing quantity is recorded in the same column, let's name it [quantity]. Due to this structure the only way for me to tell the stock…
Xberger_Pete
  • 33
  • 1
  • 6
1 2 3
…
99 100