yes

i have a witness server to keep an eye on my principle and mirror

and principle is forming a quoram

thats why when i perform select * from sys.database_mirroring

on principle...

yes thats what i m assuming that connection issues might cause these things to arise..

but still looking for some perfect answer

hmmm... as i told u... i can see the status sometimes as

(Mirror,Synchronized/Restoring...)

so looks like it fixes by itself only..... strange...

yes sometimes its in 'restoring' mode

and sometimes it says mirrored,synchronized,restoring

but my principle is always up and running so we dont know

weather its any warning or is it bad if...

I observed these in mirroring monitor after few minutes

under db monitoring i can see principle = connected and mirror = not connected

some times it shows connected as well

n we...

ok just do this on sql 2000 query analyzer

select * from syscomments

are u able to read column ctext?? i know its an actual defination

but can u read that??

i wan to...

column text is not giving the complete defination.. it has datatype of nvarchar(4000)

wht if my SP is longer than this?? when i select it from text.. its not complete defination

thats...

let me put it this way..

i need to decode ctext column from syscomments table

its not in readable form

any suggestions for this??

i cant find in book online..

Thanks i got it...

Thanks i got it...

no i m not on sp-4 but 8.0.760 and we dont want to apply sp-4 due to certain reasons

SQL Agent-Generic Refresher is executing this

EXECUTE msdb.dbo.sp_help_alert @alert_id = 14(14= no of...

Yeah David,

I can see there is a database named QuestWorkdatabase. And we are using some Quest software as a third party tool for monitoring.So This...

actually its very simple... got it man...anyway thanks

hey Thanks again winash

actually the thing is i can use file system task but i need 2 use it 2 times

first for copying file and second time for renaming the...

hi Winash

thanks i tried sql and xp_cmdshell method but i was stuck in syntax inside REN

but u have corrected it...