Sorry Server crash NOT DB crash

I have mentioned before that we faced before a server crash and a DB crash, upon this crash SQL server wasn't able to work properly, and at this level I...

After the server crashed I wasn't not able to view the Replication monitor anymore ,even the jobs related to replication (distributor ,publisher, log reader and snapshots) were all removed.

over enterprise manager it is not appearing at all under Replication Group monitor and if I tried to run it from main path C:\Program Files \......\tools a cmd window pops...

Hi,

Thanks for your reply..

Regarding recovery model it is already set to Simple, and concerning open transactions I have tried to monitor them before using the dbcc opentran('tempdb') and nothing was...

Thanks for your reply..

I searched syscomments in my database for text having pattern %sp_dboption% or %single_user% to know if there is any comment related to such point but nothing is returned. Actually i...

Thanks for your reply, I know it is not logical to create such view . Actually databases we created in inconsistent way . There supposed to be centralized database that...