Viewing 15 posts - 61 through 75 (of 327 total)
Control Panel --> Add Remove Programs should have the date the SP was installed.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
December 9, 2010 at 6:41 am
thank you. I'll follow up on that
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 8, 2010 at 4:49 pm
Along a similar vein, is it possible to clear the plan for a single stored procedure without using sp_recompile or with recompile?
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
November 8, 2010 at 2:06 pm
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 30, 2010 at 1:28 pm
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 30, 2010 at 12:37 pm
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/
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 10, 2010 at 8:04 am
You might try this
EXEC xp_cmdshell 'powershell.exe %Deployment_root%apps\Systems\sql\DR\ScriptSQLServerObjects.ps1 "gssqlbackup"'; exit $LASTEXITCODE
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 10, 2010 at 7:21 am
channge this
$dbs | select * | Export-Csv -path "D:\PS\dbdetails.csv"
to
$dbs.ExtendedProperties | select Name, Value | Export-Csv -path "D:\PS\dbdetails.csv"
and see if that helps
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 3, 2010 at 9:17 am
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 3, 2010 at 8:51 am
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
September 3, 2010 at 8:39 am
BIG1362000 (7/9/2010)
Hi,I tried it on several 2005 databases. All of them returned 0 rows.
Is it normal ?
Thanks.
In the script, I exclude port 1433 (WHERE c.local_tcp_port <> 1433) which is the...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 9, 2010 at 5:57 am
Twinsoft SME (7/7/2010)
SQL Server should only be using 1 open port? :w00t:
Actually - Microsoft recommends multiple ports to help balance the "listening" load on busy servers.
From http://support.microsoft.com/kb/294453 -...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 8, 2010 at 6:37 am
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...
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 7, 2010 at 6:57 am
Thanks - I'll get it out to you in couple of days.
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2010 at 3:02 pm
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....
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
June 9, 2010 at 2:56 pm
Viewing 15 posts - 61 through 75 (of 327 total)