Questions tagged [ssms]

SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.

Filter by
Sorted by
Tagged with
0
votes
1answer
77 views

Error in AG Dashboard when looking at a Distributed AG

I have a Distributed AG, but whenever I go to look at the AG Dashboard it says "An error occurred on the Always On Dashboard". When I click for details I get "Object reference not set to an instance ...
0
votes
1answer
47 views

Find minimum number of columns that identify uniqely all rows

I'm using SQL Server Management Studio. I've a table and I want to find a Primary Key for this table. Can I write a script in T-SQL that finds which columns (and I want that the number of columns is ...
0
votes
2answers
2k views

Imposssible to expand a database in SQL Server Management Studio

I am experiecing a strange problem. I have a SQL Server 20008 R2 instance that recently (after years of running smoothly) started to become slow. One symptom that I notice is that when working from ...
1
vote
2answers
269 views

Queries not logging when using Extended Events in MS-SQL Server to track queries

I'm using MS-SQL Server 2012 Standard, running on Windows Server 2012 RTM. I used SSMS to create a Extended Event Session, where I used the built-in "Batch Query Tracking" template and save the result ...
1
vote
2answers
3k views

“Untrusted Domain” error when connecting to SQL Server localhost and specifying port

I have two SQL Server 2016 instances running on localhost, and I can connect to both with no issues (localhost and localhost\test) using windows authentication. However, if I specify the port ...
-1
votes
2answers
3k views

Select all columns with same name from different tables

I have 4 tables. In 3 of these, there are a column named ACTIVE_FL which can have a value of "Y" or "N". How can I select, from all tables only the columns ACTIVE_FL which have as value "N" ? I ...
1
vote
2answers
814 views

How to make IntelliSense understand temp tables, linked servers and synonyms?

I'm using SSMS 17.6 which is the latest version at the time of posting. It is supposed to have the latest official IntelliSense version. However, it underlines my scripts with red squiggles where I'm ...
32
votes
4answers
5k views

Why does SQL Server return some rows while still executing the query, and sometimes not?

There are queries where when we hit "execute", it shows some rows and it keeps growing, but the query is not over yet. Yet sometimes, it waits until the end of the query. Why does this happen? Is ...
2
votes
1answer
1k views

SSMS 2017 Changing SSIS Package Version During Deployment

Steps taken, can be reproduced: Develop SSIS package in SSDT 2012, project deployment model. Deploy project to server A, SQL Server 2012. Package version internal.packages is 6. Deploy project from ...
1
vote
2answers
188 views

How to restrict SSMS to list the database of a particular user (Windows 2012 + Plesk)

We are using windows 2012 R2 server with Plesk and provide shared hosting for our customers. Version Details: MSSQL server 2012 and SSMS 11.0.2100.60 In SSMS if we login with particular user, it is ...
1
vote
0answers
324 views

C# Windows Service task fails due to a SP timeout, but works fine after executing the SP in SSMS

I have a Windows Service app running and sometimes a task which has a method call to a stored procedure (with a Select operation) is keep failing due to a timeout. But when I execute that SP with ...
0
votes
1answer
557 views

TCP address of SQL server not working in Mirroring

I am trying to mirror a database from my local SQL server instance to another SQL server instance found on the network using SQL Server management studio. I am having troubles providing the TCP:// ...
0
votes
0answers
52 views

Issue with diagrams in sql management studio 2014

I have this issue with sql management studio 2014. When creating a new database diagram and when I add existing table to a new diagram, the data inside a table is obsolete. I tried both dragging a ...
1
vote
0answers
614 views

Yet Another “Connection Timeout Expired pre-handshake acknowledgement” problem

This is SQL Server 2012SP4 on Windows 2012R2, with .NET Framework 4.7.02053. I've RDPed into the database VM and open SSMS. It times out with this error the first time I try to connect. If I try ...
0
votes
3answers
286 views

Wrap identifiers automatically with brackets in SSMS text editor

Working in SQL Server Management Studio, when using the text editor: Is there any way to automatically wrap schema names, table names, column names and other identifiers with brackets so I don't have ...
1
vote
3answers
3k views

How to send Email from a SQL Job with results of multiple select statements

I want to create a SQL job and send an emails with multiple select statements including in query results. Is it possible with SQL Job or should I use SSIS? Edit 1: EXEC msdb.dbo.sp_send_dbmail ...
0
votes
1answer
125 views

Can't connect to SQL Server DB from SSMS network error

Here some background on the setup. The app server and the db server are on a workgroup no domain. Both are AWS EC2 instances. A partner went and install an evaluation copy of SQL Server 2014. I apply ...
2
votes
0answers
259 views

In SSMS “SQL Server Agent” sub folders are appearing twice

I have SSMS 17 installed on my system, after I connected to database instance, I found sub folders of SQL Server Agent are repeating. Thanks!
7
votes
1answer
125 views

What is the StatementParameterizationType plan attribute?

I have noticed execution plans sometimes include a StatementParameterizationType attribute. What is this, what does it mean, and when does it appear?
-1
votes
1answer
373 views

cannot read property user access. this property is not available on sql server 7.0

I want to know the .mdf file path from property tab of a db, but it was throwing error as cannot read property user access. this property is not available on sql server 7.0 Note : on querying my ...
0
votes
0answers
155 views

What are the notable difference between versions of SSMS?

I've been updating all the software at my new workplace, and people are asking me not to break something on accident if it's working. You know how it goes. But I'm also curious myself about what is ...
2
votes
1answer
50 views

Setting Up SQL Alerts

I have turned on notifications via email on my SQL Server Agent if any of my scheduled jobs failed or is successful. Can anyone help me if I want to set up Alerts, if in case one of the scheduled job ...
1
vote
1answer
2k views

SSRS report stuck on Loading but ExecutionLog says otherwise

I have a report that is stuck on loading in the reporting server portal (it's been over a day). However when i check the ExecutionLog... select * from ExecutionLog3 WHERE UserName = '...
0
votes
2answers
41 views

Why VIEWS are showing in Data Transfer Service SQL

Im trying to run DTS from one Db to another in Same server instance. But at the select objects to copy stage, its showing the VIEWs also. But VIEWS are only some customised queries. But why its been ...
2
votes
1answer
56 views

SQL Management Studio - Add-on / Extension to view Column Data Type

Is there any way (built in) or free/paid add-on/Extension for SQL Management Studio that allows us to know exactly a data type of a column when we are writing a query? In this specific project I have ...
0
votes
1answer
2k views

Connection issues with Azure DB from SSMS

I am currently making a connection to Azure DB from SSMS using public wifi. For the past few days, I was able to connect SSMS to Azure DB without any issues by adding the current ip address into the ...
1
vote
1answer
134 views

Extended Events: Specify Session Data Storage left blank

What happens if the Data Storage is never configured?
4
votes
1answer
177 views

SSMS - Query variables from Table Design Mode > Column Description

I need to query the description of the Sales.SalesOrderHeader.Status column from the AdventureWorks OLTP, which looks like this: | SalesOrderID | RevisionNumber | OrderDate | ShipDate | Status | +-...
0
votes
2answers
98 views

Restoring a database

Say I have a database Live on some instance. I have created a backup of it and now I need to restore it into a new database named Dev. In SSMS I am choosing a device Live.bak, then in destination I am ...
-1
votes
1answer
196 views

SQL Management Studio Intellisense - Hide global variables

I am not sure if this is possible, but when writing a query to select from a table, when I bring up the intellisense drop down with CTRL + Spacebar, it gives me a list of all variables (global, and on ...
2
votes
1answer
593 views

How to implement a multi-user account facility in a database

I'm modelling a database schema that has the requirement of including a multi-user account facility for premium customers: A multiple account enables multiple users to login to the same account ...
0
votes
1answer
313 views

Creating Database Mail with T-SQL returns “principal name is not valid”

Configuring Database Mail is so long. So I want to create a script that automatically create it for me DECLARE @YourEmail NVARCHAR(50) SET @YourEmail = 'MyEmail@mydomain.com' --Put here your E-mail ...
1
vote
0answers
58 views

SQL Server 2012 Management Studio not loading

I have installed SQL Server 2012 on my Windows 10 machine, but when I launch SQL Server Management Studio, the splash screen shows for a minute but then the tool never comes up. The computer is ...
8
votes
2answers
619 views

Select TOP N Rows missing from SSMS temporal table

I am using temporal tables within my database and when I right click on my table in Management Studio 2017 (v17.4 14.0.17213.0) I do not see the Select Top 1000 Rows in the context menu (there is no ...
0
votes
1answer
592 views

Linking SQL servers error

When i try to connect a linked server, i´ll get this error message : TITLE: Microsoft SQL Server Management Studio The linked server has been created but failed a connection test. Do you want to ...
1
vote
0answers
549 views

Error while importing flat file (CSV) in SSMS 17.5

I'm not sure if this is a bug or not, but when trying to import a CSV file (with no headers and text qualified (")) using the new "Import Flat File" in SSMS, I get this error: "A column named foo ...
2
votes
0answers
17 views

How to reconnect to network file

How do I reconnect the open files in SSMS to their network locations for change tracking? After disconnecting my laptop from my network at work and then reconnecting through a VPN the sql script ...
4
votes
2answers
1k views

Does this regex reliably remove square brackets from T-SQL?

I'm using SQL Server Management Studio 17.4, which supports search-and-replace using a Microsoft version of regular expressions (regex). I need a regex expression that can reliably remove square ...
1
vote
2answers
78 views

Required values for the performance counters

That will sound ludicrously, by the accident i became a 'dba' and have to handle one big database around 2TB data. I would like to know what are optimal values for the following performance counters ...
0
votes
2answers
1k views

How to change the current database in an SQL Query window in SSMS?

I'm trying to create a SQL script that creates a new server login in the master database, and then creates a corresponding user in an existing database. If the 'USE [database_name]' appears more than ...
3
votes
1answer
654 views

EDIT TOP 200 ROWS - conversion error

I have a user who is working with a new manufacturing SCADA platform. He has a simple table with the following design: Column Name DataType AllowNulls identkey (PK) INT NO ...
9
votes
2answers
1k views

SMO, SSMS are slow for management of SQL Server in Docker when connecting to localhost

TL;DR: When connecting to my SQL Server Docker container via a name that resolves to the IPv6 loopback (::1), SMO calls are really slow. When using 127.0.0.1, they're fast. I am trying to learn how ...
2
votes
1answer
63 views

Is it ok to have huge page life expectancy? [duplicate]

Recently I have buffer issue for my SSIS package. When i started to monitor metrics in perfmon i noticed the PLE is nearly 500000. Is it ok to have this huge PLE.
1
vote
3answers
2k views

Partial Data Export - MS SQL

In SQL Server Management Studio 2014, How to apply a WHERE condition during Generating Script (Data only) for a particular Table? I'm using Generate Scripts method as I dont have Remote Server ...
2
votes
0answers
616 views

Attempt at SSIS Execution Throws Invalid object name 'SSISDB.catalog.customized_logging_levels'

I can run the SSIS package in SSMS 2014 if I set the build to SQL Server 2012, but attempting to run in SSMS 2017 v17.4 upgraded from 17.3x (didn't work there either) SQL Server version 13.0.4451.0 ...
4
votes
1answer
111 views

Does SSMS v17 allow user input in Python scripts?

With the introduction of Python feature shipped with SQL Server 2017, I would like to know if anyone has been able to use SSMS v17.x and run a python script that requires a user input. Here is a ...
4
votes
3answers
7k views

SSMS 2014 Gives an exception when opening the new query window

I have an installation of SQL Server 2014 on a server on the LAN and on my PC I have SQL Server Management Studio 2014 for few months already. Out of no where when I open SSMS I get The type ...
0
votes
1answer
352 views

Unable to connect to Listener after rebuild

I dropped an AG with DROP AVAILABILITY GROUP [MyDb] it had a listener. I left the listener open in the object Explorer of SSMS 17.3. While the AG and Listener were down. I hit refresh on the ...
0
votes
1answer
67 views

creating server with Microsoft Server Management Studio

I am working with a django project and I want to connect it to local server. I downloaded the Microsoft Server Management Studio but got lost on how to create a server and database? If I am not ...
7
votes
2answers
4k views

Update SQL Server Management Studio without restart [closed]

When I install or update SQL Server Management Studio it always asks to restart the server. Like now when I updated from 17.3 to 17.4, it asks to restart the server when the update is finished. Is it ...