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

How to create table in another schema SSMS

I have created a table in Person schema in AdventureWorks2012 with sql query. But I don't know how to do this with SSMS wizard. I did it this with the query. Create table [SchemaName].[Tablename] But I couldn't it with SSMS Databases ->…
Başar Kaya
  • 354
  • 6
  • 13
2
votes
1 answer

Is it possible to automate `EXEC tSQLt.RunAll` in SQL Agent?

I have followed the examples from tSQLt and have successfully created unit and integration tests for my SQL Server database. I know that Redgate sells DevOps tools for automating tSQLt unit and integration tests, but I don't have that kind of money.…
RandomHandle
  • 641
  • 7
  • 25
2
votes
2 answers

How would I filter out this column to display only english characters? Microsoft SQL Server Management Studio

For the table above, how would I filter the column description so that it only shows English characters? (removes out the '????s' and the French characters etc) I know it goes in the where clause, just can't figure out how. Any help is greatly…
Tangyfruitzz
  • 21
  • 2
2
votes
0 answers

.NET Standard & Databases (ADO.Net)

Is a ADO.Net Library the way to go with connecting to the DB In .NET Standard or is there any new standards with .NET Standard that I should be aware of? (Logically, I figured if there is a Standard on handling libraries then ADO.Net should be…
McCarson
  • 159
  • 13
2
votes
3 answers

Debugging stored procedure in SQL Server Management Studio (using context menu debug stored procedure

https://msdn.microsoft.com/en-us/library/hh272701(v=vs.103).aspx From the above link, it seems it is possible to debug a stored procedure in SSMS. I am accessing a SQL Server instance using SQL Server authentication with admin privileges. I want to…
Yogesh
  • 3,044
  • 8
  • 33
  • 60
2
votes
1 answer

SSIS/SSMS Connection to SAP Reports/Transactions

I am not familiar with SAP systems, but I have user access to an SAP instance that allows me to access, for example: transaction code FB03. I have been reading on the internet on possible ways to connect via SQL Management Studio or SSIS to SAP…
wr_lcb_ck
  • 85
  • 2
  • 9
2
votes
1 answer

SSMS Graphical Bug?

When I open up SSMS it looks like this: I've tried re-installing the program and downloading the latest .net and visual c++
Agneum
  • 727
  • 7
  • 23
2
votes
2 answers

SQL Server : usage of In vs Exists

I have some doubts on when to use IN operator and Exists operator. I know what they both are. Say, I have this query: Insert into AuditCardTypeBenefit_New(AuditID, AuditType, CardTypeBenefitID, EventCode, …
Cookie Monster
  • 636
  • 1
  • 12
  • 29
2
votes
3 answers

Return records where 2 columns don't match

I want to find records where two columns don't match. In order to do this I need to divide one of the columns by 100 (as it is in %). My table: |artno|artno2|Quantity_Percent|Quantity_pcs| |1111 |aaaa | 28 | 0,28 | |1111 |bbbb |…
SisU
  • 57
  • 1
  • 8
2
votes
2 answers

SSMS SQL - AVG in PIVOT returning totals, not averages

OK, this one is difficult. I'm sure that some use of the PIVOT statement is the answer, but I'm not knowledgeable enough to form the proper query. I think AVG is also throwing me for a loop. I'm looking for just the total costs for each month / the…
AdamQuark
  • 33
  • 5
2
votes
3 answers

SQL Server ISNUMERIC() Clarification

I have a table X with a list of accountNo's. This field(accoutNo) is a nvarchar(8). Now issue here is sometimes we get characters in this field as well and I want to convert it into bigint. Sorry I'am not able to put this in a table format…
Moshin Khan
  • 153
  • 2
  • 3
  • 14
2
votes
2 answers

SQL Server - Ways of renaming a table name

I want to rename a table in SQL Server. I know the proper syntax would be: sp_rename 'old table name','new table name'; Would it make any difference if I write it this way?: EXEC sp_rename 'old table name','new table name'; I tried running it on…
Cookie Monster
  • 636
  • 1
  • 12
  • 29
2
votes
4 answers

How to run SQL Server Management Studio Express from CD

Is it possible to run SQL Server Management Studio Express from CD without installing it on the computer? I need it sometimes to provide support for the client but do not want to install/uninstall it.
alex
  • 74,215
  • 9
  • 49
  • 57
2
votes
1 answer

SQL Syntax error (only when run as scheduled job)

I have just created a scheduled job to run daily, but when the job runs via the scheduler I get the error "Incorrect syntax near 'Item'. [SQLSTATE 42000] (Error 102)". This only happens when the job is run via the scheduler, and works fine when run…
Joe Cast
  • 23
  • 2
2
votes
1 answer

MS SQL Pivot Dynamic Headers

I have the following two tables: Serial Key Value ABC Attr1 ABC1 ABC Attr2 ABC2 ABC Attr3 ABC3 XYZ Attr1 XYZ1 XYZ Attr2 XYZ2 XYZ Attr3 XYZ3 and Key Include IncludeOrder Attr1 Y 2 Attr2 NULL …
Mooseman
  • 18,763
  • 14
  • 70
  • 93
1 2 3
…
99 100