18,924 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
6 answers One of the answers was accepted by the question author.

Job 'IntegrityCheck' failed

Hello. I am doing log shipping transaction from one primary database to 2 different secondary databases. Then every morning I validate success by running the query (see attachment). My script checks that value of 'last_run_outcome' equal 1 I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,616 questions
asked 2020-12-25T23:57:46.807+00:00
Susja 716 Reputation points
accepted 2020-12-27T14:57:14.33+00:00
Susja 716 Reputation points
1 answer One of the answers was accepted by the question author.

How to Update status for pl data table when at lease one row part level = 1 for zplid ?

I work on sql server 2012 I have issue I need to update status for table pl data where i have at least partlevel=1 for every zplid ? meaning I need to update status for historypl table by message 'have Correct Flag' when it have only one row have…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,616 questions
asked 2020-12-26T19:26:19.187+00:00
ahmed salah 3,216 Reputation points
accepted 2020-12-26T19:39:15.117+00:00
ahmed salah 3,216 Reputation points
3 answers

how to put not in in xml while reading xml in sqlserver stored procedure

i have used to ands in flowing query for @id attribute , i want to use "not in" ? DECLARE @Data XML = N'<root> <column id="1" isok="true">OK</column> <column id="2"…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,616 questions
asked 2020-12-24T12:52:41.83+00:00
rajesh yadav 171 Reputation points
answered 2020-12-25T09:43:13.467+00:00
EchoLiu-MSFT 14,581 Reputation points
1 answer

SSIS Double Hop Issue

Hello I have a SQL Server A, SQL Server B and SQL Server C. SQL Server A holds a table. SQL Server B has a job to run an SSIS Package on SQL Server C. SPNs are active on all 3 instances. The SSIS Package on SQL Server C will extract data…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,557 questions
asked 2020-12-21T15:36:12.323+00:00
Sam Garth 26 Reputation points Microsoft Employee
commented 2020-12-25T08:32:37.083+00:00
Monalv-MSFT 5,896 Reputation points
7 answers One of the answers was accepted by the question author.

Encryption user error

I was trying one last test of Always Encrypted and this time I got the error "The reverse engineering operation cannot continue because you do not have View Definition permission on the database." This is my 2nd attempted test as the first…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-21T15:17:53.97+00:00
David Chase 681 Reputation points
accepted 2020-12-24T15:40:01.78+00:00
David Chase 681 Reputation points
3 answers

SQLBulkCopy JDBC intermittent getting connection reset by peer: socket write error

Hi all, I am using SQLBulkCopy class from MSSQL JDBC driver mssql-jdbc7.0.0.jre8 to perform synching of table from one database to another database; Some time i am getting exception "java.net.SocketException: Connection reset by peer: socket write…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-23T16:05:36.237+00:00
kluangguy 96 Reputation points
answered 2020-12-24T09:55:18.083+00:00
Erland Sommarskog 109.1K Reputation points MVP
2 answers

Conditionally formatting cells in SSRS with mixed data types in a sentence.

I am trying to achieve this: I have got two parts of it i.e Iff Z < 3 then " Orange " iff Z > 3 then "Green" iff Z <0 then "Red" <- To achieve. I have used iff, instr to see if it would work and color…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,903 questions
asked 2020-12-20T21:18:28.763+00:00
sidhartha bhatnagar 1 Reputation point
answered 2020-12-24T09:54:13.167+00:00
Joyzhao-MSFT 15,571 Reputation points
2 answers

SSRS Parameter for Two different columns

Hi, Is it possible to have a one dataset with one Parameter that fillers on two separate columns? For example. You have a table name staff with student ids in one column and employee id in another. And you want your user to be able to enter…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,903 questions
asked 2020-12-17T19:53:03.947+00:00
Kimmie25 121 Reputation points
answered 2020-12-24T09:53:08.977+00:00
Joyzhao-MSFT 15,571 Reputation points
2 answers One of the answers was accepted by the question author.

Actions in Analysis Services Tabular

One of the multidimensional feature not already available in tabular is the possibility to create actions. is there a roadmap about this feature?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
446 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,268 questions
asked 2020-12-22T09:27:47.07+00:00
Anonymous
accepted 2020-12-24T08:11:02.147+00:00
Anonymous
3 answers One of the answers was accepted by the question author.

How to get parts that not have same features count on table settings by code typeid and pl ?

I work on sql server 2012 . if face issue I can't get parts that not have all features on table settings so I will count distinct features from table settings and compare it with count features per part if count features per part on table part feature…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,616 questions
asked 2020-12-24T02:15:40.323+00:00
ahmed salah 3,216 Reputation points
commented 2020-12-24T07:53:04.843+00:00
EchoLiu-MSFT 14,581 Reputation points
2 answers One of the answers was accepted by the question author.

SSMS does not have access to sys schema for master database - error is mssqlresourceserver schema sys execute permission denied

After trying to get a user to be able to execute a view - providing SCHEMA permissions, providing extended stored procedure permissions (directly) to the extended stored procedure specified to the error - no satisfaction. Oddly though, if the user does…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-23T19:04:10.077+00:00
J Longstreet 41 Reputation points
accepted 2020-12-24T07:07:26.767+00:00
J Longstreet 41 Reputation points
2 answers One of the answers was accepted by the question author.

Alter Partition split going on hang stat when inserting large set of rows in table in sql server 2016

Hi , We are inserting 30 M records hourly in partition table(partition on Insert date) using Java ETL(Multiple threads). Simultaneously We are creating future partition(>30 Days) using alter partition split via Jobs in sql server daily basis(1…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-23T07:47:39.423+00:00
Dharmendra Panwar 20 Reputation points
accepted 2020-12-24T06:11:21.957+00:00
Dharmendra Panwar 20 Reputation points
1 answer One of the answers was accepted by the question author.

Microsoft.Data namespace missing dbGeometry

I am developing an application in WPF. Target framework: .Net Core 3.1, x86 platform. I have installed the Nuget Package: Microsoft.Data.SqlClient. My db is SqlExpress. I have a table with a sys.geometry type, (stores a coordinate pair, global…

Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,747 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-20T00:35:52.277+00:00
Allanjb 246 Reputation points
accepted 2020-12-24T04:11:35.21+00:00
Allanjb 246 Reputation points
1 answer

How to store and retrieve image using MVVM pattern in WPF C#

Please I am looking for a solid means to save and retrieve image to/fro SQL server database. I am using MVVM pattern in WPF. I have gone through everything I saw on Google concerning this issue, all I'm seeing is Image control being tied directly to code…

Windows Presentation Foundation
Windows Presentation Foundation
A part of the .NET Framework that provides a unified programming model for building line-of-business desktop applications on Windows.
2,747 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,779 questions
XAML
XAML
A language based on Extensible Markup Language (XML) that enables developers to specify a hierarchy of objects with a set of properties and logic.
800 questions
asked 2020-12-21T00:11:48.31+00:00
DPlug 41 Reputation points
commented 2020-12-24T03:10:12.177+00:00
DaisyTian-1203 11,621 Reputation points
2 answers One of the answers was accepted by the question author.

How to get zplid that have zfeature key value on all rows?

Exactly I need zplid and codetypeid that have feature value on all rows . if I have Null on zfeature key on one row then I don't Need it . I need to get zplid that have features Not Null on all rows as zplid 9714 but 9823,5890 have Null so I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,616 questions
asked 2020-12-19T20:35:16.097+00:00
ahmed salah 3,216 Reputation points
accepted 2020-12-24T01:40:00.97+00:00
ahmed salah 3,216 Reputation points
2 answers One of the answers was accepted by the question author.

Sql Server Data Tool installed in Sqlserver 2012

What versions of SQL Server datatools can I install on Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64) Aug 15 2017 10:23:29 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 <X64> (Build 9600: )…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-21T23:06:48.077+00:00
Avyayah 1,271 Reputation points
accepted 2020-12-23T17:44:44.313+00:00
Avyayah 1,271 Reputation points
2 answers One of the answers was accepted by the question author.

MDS 2017 derived hierarchy permission issue

Hello, for my MDS model I've setup User Group permission for derived hierarchy members. The type of groups are Active directory groups. This works fine for members of that active directory group when browsing the entity using the MDS…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-11T16:50:26.63+00:00
bvuHH 41 Reputation points
answered 2020-12-23T12:45:00.307+00:00
bvuHH 41 Reputation points
1 answer

SCCM 2006 Reporting Services Point on a separate server

Hi Fellow Engineers! I dislike the rabbit holes that Microsoft documentation puts you down to get a simple step by step guide on installation. I tip my "virtual" hat to those who make "how to guides" and I appreciate that. In…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,903 questions
asked 2020-12-22T22:48:17.273+00:00
Mike Plichta 1 Reputation point
answered 2020-12-23T10:55:32.777+00:00
Fiona Yan-MSFT 2,311 Reputation points
5 answers One of the answers was accepted by the question author.

Power User Access to Certain Views Only (sql14)

Good day, I was told to give a specific business user access to DW Tables (sql14), i would like to give read access to specefic views only. (Not Tables) Please Assist on how to go about it Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-21T12:53:13.897+00:00
IC IC 236 Reputation points
answered 2020-12-23T08:11:55.41+00:00
IC IC 236 Reputation points
2 answers

MSSQL 3241 HATASI ALIYORUM

TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ ADDITIONAL INFORMATION: The media…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,548 questions
asked 2020-12-19T13:04:24.773+00:00
EMRE KONYA 1 Reputation point
commented 2020-12-23T07:52:23.54+00:00
CathyJi-MSFT 21,621 Reputation points Microsoft Vendor