You can...

• This reply was modified 1 years, 7 months ago by Ken McKelvey.

Scripts that give index reccomendations are often a good starting point but you need to understand what is going on behind the scenes. I generally deal with OLTP dbs so...

The following will reset the Total variables on the code boundary:

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

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 1 years, 9 months ago by Ken McKelvey.