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…
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…
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"…
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/c4mRkDtLdU6n6fSv2i9uBg.png?8D843C)
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…
![](https://techprofile.blob.core.windows.net/images/EqrQxhN70Uib8KRAQTM31A.png?8D9A5B)
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…
![](https://techprofile.blob.core.windows.net/images/EqrQxhN70Uib8KRAQTM31A.png?8D9A5B)
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?
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…
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…
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/NhkrylFCqEiUzgd3au5ONw.png?8D7FAD)
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 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: )…
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…
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…
![](https://techprofile.blob.core.windows.net/images/dL8OFcW3VU2svHJiz9JB8g.png?8D8431)
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
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…
![](https://techprofile.blob.core.windows.net/images/ctcyKX4BnU-r4fRclNq-Ww.png?8D9AB2)