Stack Overflow
Stack Overflow

Questions tagged [ssms-2017]

Microsoft SQL Server Management Studio 2017 is a graphical tool for configuring, managing, and administering all components within Microsoft SQL Server. Use this tag specifically for questions related to Microsoft SQL Server Management Studio 2017.

188 questions
2
votes
2 answers

SSMS Color tab based on connection string / Environment

SQL Server - SSMS Can we change the SSMS query tab color based on connection string? Lets say I'm connecting to different environments Prod / Dev / UAT/ Test etc... or I want to group my servers based on some other criteria
singhswat
  • 832
  • 7
  • 20
2
votes
1 answer

SSMS 17.9.1 crashes on "connect"

I installed SSMS 17.9.1. When I start SSMS it crashes when I try to connect to the database server. See this 5 second video https://vimeo.com/302442420/2ed86b92d8 My only action is to click on the "connect" button. Then the object explorer appears…
Ken Evans
  • 362
  • 1
  • 11
2
votes
0 answers

Creating new user in SSMS with dialog box

When I create a user in SSMS (Security, New, Login) it no longer presents a dialog box to me. It now creates Transact SQL code in a query window. Did I change a setting somewhere? Sorry for asking, but I've done all the Google searches I can think…
Gary Holeman
  • 21
  • 1
2
votes
2 answers

Login failed for user (but not really) in SSDT in SQL Server 2017

I have a weird problem with SSDT(Visual Studio 2017 server explorer) when I try to view the tables in my Database In SSMS (SQL Server Management Studio 2017) I created a database with a new user called admin. This user has public and sysadmin…
Fatih Taskent
  • 199
  • 13
2
votes
1 answer

How to perform "Order by" on an encrypted column (deterministic encryption - SQL 2016)

How to perform "Order by" on an encrypted column (deterministic encryption - SQL Server 2016) ? I am getting error when executed on SSMS 2017 (with required settings for AE) SELECT * FROM [dbo].[X] ORDER BY lastName The lastName column is defined…
se7vanj
  • 160
  • 2
  • 8
2
votes
0 answers

Incorrect error message in SQL Server script

I was used to use alter script base on table dbVersion and each change in database was in if statement. for example: DECLARE @DbVersion BIGINT, @now DATETIME = GETDATE() IF NOT EXISTS (SELECT 1 FROM sysobjects WHERE TYPE = 'U' and NAME =…
Davecz
  • 1,199
  • 3
  • 19
  • 43
1
vote
1 answer

Batch Updates taking too long. How can I improve performance

I need to update a large table, roughly 3B rows. Each record needs to update 4 fields of decimal(18,2) datatype. I have recreated the table with the corrected data to update the original table. Below is the statement I have been testing. It works,…
user8675309
  • 49
  • 6
1
vote
0 answers

How to avoid T-SQL to treat NaT datetime as zero datetime, instead treat them as null?

I have a pandas dataframe which includes a column named "date" and its type is datetime64[ns]. some date values are missing and therefore are filled in with value NaT which is np.datetime64('NaT'). when I import it to T-SQL database using…
yasharov
  • 113
  • 10
1
vote
0 answers

Transactional publication with updatable subscriptions is missing SSMS 2017

I am trying to create a transactional replication with updatable subscription in SQL Server Management Studio 2017 , meaning changes will be replicated from the publisher to the subscriber and vice versa but the option is missing in the Publication…
digital_fiasco
  • 11
  • 1
1
vote
0 answers

Unable to open ssms exe file

I have successfully downloaded and installed the developer version of SQL server 2019. Then I went to the SSMS website and downloaded the latest version of SSMS. The exe file was properly downloaded and it is not damaged at all. When I…
MD Sahabaj Ansari
  • 11
  • 1
1
vote
1 answer

Optimizing queries that search for text

I have SSRS report that uses a query that searches for specific text in the Where clause. I know using IDs is the preferred method of filtering data down, but this table only makes use of varchar strings...Very long strings I might add. There are 5…
JerrySeinfeld
  • 91
  • 9
1
vote
1 answer

Search Urdu text by Passing parameter in sql

Declare @Topic nvarchar(2000) ='.کثیر الانتخاب جواب میں سے صحیح جواب منتخب کیجئے' SELECT TextbookTopicId,Title FROM TextbookTopic tt WHERE tt.Title =@Topic I declared a variable and use in where clause but its not working. but if i use…
Tayyeb
  • 127
  • 7
1
vote
1 answer

Extra double quotes on export from SSMS to CSV

Upon using a text editor to review exported results from SSMS to CSV I'm witnessing extra double quotes around the result values - not field names. I've used the concat function in my script to manually add a single pair of double quotes around each…
Corey
  • 11
  • 1
  • 3
1
vote
1 answer

Run DTEXEC from SSMS to run SSIS Catalog Package

I would like to execute SSIS package using Catalog in a stored procedure using DTEXEC: DECLARE @cmd varchar(8000) DECLARE @params varchar(4000) SELECT @params = '/SET \Package.Variables[User::VarBigInt].Properties[Value];"' + CONVERT(char(10),…
Anonymous
  • 63
  • 1
  • 5
1
vote
1 answer

Cannot see expected PRINT or RAISERROR output when a later error is raised

I'm getting an error message in a stored procedure, saying that I can't insert a NULL value into a table, when I should be getting errors earlier in the code if the value is null. Here's the relevant part of the stored procedure: CREATE PROCEDURE…
Katerine459
  • 465
  • 1
  • 3
  • 13
1 2
3
…
12 13