[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference decwet::winnt-clusters

Title:	WinNT-Clusters
Notice:	Info directories moved to DECWET::SHARE1$:[NT_CLSTR]
Moderator:	DECWET::CAPPELLOF

Created:	Thu Oct 19 1995
Last Modified:	Fri Jun 06 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	863
Total number of notes:	3478

766.0. "Unsuspecting a DB" by ALFAM7::SIEBOLD (Thomas, TSO Munich - ALPHAholics can not be VAXinated!) Thu Apr 24 1997 06:03

In the SQL online there are several things you have to do to unsuspect a SQl DB.

When you look at the cluster trace lock, the FMSQL seems to do something
similar when it says 'cleaning SQL databases'.

Is there a stored procedure available like SP_CLEAN that I can use to not have
to type in everything in the online books? If we do not put this into SQL (do
we?) can the code for the SP be published here? This would be a nice support
tool. [sorry but my fingers are lazy  :-) ]

thomas

T.R Title User Personal
Name Date Lines

766.1 CSC32::HOEPNER A closed mouth gathers no feet Thu Apr 24 1997 15:41 9

T.R	Title	User	Personal Name	Date	Lines
766.1		CSC32::HOEPNER	A closed mouth gathers no feet	`Thu Apr 24 1997 15:41`	9
	I use the sp_resetstatus from the Online books. I have it in a sql file with all the params. I like to have to do things a little manually when it comes to unsuspecting a database since we can really trash things if we unsuspect something that is truly suspect.

    
    I use the sp_resetstatus from the Online books.  I have it in a
    sql file with all the params. 
    
    I like to have to do things a little manually when it comes to 
    unsuspecting a database since we can really trash things if we 
    unsuspect something that is truly suspect.