Thanks Steve for the nice question..as usual.

I explored more on the cause.

•You must remember to terminate the statement preceding the CTE with a semicolon, otherwise SQL will throw this error...

Sure Guys, I will reply tomorrow. My scripts are there in my other laptop.

I have managed to fix this.

Thanks Gary.

I am learning Powershell and trying to automate few of the stuff. Hence, needed expert advice.

**** This one I re-modified. *****

clear-host

$instance =""

function checkserver

{

$instance= Read-Host "Enter the SQL Service Instance...

My revised script.

clear-host

function checkserver

{

[CmdletBinding()]

Param

(

[Parameter(Position=0,Mandatory=$true)][string]$instance

...

Nice straight fwd question. I scored 1 mark.

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

HI Gary

Please check my modified script using functions.

cls

function AcceptedFeatures()

{

$ACTION = Get-Content "C:\test\SQLServer2012ConfigurationFile_Install.ini" | Where-Object {$_ -match 'ACTION='}

$pos = $ACTION.IndexOf("=")

#$leftPart = $SQLSVCACCOUNT.Substring(0, $pos)

$rightPart = $ACTION.Substring($pos+1)

$ACTION = $rightPart -replace '"',...

Hi Gary

Does this Out-gridview page offer any OK button to close the screen?

Thanks

Sourav

Many thanks, Gary!

It works. 🙂

Thanks Gary and Eri for your help.

The problem now is, if I run the small script, I get the o/p as:

Password is: System.Security.SecureString

Is there anyways, I can ask user...

Further modified. Please check that in your place and let me know how does it look now. 🙂

********************************************************************************

clear

function getPATH {

Param ([string]$name=(Read-Host "Enter Instancename"))

$length = $name;

IF (!$length)

{

write-host...

This is my more refined script, "Gaz" Sir..

$INSTALLSHAREDDIR = Get-Content "C:\test\Install_ConfigurationFile.ini" | Where-Object {$_ -match 'INSTALLSHAREDDIR='}

$pos = $INSTALLSHAREDDIR.IndexOf("=")

$leftPart = $INSTALLSHAREDDIR.Substring(0, $pos)

$rightPart = $INSTALLSHAREDDIR.Substring($pos+1)

#$leftPart

$rightPart = $rightPart -replace '"', ""

$rightPart

$rightPart...

Thanks GAry for the help.

Somehow, your script is throwing an error.

Msg:

The string is missing the terminator: '.

+ CategoryInfo ...

Hello,

Whenever I am running my script, getting the below error as in my conf.INI file I already has the value ACTION and INSTANCENAME.

function InstallSQL

{

[CmdletBinding()]

...