The following Quirky Update solution seems to work with the data provided:

SELECT ISNULL(CODE, '') AS CODE, ISNULL(ID, 0) AS ID, TIP, AMOUNT, PRICE
    ,PRICE...

    IF @TIP = 'IN'
    BEGIN
        SET @TOTALAMOUNT = @TOTALAMOUNT + @AMOUNT;
 ...

The first thing I would check is the amount of disk space available.

Also, I would rarely use RESTORE...WITH REPLACE. I would normally restore to something like MyDb202405301201 and then use...

ps. You might also want to look at a wire proxy like Gallium Data. It might be possible to put the database on a supported version of SQL Server and...

It looks as thought you are trying to establish a secure connection. If using SQL Server authentication, this might just be to send the...

As PowerShell can have problems with UNC paths try something like:

New-PSDrive -Name "TxtFiles" -PSProvider "FileSystem" -Root "\\John\Data" | Out-Null
$Files = Get-ChildItem TxtFiles:\test\*.txt
Foreach ($File in $Files) {
 ...

Thanks for the information although I do not understand the process. I will try and look at it sometime. The sessions I am actually interested in only last a second...

I could not find anything so I just went with a logon trigger.

What is the result of the following:

SELECT servicename, service_account
FROM sys.dm_server_services;

Does your SQL Server service account have read permissions on the share?

Using a function on a column generally stops it being SARGABLE. (ie It will not be able to use any indexes.)

You should use:

AND CDHDR_NEW.OBJECTID LIKE...

Using a function on a column generally stops it being SARGABLE. (ie It will not be able to use any indexes.)

You should use:

AND CDHDR_NEW.OBJECTID LIKE MM_EKKO_STAGING.EBELN +...

• This reply was modified 7 months, 2 weeks ago by  Ken McKelvey.

If you are looking at Blob Storage you might also like to consider Object Drift and Corruption. We were looking at something similar last year but it got abandoned for...

• This reply was modified 7 months, 2 weeks ago by  Ken McKelvey.

Probably because the Agent...

Try a space, not a -, between dd and hh.