I just had another thought, Also in the SQL Configuration Manager  you'll need to change the IPAll and make sure it is not using a dynamic port, and is listening...

by default, SQL Express has tcp disabled, and you have to explicitly enable that in the SQL Configuration Manager, did you do that yet? that's a difference between what we...

• This reply was modified 3 days, 9 hours ago by Lowell.

also note that if a long statement is in use, like WITH MyCTE..... or a cursor, the error returns the first line of the statement, and not the in between...

to me  it looks like a group by query will satisfy it.

SYMBOL TRADE_DATE Maxt1Level Mint2Level TheLevel

abc 2025-10-20 2.00000 2.50000 2.00000

and my query:

SELECT

t1.[SYMBOL],

t1.[TRADE_DATE],

MAX(t1.[LEVEL]) AS Maxt1Level,

MIN(t2.[LEVEL]) As Mint2Level,

ISNULL(MAX(t1.[LEVEL]), MIN(t2.[LEVEL])) AS TheLevel

FROM #nr_data...

I don't see any web site at myblueguru.com.

i think you might be running the command in an application other than SSMS/sqlcmd or a Sql agent job, right?  a python/PowerShell/dotnet command could potentially create a sql command object...

you can backup and restore, too and from an S3 bucket, will that help?

you need to set up a few things in rds first, and make sure of permissions on...

i suspect you are missing part of a join statement, or have an incorrect logic in your trigger...like joining on parentId, but not ChildId. can you show the definition of...

it's the service account that is running the SSRS Service that needs access.

You'll need to modify the Reporting Services Configuration Manager Subscription settings.

if the path is a unc path ,...

just suggesting to check the basics...database mail has a dependency on dotnet 3.5, which is not installed in an operating system by default, and is easy to mis-remember the dependency....

i think you may have toggled mixed mode authentication, but that setting requires a stop and start of the SQL service, as it is only loaded at that time.

it will...

well dang. i found that SSC is scrubbing my posts if i paste the commands i previously used  in linux.

i had a script in python that worked everywhere in windows,...

so deadlock information is capture int eh system health extended event, in the stack of files it saves.

here's a really good stack of queries i put together and use on...

here's an example i use pretty frequently. it's a stored procedure, that is calling Adam Machanic's sp_whoisactive.

if there are no long running transactions, It bails out gracefully, but if something...

so as Johan mentioned, linked servers leverage tempdb. so if you are adding a WHERE or an ORDER BY, or joining it to your local data, the whole table goes...