I made some progress.  New code:

ALTER procedure [dbo].[RunStoredProcedures]
as

BEGIN TRANSACTION

BEGIN TRY
truncate table dbo.testtable
select 1/0
END TRY

BEGIN CATCH
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION
RAISERROR('Rollback of stored procedures was successful', 10, 1) WITH...

what happens if you move that SP to another container, being executed after the other ones?

and most times its some settings on your sp's or locking between SP's -...

You can check the encryption status of your databases:

SELECT 
db.name AS database_name, 
db.is_encrypted, 
dm.encryption_state, 
dm.percent_complete, 
dm.key_algorithm, 
dm.key_length 
FROM 
sys.databases db 
LEFT OUTER JOIN 
sys.dm_database_encryption_keys dm 
ON...

Without further information, there is no way one can answer your question! 😎 1. Are you using any hard drive encryption? 2. Are you using TDE, transparent data encryption...

The query is this one:

INSERT INTO DBO.RunTimeSSIS
VALUES ('Start SSIS', getdate())

I ran this in SSMS to see if there are any issues.  No issues at all.  It ran...

..

Thank you so much!!

You need to physically move the files from the old drive to the new drive. SQL will not do this for you.

So when you have done the ALTER ......

Hi.  Is someone able to help me with this?  Thank you

..

• This reply was modified 8 months, 1 week ago by water490.
• This reply was modified 8 months, 1 week ago by water490.
• This reply was modified 8 months, 1 week ago by water490.

SELECT T1.UNIT,
       T1.DATE,
       CASE WHEN COUNT(T1.PRICE) OVER (PARTITION BY T1.UNIT ORDER BY T1.DATE ROWS...

  It works.  Thank you so...

1. I hope you are not using floats for prices! 2. Do you really use reserved names for columns? 3. Are you really writing new code with the depreciated...

Hi

Is anyone able to help me with this?

Thank you

Thank you for the prompt reply.