Dear Ed & Gila,

You both are right. Thanks.

I was asked to put up the msg. So I used.

I run dbcc daily in the envitonment through my own script

Cheers.

many thanks. After your post I recalled that db_name(), db_id(), @@servername are all can be used / concatenated easily.

Hi Guys

I modified my approach oif reporting other than Online DBs as below:-

Please suggest if you have any advise.

DECLARE @DBSTATUS TABLE

(

DBNAME...

Thanks Luis and Lowell, it worked.

Hi ED - I initially started with that, but later changed the plan and now I am after checking the Db's which are Online/Suspect ,...

Thanks.

But I planned to execute the dbcc checkdb with my own customized way only.

Did not understand your question. Can you be more explicit in your qustion??

Thanks Steve for the question. I scored 1 mark.

But, one question, does this option has any real significance? Can you please suggest in which circumstances DBA should look for enforcing...

Bad day for me. I lost 7 points. I selected option - (c). 🙁 🙁

I think the reference link which you posted is not appropriate.

USe this:

https://technet.microsoft.com/en-us/library/ms175477(v=sql.110).aspx

You can save credential using /savecred switch.

To get the list of switches which runas offer, you can look at the help.

Hi Lowell

Did not understand what you are trying to say. I dont want to pass any parameters to my function "AcceptedFeatures". It's supposed to generate the values of the parameters:...

Before the syntax :-

$serverObject = New-Object Microsoft.SqlServer.Management.Smo.Server($instance)

You can add including the below syntax to load the SMO component DLL.

Add-Type -Path "C:\Program Files\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.Smo.dll"

Hi Jeff

I used the generate password code accordingly:

clear-host

Function GET-Temppassword1() {

Param(

[int]$length=10,

[string[]]$sourcedata

)

#$alphabet="YYETHOGD5546*&6%$3#@%L";

$ascii=$NULL;For ($a=33;$a –le 126;$a++) {$ascii+=,[char][byte]$a }

For ($loop=1; $loop –le $length; $loop++) {

...

Why are we concerned about checking Lock Pages in Memory? Does that help us doing better in DBA activities anymore?

I don't think turning off "xp_cmdshell" is anyways a good idea, as without that we can't even run batch commands from sql.