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
0
votes
1 answer

Update columns based on different criteria using merge statement

So I am using the following merge statement to do an update and insert in one of my tables, however I would like to update another column in the Target table in addition to the one already in the statement. I'm just not sure if I can do that or how…
KAL077
  • 85
  • 1
  • 1
  • 7
0
votes
1 answer

Is there a way to add .sqlproj to SSMS solution explorer?

I would like to add a .sqlproj (Visual Studio SQL Server Database Project) to SSMS Solution explorer. When I go to File | Open Projects, this extension is not available
Marzipan
  • 13
  • 4
0
votes
1 answer

Creating Registered Servers via Powershell in SSMS

A cool trick that used to work for me is creating Registered Server groups and registrations in SQL Server Management Studio via PowerShell. However, now that I am running the current version (SSMS 17.9.1) I find the functionality has been lost. I'm…
Ed Callahan
  • 189
  • 6
0
votes
2 answers

SQL Matching a string that contains a string

I have two tables in database. Both tables have a business name column but not always going to be the same. For example tbl 1 has a business name of 'Aone Dental Practices Limited TA Jaws Dental' and Tbl 2 has a business name of 'Jaws Dental'. I…
Sam Parky
  • 31
  • 7
0
votes
1 answer

SQL Server 2017 - Database mail stored procedure

I have a stored procedure which basically I want to do the following: Create temp table (if not exists) and populate with data Output the query to SSMS, and assigning the query a variable (@sql) Using the query, e-mail the contents of the query to…
Mike Mirabelli
  • 402
  • 3
  • 16
0
votes
0 answers

Visual Studio Error with SQL Server Express

So when I try to attach my Database tp Visual Studio it does this. I have deleted LocalDB from my system as we told me it would be useless but it might have been wrong? I use Visual Studio Community 2017 and SQL Server Express 17 Sql Server…
S. Stone
  • 33
  • 1
  • 7
0
votes
1 answer

Operand clash with date table and varchar date strings in cross join

This follows on from my previous question, but since I tried to simplify, I appear to have missed something Daily snapshot table using cte loop I am trying to set up the below cross join between dates and an employee table. I need a daily count…
user10624545
0
votes
1 answer

SSMS 17.9 opens database on SQL Server 2014 instead of 2016

I have SQL Server 2014 and I did use it and have some db on it. Yesterday I installed SQL Server Management Studio 17.9 and when I open it I just see the same db created on SQL Server 2014 (sql 12.0.2000.8). But I want to create or restore some db…
siyavash
  • 168
  • 2
  • 14
0
votes
0 answers

SQL local server disappear after uninstall SSMS 2014 and install SSMS 2017

I am planning to install the latest version SQL Server Management Studio SSMS 2017 and trying to use the same local server name which was on SSMS 2014. So I uninstalled SSMS 2014 then install SSMS 2017. After the installation complete, I am not able…
Felix JIN
  • 101
  • 1
  • 1
  • 11
0
votes
0 answers

Must declare the scalar variable @bundleTransfer when it's a table type?

Summary I'm trying to use a user-defined table type and return it from a table-valued function. Currently using SQL Server 2008 and its XML queries. Sample create type udtBundleTransferTableType table as ( C_PPPI_BATCH …
Will Marcouiller
  • 23,773
  • 22
  • 96
  • 162
0
votes
2 answers

How to Rollback Transaction SSIS without MSDTC?

1st .) I have a Sequence container. It has 4 different execute sql tasks and 4 different DFT where data is inserting into different tables . I want to implement transaction with or without MSDTC service on the package failure i.e., each and every…
Jaideb Mandal
  • 1
  • 1
0
votes
0 answers

How to read text file into table variable using bcp command

I have text file which contains below value, ABC PQR ALM kkk ppp etc.... How to read these values in table variable using bcp command
Sweety
  • 117
  • 6
  • 18
0
votes
0 answers

Package deployed in azure sql server fails as it cant access remote excel file

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009. I have deployed my SSIS project & package in Azure sql…
Sharan G
  • 55
  • 7
0
votes
1 answer

How to activate ion toggle according to the id passed?

I have number of posts and I have to activate the toggle on view only those clicked by the user. But when the button of one post is clicked each posts' button is active although it does not get updated to the database.

…

Prinsha
  • 3
  • 2
0
votes
0 answers

Is there a deeper reason SSMS keeps connections open?

When you work on a SQL file in SSMS, then SSMS is opening a sql-connection, and during the time that you work on that SQL-file, no matter how many times you execute statements, it always uses the same connection - never closes it. Now I'm writing a…
Stefan Steiger
  • 78,642
  • 66
  • 377
  • 442
1 2 3
…
12 13