Control Panel --> Add Remove Programs should have the date the SP was installed.

thank you. I'll follow up on that

Along a similar vein, is it possible to clear the plan for a single stored procedure without using sp_recompile or with recompile?

Okay - it works with:

$Scripter.Options.ScriptBatchTerminator=$true

$Scripter.Options.NoCommandTerminator=$false

$Scripter.Options.FileName = <Filepath and name or variable with that>

$Scripter.Options.ToFileOnly=$true

$Scripter.Options.AppendToFile=$true

The caveat though, is that there are objects that don't have a script method so it either becomes...

I spent 2 days trying to find out what ScriptBatchTerminator wasn't working. There are any number of forums that have that question and not one had an answer:angry:

I completely missed...

I second your caveat :-D:-D

Here is a link to a pretty good explanation of error handling for PoSh:

http://huddledmasses.org/trap-exception-in-powershell/

You might try this

EXEC xp_cmdshell 'powershell.exe %Deployment_root%apps\Systems\sql\DR\ScriptSQLServerObjects.ps1 "gssqlbackup"'; exit $LASTEXITCODE

channge this

to

$dbs.ExtendedProperties | select Name, Value | Export-Csv -path "D:\PS\dbdetails.csv"

and see if that helps

WMF - Windows Management Framework - includes Powershell V2.0, Windows Remote (WinRM) and WPF. Enable WinRM on the servers you will be working with and you can start remote session...

I have the SQL 2008 client loaded so this is a simple method using SQLPS but it is the basis of what I use:

cd 'SQLSERVER:\sqlregistration\Database Engine Server Group'

new-item ServerGroupA #tcreate...

In the script, I exclude port 1433 (WHERE c.local_tcp_port <> 1433) which is the...

Actually - Microsoft recommends multiple ports to help balance the "listening" load on busy servers.

From

fluppe_be,

sp_who in SQL 2008 uses a system view in the resource database so I think you will need to write your own version of sp_who or search for one that...

Thanks - I'll get it out to you in couple of days.

I'd be happy to try to put something together for the site. I've wanted to contribute something other than in the forums for a while but I'm a terrible writer....