Viewing 15 posts - 16 through 30 (of 45 total)
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...
October 20, 2023 at 1:00 pm
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...
October 13, 2023 at 1:43 pm
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....
October 12, 2023 at 6:18 pm
replace the double quotes with single quotes
how did i missed that? lol
thanks so much!
July 23, 2023 at 1:43 pm
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...
May 30, 2023 at 3:04 pm
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...
May 25, 2023 at 5:52 pm
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),...
April 19, 2023 at 12:50 pm
thanks for suggestions @jeff Moden, @Jeffrey Williams. i'll take a look. am new to the whole DBA thing and learning as i go.
April 17, 2023 at 1:29 pm
instead of hitting F5 every 2-3 mins, can i automate this F5 to refresh the data within the same query result window?
I have to ask... why do...
April 15, 2023 at 11:18 am
would be nice for result of the loop will be in the same recordset grid, but doesn't appear so.
thanks everyone!
April 14, 2023 at 5:43 pm
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...
April 14, 2023 at 4:34 pm
i'm able to figure out. not sure how to delete this post
April 10, 2023 at 1:28 pm
Viewing 15 posts - 16 through 30 (of 45 total)