The agent log posted above mentioned about [BizTalkMgmtDb], but the commandlog below is showing another database.

This is from the commandlog for this date:

ALTER_INDEX

1205

Transaction (Process ID 97) was deadlocked on lock...

I also  noticed the package when i execute from the agent errors out around 46 seconds.  the normal execution time completion is 177 seconds.  what could it be?

is there another...

• This reply was modified 1 year, 2 months ago by  lan2022nguyen.

sorry, i meant to edit the original post, but was interrupted.

Message

Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 15.0.4322.2 for 64-bit Copyright (C) 2019 Microsoft....

thanks so much, johan

thank you @johan

how did i missed that? lol

thanks so much!

The Index Allocation Map (IAM) page (0:0) is pointed to by the previous pointer of IAM page (3:17) in object ID 0, index ID -1, partition ID 0, alloc...

if i run repair_allow_data_loss, how do i actually determined if there is actually data loss?

do i just take a record count for all table in the database before and compare...

some of those variables need to be explicitly converted to varchar -  example below for @@SPID

INSERT INTO Logs.dbo.LogonInfo (Spid, UserName, LogonDate, ClientNetAddress, HostName) 
VALUES (convert(varchar(200), @@SPID),...

thanks for suggestions @jeff Moden, @Jeffrey Williams.  i'll take a look.  am new to the whole DBA thing and learning as i go.

I have to ask......

I have to ask... why do...

would be nice for result of the loop will be in the same recordset grid, but doesn't appear so.

thanks everyone!

something like this:

waitfor delay '00:00:03' --pause for 3 seconds

GO 3 -- run 3 times

this will result in 3 separate result pane.  i'd like to keep it in the same pane...

i'm able to figure out.  not sure how to delete this post