Forum Replies Created

Viewing 3 posts - 1 through 3 (of 3 total)

  • RE: Creating script to setup Warning Thresholds for all Mirrored DB's

    Try this 🙂

    declare @sql nvarchar(4000)

    declare @dbname varchar(100)

    declare @db_id int

    declare db_cursor cursor forward_only for

    select db_name(database_id) from sys.database_mirroring

    where mirroring_role = 1

    open db_cursor

    fetch next from db_cursor into @dbname

    while @@FETCH_STATUS = 0

    begin

    set @sql...

  • RE: Creating script to setup Warning Thresholds for all Mirrored DB's

    Try this 🙂

    declare @sql nvarchar(4000)

    declare @dbname varchar(100)

    declare @db_id int

    declare db_cursor cursor forward_only for

    select db_name(database_id) from sys.database_mirroring

    where mirroring_role = 1

    open db_cursor

    fetch next from db_cursor into @dbname

    while @@FETCH_STATUS = 0

    begin

    set @sql...

  • RE: SLOT 1 for text, ntext, or image node does not exist

    I have the same problem in sql2000?

    Page (1:928392), slot 9 for text, ntext, or image node does not exist

    when I run the command

    dbcc traceon(3604)

    dbcc page ('databasename', 1,928392 , 3)

    it show...

Viewing 3 posts - 1 through 3 (of 3 total)