It is still failing with same error Cannot validate argument on parameter 'Name'. The argument is null. Provide a valid value for the argument, and then try running the command...

Yes. I'd like to disable Windows Update Service using Powershell in SQL. If this succeeds, i have whole bunch of SQL jobs to schedule which would get kicked off only...

In this case how can i proceed. My requirement is below.

I'd like to stop and disable wuauserv service on servers which will be passed by a .txt file.

set-service wuauserv...

the powershell script is already writing the output to a .txt file. below is the script I'm trying to run.

BEGIN

{

Clear

}

PROCESS

{

$server =...

I put the below command as a job step and made the step type as powershell.

Get-Content D:\Temp\ServerList.txt | D:\Temp\StopDisableWindowsUpdateService.ps1

Below is the Error I got.

Executed as user: REDMOND\bgitsdsv. A job...

Wow !! thanks for the tip. works like charm. thanks a milion.

Thanks a lot Shwan. this little command works like charm. One last think. how can i delete files remotely in the same remote directory path?

I created a job with a step which has OperatingSystem(CMDEXEC) and run as DOMAIN\MYACCOUNT.

SQLCMD -q "SQLOPSDB.DBO.sp_now"

But now the job is not finishing as the above command does not...

When i scripted out the Partition function the rage values were in those weird format.

Thanks for the tip I was able to create Partition Function using the format.

Thanks Lynn. I've created partitions to the table table in the way i wanted. I've create hourly partitions on the table. Now I'm thinking to use switch partition to move...

Point taken. My plan is to drop all the Non Clustered indexes in all 6 tables and only add them in case by case basis.

Can you possibly give scripts...

Attached the DDL for all 6 tables.

here is problem. the inserts are happening using a service that is been developed 6 years ago. the person who wrote the tool is no more in the team and...

Yes, I agree i have 2 posts for work on same table. Yet, i thought to keep this post purely for purge and the other one for Partition. How ever,...

I'm trying to partition those tables with every 4 hours window. meaning the records that come in for 4 hours should in a partition. hope thats a good idea. is...