Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Find Blocked SQL and Blocked By Information.

    Please find updated script for SQL Server 2005\2008

    declare @spid int

    declare @blocked int

    declare @db_name varchar(500)

    declare @program_name varchar(1000)

    declare @loginame varchar(500)

    declare @login_time datetime

    declare @last_batch datetime

    declare @str varchar(100)

    declare @runtimeinmin int

    declare @min-2 int

    set @min-2 =...

Viewing post 1 (of 2 total)