Steve, I'd noticed the same thing happening. I figured it was the same old bit where in one of the included Forum topic snippets someone had used some funky...

I'm fairly embarrassed to admit just how good I am at Minesweeper. Great for blowing a few minutes here or there. I never really got all that fascinated...

Phil, I'm curious about the code you posted. I changed a bit of the script and incorporated the join as opposed to the loop to get the dates, but...

Jeff, I took a look at what you did for that other median and I guess I just don't understand what's going on. My original Ugly slow SQL was...

Thanks for the quick replies guys, I'll have a look at it them a bit more indepth on Tuesday when I get back into the office.

And Phil I totally agree...

yeah I was going to recommend that as well, but there's that whole if you ever need to restore bit.

If you go this route make sure you understand...

Yes a shared folder is what we were talking about. you create the share on server B and make sure that the SQL Agent Has Write Permissions to the...

I take it there's no chance you can connect a USB or FIREWIRE device and do a quick backup to that then shrink the Transaction log? Also for probably...

Do you need to backup to server B due to space constraints and such, or are you just looking to get the backup to the second server for redundancy?

The reason...

Just about the only thing that I can estimate correctly these days is brewing a batch of beer. 4.5 hours from start to finish including cleanup, and 3 weeks...

Without a doubt I feel this is the best one stop SQL resource out there. The fact that it's free is fantastic as well. Between the Articles, the...

Your old reports for the last election, are they still on your web server? Do they point to a database that refreshes the data on the fly or are...

The function in this link may provide you with the appropriate information...

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519&SearchTerms=F_TABLE_DATE

Else you may find the following useful..

http://www.intelligententerprise.com/db_area/archives/1999/992112/celko.jhtml

hope this helps.

-Luke.

Yup that did the trick. Hadn't thought of pre-populating a hidden one.

Thanks muchly!

-Luke.

A windows alert for which? Gordon Pollokoff's advise or Server's Alive?