Viewing 3 posts - 1 through 3 (of 3 total)
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...
September 9, 2009 at 11:38 pm
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...
September 9, 2009 at 11:36 pm
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...
February 7, 2008 at 11:33 pm
Viewing 3 posts - 1 through 3 (of 3 total)