Thanks a million for differing me to the old thread. I got the answer from there .

WITH Matt_RemoveDuplicateServers AS

(

select

ROW_NUMBER()...

I want remove all the duplicate entries of Ser.Servername and keep only unique values of Ser.Servername. I attached the Desired_Result_Set

It does not matter what values come up in other columns...

Thanks for the response Eirikur Eiriksson. I'll use your idea here. I think i'll just do a BIGINT as datatype and covert the duration to seconds while i'm pumping it...

figured it out.

BULK INSERT SQLOPSDB.DBO.SDAdminStatus

FROM 'S:\sdtemp\SDAdminsStatus_History.txt'

WITH ( FIELDTERMINATOR=',', ROWTERMINATOR = '', KEEPNULLS, TABLOCK ,FIRSTROW = 2)

GO

I got it working. we can archive this thread. Thanks a lot

foreach ($line in $ReturnString)

{

$array = @()

if ($line -notmatch "ID, Active,...

I'd want the data to be read in below example command.

Get-Data | select ID, Active, User,Client,Machine, StartTime, Duration, KernelTime, UserTime

Hello Shawn,

can you please help me figure out the answer to disable NIC using "-args"

$NICName = 'Trunk1'

Invoke-Command -Computer MyRemoteServer { Disable-NetAdapter -Name $NICName -Confirm:$false } -Args $nic

I thought of creating SQL Agent Jobs OR Scheduled Tasks and keeping them in disabled mode and call them on demand as you suggested. I have atleast 40 Powershell scripts...

I have a series of powershell scripts that i need to call on a server before I enable and start Windows Update service on a production server.Once the server is...

PS C:\Windows\System32\WindowsPowerShell\v1.0> $upd = new-object -com Microsoft.Update.Session "MyServerName"

$searcher = $upd.CreateUpdateSearcher()

$searcher

New-Object : A positional parameter cannot be found that accepts argument 'MyServerName'.

At line:1 char:8

+ $upd = new-object -com Microsoft.Update.Session "MyServerName"

+ ...

Really sorry for the churn. I found the double quotes to be the culprit in my command.

Failing Command

EXEC xp_cmdshell 'powershell -Command "MyServerName" | D:\Temp\StopSDOpsService.ps1'

Working Fine:

EXEC xp_cmdshell 'powershell -Command D:\Temp\StopSDOpsService.ps1 MyServerName'

Hello Shawn. Please don't ming but can you give me exact commands to get the results? I'm getting errors when i run below command.

$upd = new-object -com Microsoft.Update.Session "MyComputer"

$searcher =...

I might be the dummest person and i'm sure it might wront to recycle NICs one at a time at 15 hour interval. I'm seeing that IPV6 is slowing down...