----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: MMG109 Message 2 in Discussion Hi. Thanks for your tip Regards M.M.Ganesh >From: "Star_Venkat" <[EMAIL PROTECTED]> >Reply-To: "MumbaiUserGroup" <[email protected]> >To: "MumbaiUserGroup" <[email protected]> >Subject: SQL Server - Tip of the day >Date: Mon, 8 Oct 2007 00:55:58 -0700 > > > > > > > > > > > > > > New Message on MumbaiUserGroup > > > > > > > > SQL Server - Tip of the day > > > > > Reply > > > > > > Reply to Sender > Recommend > > Message 1 in Discussion > > > > > > > > From: > Star_Venkat > > > > > DBCC Help statement: > "DBCC help" provides help for all DBCC related statements. It provide us >the syntax for the particular dbcc command which you are passing as >parameter >in the statement. >Syntax: > DBCC help('PROCCACHE') -- I need help about the syntax for this DBCC >command. >We can pass the dbcc command as the parameter too, > DECLARE @stmt sysname SET @stmt = 'CHECKDB' DBCC HELP (@stmt) GO >Microsoft is providing another option like, details about various DBCC >commands to which help is provided. >The syntax is > DBCC help('?') >The above query will update you details about the available dbcc commands >in your server. >Note: You should have admin rights to execute this DBCC help command else >an exception will be thrown lik "User 'guest' does not have permission to >run DBCC HELP." Regards, >Venkatesan Prabu. J > > > > > > > > View other groups in this category. > > > > > > > > > > > > > > > > > To stop getting this e-mail, or change how often it >arrives, go to your E-mail Settings. > > > Need help? If you've forgotten your password, > please go >to Passport Member Services. > > For other questions or feedback, go to our > Contact Us >page. > > > If you do not want to receive future e-mail > from this >MSN group, or if you received this message by mistake, please click the >"Remove" link below. On the pre-addressed e-mail message that opens, simply >click "Send". Your e-mail address will be deleted from this group's mailing >list. > > > Remove my e-mail address from MumbaiUserGroup. > > > > > > > _________________________________________________________________ Post free property ads on Yello Classifieds now! www.yello.in http://ss1.richmedia.in/recurl.asp?pid=220 ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/MumbaiUserGroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
