Please see my post @

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=18553&p=2

for script example to create alert for file growth.

Not sure if this will help, but maybe it will provoke other ideas.

While trying to remember what a .mdw was for, I ran across this in Access help:

"The workgroup is...

Perhaps this will help.

To track growth of data file:

Make alert called 'dbsize':

type: performance condition alert

counter: Data File(s) size

Alert if counter: Rises above ?(in kb)

Make job called 'increase dbsize alert':

Include...

And by author, please. I know we can see our most recent posts, but that only goes back a short while. How else can I find a post...

To shutdown/reboot machine, try:

Set colOperatingSystems = GetObject("winmgmts:{(Shutdown)}").ExecQuery("Select * from Win32_OperatingSystem")

For Each objOperatingSystem in colOperatingSystems

ObjOperatingSystem.Win32Shutdown(6) 

Next

ObjOperatingSystem.Win32Shutdown(6)

'6=forced reboot.  Change to 12 for forced power off.

See

Keep login, but add user to db_denydatawriter if you don't want them to be able to modify any data and db_denydatareader if you don't want them to even...

As a former bank VP, I am highly offended . OK, I got over it.

Years ago though, after hearing several such comments about...

Why not use DTS?

Transform Data Task to export to Access, then Execute Process Task to start up Access MDB once the data is exported.

quote:

---

quote:

--------------------------------------------------------------------------------

quote:

--------------------------------------------------------------------------------

I generally put in some text that allows me to get past the assistants balloon help and into the actual help file...

If you want to see the batch file, comment out the following line near the end:

set @cmd = 'del '+@batch_ftp 

It cleans up after...

Sorry for the troubles . I forgot that I was only able to send to the root - I had just learned to live with it....

Phil, thanks for the info on the ActiveX. Now that I've spent a little more time looking at ftp commands, I understand better.

Here is what the batch file looks...

I have a similar situation with a 3 million row table with about 250000 rows that have commas within the csv fields. This causes the data in some cases...

Perhaps this will help a little more.

Just run the code above to create the ftp proc (heck, I don't claim to understand all the details anymore than I know how...

This will do it: (Thanks again to EDK89 - This was a big help to me-the only change I recall making was to add the @servername since I was...