Stack Overflow
Stack Overflow

Questions tagged [sql-server-2022]

SQL Server 2022 is a release name of the Microsoft SQL Server 16.0 released on November 16, 2022. Use this tag only for questions about SQL Server 2022 specific questions. For generic questions about SQL, T-SQL, or Microsoft SQL Server, please use tags [sql], [tsql], and [sql-server] instead.

60 questions
21
votes
7 answers

"Edit Top 200 Rows" not working for SQL Server 16.0 - Express Edition

I am trying to "Edit top 200 rows" in SQL Server Express edition, but it's returning with the blank file as shown here: Showing blank file with disable tools I have installed this SQL Server on premise. I can select the data and update the data with…
Usman Javaid
  • 501
  • 3
  • 7
3
votes
1 answer

SQL Server Arithmetic overflow error converting negative numeric expression to data type NVARCHAR(MAX)

Using Microsoft SQL Server 2022 I have the following error when trying to convert a negative numeric value to a NVARCHAR(MAX) com.microsoft.sqlserver.jdbc.SQLServerException: An error occurred during the current command (Done status 0). Arithmetic…
Fabich
  • 2,768
  • 3
  • 30
  • 44
2
votes
1 answer

Entity Framework Core and column level SQL Server encryption with stored procedures, how to map properties the right way?

I have made work SQL Server encryption/decryption using stored procedures, symmetric keys using Entity Framework Core. I am able to save the object in the database, I pass the SSNumber parameter to the stored procedure, it encrypts it and stores it…
Alberto López
  • 246
  • 6
  • 22
2
votes
1 answer

Is case sensitivity broken in SSAS 2022 multidimensional?

I have an existing SSAS 2014 multidimensional project which uses a case sensitive SQL Server database as a source (Latin_1_General_CS_AS collation). The attributes in the SSAS project are also specified as case sensitive and it works just fine with…
Andrej Kuklin
  • 41
  • 4
2
votes
0 answers

SQL Server 2022 Contained Always On SQL Agent UI display issues for non sys admin roles

I've encountered another issue with SQL Server 2022 Contained Always On, so I wanted to inform the community. I have a lab set up within my environment, It is currently running SQL Server 2022 CU3 with a 4 node setup under Always On Contained…
Saruman
  • 21
  • 2
1
vote
2 answers

SQL Server query WHERE LIKE

I currently start learning SQL query in SQL Server 2022, I want to get productId and name with name prefix 'Chain'. I try this SQL: SELECT ProductID, Name FROM Production.Product WHERE Name LIKE 'Chain%'; And I get this result: ProductID …
Fergus Pham
  • 13
  • 2
1
vote
1 answer

Date logic (looking for first matching row in the past 90 days)

I have a table of "patient visits" where each row records a single patient-visit event. In simplified form, the table is like this: CREATE TABLE #MyVisits ( PatientID char(10) NOT NULL, --Alphanumeric Patient ID VisitID char(10) NOT NULL,…
Telescope2334
  • 177
  • 8
1
vote
1 answer

How do I solve this complex windowing query in SQL Server?

I have a flight database to track ultralight flights of various aircraft. The motors on these aircraft consist of parts which need replacing at a certain number of flying hours elapsed, which varies depending on the part. My database has the…
Mark Allison
  • 6,838
  • 33
  • 102
  • 151
1
vote
1 answer

Unable to login to SSRS Reports URL or ReportServer using a non-admin domain account

I have just setup SSRS 2022 on one of my servers with my admin account (domain\user.admin). My admin account has 'Administrator' login on the server where SSRS 2022 is installed. So when I first login using my admin account, I am able to login…
Nagarjun V K
  • 11
  • 5
1
vote
2 answers

How to write this windowing query in T-SQL?

I have some tables to store flying data: CREATE TABLE [dbo].[wings] ( [Id] [int] NOT NULL, [Manufacturer] [varchar](50) NOT NULL, [Model] [varchar](50) NULL, [Size] [decimal](3, 1) NULL, [hoursWhenBought] [tinyint] NULL, …
Mark Allison
  • 6,838
  • 33
  • 102
  • 151
1
vote
3 answers

How to match a CONCATENATED value to values in a temp table

The database I’m working with is SQL Server 2022. I have a table with item numbers like 1010080PC which ends with a C. I also have items like 1010080 or 1010080P (without the C at the end) and I want to add the item 1010080PC to the last column…
Peter
  • 13
  • 2
1
vote
1 answer

Client Protocols and Alias missing on sql native

No Client Protocols or Alias has anything under. Please see attached pic.
user21729897
  • 11
  • 2
1
vote
0 answers

MS SQL Server Login successfull sometime Working But sometime not working

I'm using pymssql to connect to MS SQL Server Database Instance. But Don't know why It's acting strange sometime I'm able to login and execute query and sometime It won't login. Tried to debug below code but honestly I don't have enough knowledge…
K M Jiaul Islam Jibon
  • 218
  • 3
  • 10
1
vote
1 answer

CETAS in SQL Server 2022

I have followed the below steps in SQL Server 2022: Step 1: Create a master key Step 2: CREATE DATABASE SCOPED CREDENTIAL [BlobSAS] WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = '?sv=2021-06-08&ss=bfqt&srt=c<<>>'; Step 3: CREATE…
Nandan
  • 3,939
  • 2
  • 8
  • 21
0
votes
1 answer

Attempt to disable MS SQL Server 2022 audit for capturing events of changes in access permission takes forever

I am trying to delete server audit which was capturing logon events defined in server audit specification as follows: CREATE SERVER AUDIT SPECIFICATION [System Login Audit] FOR SERVER AUDIT [System Logins] ADD…
Alex Zhyk
  • 11
  • 3
1
2 3 4