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
4 answers

SQL Server Management Studio - find stored procedure by name over multiple databases

I have recently joined a software project that has approximately 20-40 databases. Each database has at least 200 stored procedures, some of them have many more, so it is very slow for me to search for a particular procedure manually. I know that…
Barney Chambers
  • 2,720
  • 6
  • 42
  • 78
2
votes
1 answer

How to show dialog for getting value of parameter in SQL Server?

How can I show a dialog for getting values of parameters in SQL Server? For example there are two parameters in a query, @Name and @Family; right now, I get two dialogs instead of using SET. Example: DECLARE @Name VARCHAR(50); SET @Name =…
Chad
  • 133
  • 9
2
votes
2 answers

SQL Server Management Studio won't recognize a tables

This happens frequently to me, SQL Server doesn't recognize my tables. I tried to refresh the database, also tried to refresh the intellisense. But nothing worked! Could anyone help please?
Mustafa Alsuhaibi
  • 57
  • 9
2
votes
1 answer

SQL Server Management Studio 2012 doesn't allow single quotation typing

If I type text in SQL Server Management Studio then it doesn't repond when I type the single ' character. If I type it twice however then it shows me both next to each other e.g. '' Since strings in queries are identified with single quotes it is…
dfmetro
  • 4,462
  • 8
  • 39
  • 65
2
votes
2 answers

How to change default keyboard shortcuts for SSMS

I would like to assign my stored procedures for shortcuts CTRL+1 or CTRL+2 which are reserved by default to sp_who or sp_lock procedures. How to change shortcut for Ctrl+1
Przemyslaw Remin
  • 6,276
  • 25
  • 113
  • 191
2
votes
6 answers

SQL adding a new column to check whether ID appears in another table

I work with student data and have two tables with the same structure but different data sets. I would like to add a new column with a record of '0' or '1' to determine whether or not the student appears in the other table. Example: Table 1: s_id …
Emily
  • 105
  • 10
2
votes
1 answer

Creating a ssis package using sql server data tools

I am new to ssis.I have a task where i need to import data from table to excel and table contains nearly 500K records.My problem is when opt for excel file destination and create a connection manager and use excel 2007 then i cannot see tables under…
mamatha
  • 55
  • 7
2
votes
1 answer

Object Explorer not showing all available databases in ssms

In ssms I connect to a server. It displays two tables, master and tempDB. Under the Available Databases dropdown I see master,tempDB, and mydatabase. only tempDB and master are visible in object explorer however. Then I run SELECT * INTO newtable…
Maxwell Chandler
  • 626
  • 8
  • 18
2
votes
0 answers

"Could not load file or assembly SqlPackageBase" error when trying to query in SSMS

I've just installed SSMS 17.2. I'm connecting to a SQL Server DB using a VPN. I can connect in fine, but when I click to query, I get the following error: Could not load file or assembly 'SqlPackageBase, Version=14.100.0.0, Culture=neutral,…
D Leigh
  • 21
  • 1
2
votes
5 answers

How to check if field is NULL and blank?

I'm trying to remove the possibility of blank spaces by a value not existing in the database when creating the view for my lookup. The issue I'm having is that my CASE statement isn't working quite right when I'm trying to check for a NULL or blank…
Alex
  • 673
  • 3
  • 9
  • 22
2
votes
1 answer

Disable constraints temporary in SQL server

I want to copy all data from one database to another one, but I have many problems with foreign keys which cannot be inserted that easily. I would like to disable foreign keys, insert data, and then enable them again. What is the easiest way to do…
Ivan
  • 495
  • 3
  • 9
  • 20
2
votes
1 answer

Finding the right SQL report

I know that I've used it before but I cannot find it now. I have several SQL Server Agent jobs that run. Some of them fail, but the error messages in the History are not very helpful. I found a report that helped, but now I cannot remember where I…
Mike
  • 1,853
  • 3
  • 45
  • 75
2
votes
3 answers

Combine select top 1 SQL Statements

I have 4 select statements: SELECT top 1 software, auditDate, versionNumber FROM table1 where software = 'software1' order by auditDate desc SELECT top 1 software, auditDate, versionNumber FROM table1 where software = 'software2' order by auditDate…
CuriousOne
  • 922
  • 1
  • 10
  • 26
2
votes
1 answer

SQL - Show if a record is created after another record

I want to be able to check if a specific record (in this case "under" has been created after an initial record has been created and show that in a separate with either "under" or null. Example Data Received Name Sub 01-Jun Mike …
Michael
  • 63
  • 7
2
votes
1 answer

Stored procedure with optional parameter that doesn't show in SQL Server Management Studio "execute stored procedure" or "script stored procedure"

In SQL Server Management Studio (SSMS), you can execute a stored procedure using the GUI for assistance. This can done by right-clicking on the stored procedure in the Object Explorer and selecting either "Execute Stored Procedure" or "Script…
rory.ap
  • 34,009
  • 10
  • 83
  • 174
1 2 3
…
99 100