Thanks for replies, the script is working there was a security error on ftp site causing issues. The question I have now is how do you

issue a Change Directory command?

When...

error:

Exception calling "GetRequestStream" with "0" argument(s): "The remote server returned an error: (550) File unavailable (e.g., file not found, no access)."

I ran script as delivered, and seems like my remotefile something is wrong.

"ftp://ftp.xxx.com/filedrop/test.txt"

If I open a cmd window and feed param in just like script it works.

Thanks.

I'm testing with remotefile but have something wrong

$RemoteFile = "ftp://ftp.xxx.com/filedrop/test.txt"

Exception calling "GetRequestStream" with "0" argument(s): "The requested URI is invalid for this FTP command."

At line:18 char:1

+ $Run = $FTPRequest.GetRequestStream()

Thx.

After connecting to FTP site how do you do a change directory command, and can you just point to a folder to

deposit the files from local, not having to give...

Nice script captures all requirements.

Many Thanks

I found a temperature within the past hour and it didn't report back in the query.  Will I just be able to output derived1

in the sendmail?

Thanks.

Thanks Scott, that's what I was looking for, as pushed to SQL not pulled.

"Write a query that satisfies the criteria you outlined"

Not sure how to setup the query to gather the information to alert groups of a problem.

Looking back at previous time window...

I sent just an example rebuild, sorry.

I was thinking of using this script on my fragmented index rebuilds.

USE [xxxx]

GO

ALTER INDEX [PK_EmployeeJobHistory_1] ON [dbo].[EmployeeJobHistory]

REBUILD PARTITION = ALL WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,

SORT_IN_TEMPDB = OFF,ALLOW_ROW_LOCKS =...

does anyone have there SP they run and like to share ?

Thx.

I'm going to do a REBUILD. If I have 3+ indexes along with PK, is there any rule on thumb to rebuild each individually or

REBUILD ALL on the table?

Any trade-offs...

nbr-of-columns    avg-row-length             records

15                                  905      ...

sql2012 - sp4