336,861 questions
-2
votes
1
answer
37
views
SQL Server connection string Issue with optional encryption [closed]
I had been using a connection string with my application and it had been working without any issue. Username and passwords have not changed but when I run the code, I get this error:
The server ...
0
votes
1
answer
37
views
Gaps and Islands Getting Last Island Window
I have a table with status changes that I want to chunk into islands and eventually get my most current island based on when my status changed. I'm using this query to retrieve the current, previous ...
- 470
0
votes
0
answers
33
views
SQL SSRS ReportServer db DROP/Create Objects
I've enable DDL audits on few of our servers. The past two months I've seen a weird behavior on a server where we host our reportserver database.
I'm seeing lots of drop procedures/view followed by ...
- 39
1
vote
1
answer
91
views
SQL Server not selecting all records
I am running into an issue I have not seen before. I have a table in one of my SQL Server databases that when I run just a basic SELECT * query against it, it returns 15,114 rows.
However, when I look ...
0
votes
0
answers
39
views
Error 300 VIEW SERVER STATE permission when trying to disable CDC as the SA
Having an issue with the CDC process. I'm trying to add a column to a CDC table and the first step is to disable the current CDC table. I can't get past this step even though I'm logged in as 'sa'. ...
- 83
0
votes
0
answers
38
views
The module being executed is not trusted - for procedure "with execute as" clause
I have a stored procedure in a database OmegaCoreAudit that queries the master.sys.fn_get_audit_file records and stores them to a table in the same database.
The owner of this database is login ...
- 369
-1
votes
0
answers
38
views
Why am I receiving this empty xmlns? [duplicate]
I'm switching over a BizTalk port from adapter 'SQL' to 'WCF-SQL' due to the former being removed from the next version of BizTalk, I can receive the message from the stored procedure fine, except for ...
- 15
2
votes
0
answers
42
views
Schema::hasColumn() returns false for existing SQL table columns using Laravel and external database connection
I'm working on a Laravel 12 project that connects to a Microsoft Dynamics CRM SQL Server database through a custom connection. I've run into a puzzling issue: Laravel's Schema::hasColumn() returns ...
- 377
0
votes
0
answers
43
views
"The connection is no longer usable because" sql server connection issue using python and sqlalchemy [closed]
Error code: "Exception: (pyodbc.OperationalError) ('08S01', '[08S01]"
Error message: "Very frequently i am facing this error. the connection get established i run multiple times after ...
-1
votes
0
answers
33
views
Is there a specific SSRS expression to compare columns? [closed]
I have a report in SSRS with 12 columns, and all the columns have different values. I need to write an expression to compare either columns and populate a percentage based on parameter selection. ...
- 1
0
votes
2
answers
51
views
Organizing data into hierarchical structure with SQL Server
I have a SQL query that I used with SSRS for creating a hierarchical employee report. SSRS had the ability to have recursive parent groupings, which explains the following table structure of the data.
...
- 557
1
vote
1
answer
69
views
Fetching 1 row of main table with diverse max()s, min()s, and same-row-as-the-min() values from related tables
table1
tasknum
description
refid
sysdesc
table2
tasknum
stepno
stepdetail
approvaldate
table3
id
startdate
enddate
SELECT
t1.tasknum
, t1.description
, t1.refid
, t1.sysdesc
, t2.stepno
, t2....
- 11
-4
votes
1
answer
88
views
Find combination from one table in rows in a different table [closed]
I am building a database to analyze bowling results and bowler performance. I need to find how many times certain pin combinations were hit when a bowler threw the ball the first time. I have one ...
0
votes
0
answers
34
views
PowerApps Pull one to many values by individual entry
I'm using PowerApps with a SQL Server database right now, and I have an Events and an Event_Categories tables. Events has a one-to-many relationship with Event_Categories. Event_ID is the PK for ...
0
votes
1
answer
65
views
What are DATEFIRST's default values for non-US English languages in SQL Server?
SQL Server has a DATEFIRST setting that determines the first day of the week for date calculations.
SELECT DATENAME(weekday, '2025-04-23') AS WeekdayName -- Wednesday
SET DATEFIRST 7 -- Sunday
...
- 27.1k