Hi GAz

Did you get a chance to look for my code?

I modified it further but the two key values are not being passed proper thru function parameters. Plz suggest.

Function ...

Hi Gaz...Thanx for the response. YEs, I want an Install and Uninstall functions which can be easily be used to do SQL Server 2008/R2 and 2012 Install and Uninstall using...

Need the same with Powershell

Hi Steve

Sorry, if I am confused, but the below link says:

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

SQL Server Express supports FILESTREAM. The 10-GB database size limit does not include the FILESTREAM data container.

So I selected option...

In the correct answer choice section, it should have "Clustered columnstore indexes were not available until SQL Server 2014" also as an additional choice apart of the 2 mentioned, I...

Still, no luck

Setup.exe /qs /Action=Patch /InstanceName="INST4" /UpdateSource="C:\SQL Server 2012 Service Packs\SP2\64-SP2-extract\" /IAcceptSQLServerLicenseTerms /UpdateEnabled= true /IndicateProgress >> log-sql2012-sp2.txt

Error:

Overall summary:

Final result: ...

I've written the below script but not able to append the hostname to the output file.

@echo off

@break off

@title Create folder with batch but only if it doesn't already exist

@color 0a

@cls

cd...

Thanks for your response.

My query is:

$instanceNameList = Get-Content "C:\Powershell\serverlist.txt"

$results = @()

foreach($instanceName in $instanceNameList)

{

$results += Invoke-Sqlcmd `

...

I found the question to be little confusing as it asked to know if temp tables were created. Could have been slightly different. However I hot the right options.

One more thing...

If there is any login account but if that does not have any permission associated to it, the report does not pull out the report. It would have...

Option F ia good. Not sure how Mr Author is coming to option D...To my understanding neither C nor d is correct. Only one which comes to a good answer...

Scored 1 point. Thanks for the quick brain teaser, Steve!

Same error while I tried using SQL Management Studio too.

Nice Cute question. Scored 2 marks.

Fairly simple one. I got it right. Thanks Steve for the quick question.