Recent content by sk8ology

I'm trying to update a table and clear out all internal notes made by employees because clients are able to see them on our website. All notes start with #Blind Note: and are followed by the notes on the next row and proceed in order with the seq_no just like my example below. The DNT_DBR_NO is...

Can anyone suggest a program (hopefully free) that can check FTP sites on a schedule and email me if there's a new file? Or better yet email me the file if under a certain size? I have WS_FTP Pro 2006 and I thought that would be an easy option, but I'm not sure if it's an option at all. What...

Perfect!!! Thank you so much!!

I'm trying to create a SourceID that's the CompanySourceID '-'(just the year of a date with the format mm/dd/yyyy)'-' RefNum so it might look like this; SourceID asdf-2008-1234 UPDATE Docs SET SourceID = CompanySourceID + '-' + SUBSTRING(DocDate, 7, 4) + RefNum I get "Argument data type...

Awesome!! Thanks! It worked when I took out the wild card. When I left it in it said Warning: Could not find file d:\ImportNEW\fileABC1* to copy. The files I need to backup don't change names but others do. Why isn't it recognizing the wild card?

I'm trying to create backups of files we are getting from a client. They come to us like fileABC1000I. We have an ANT script that manipulates the data but before this within in the same script I want to backup the file with a timestamp in the filename. The programmer that developed the ant...

Looks like your on to something. I'll give it a shot and let you know. Thanks.

Here is what's happening. I manage a 50 user 2003 Terminal Server. Not all users are using the same email client. Managers are using Outlook, basic users are using Outlook Express, and some power users (or users fed up with both outlook and OE) are using Thunderbird. Every time you log into any...

This looks like a great script! Thank you for posting this. I've been looking for a script like this.

Never mind. I closed Sql 2005 Management Studio and Sql 2000 Enterprise Manager and just opened 2005 and It worked. Weird!

I get the following error message, =================================== Retrieving the COM class factory for component with CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} failed due to the following error: 80070006. (Microsoft.SqlServer.ManagedDTS) ------------------------------ Program...

Bummer!!! I purchased Disk Director but then tried to install it on a server but got a message saying I needed to purchase the server version. I just checked that cost and it's $500. That's a hefty price tag. I still haven't had a chance to test this out and now am not sure if I will.

Not yet. I'm giving it a go tonight. I will let you know.

Thanks, I purchased the newest version of Acronics disc director and am going to give that a shot. I will remove A disk as backup and add space to C from D. I'll let you know. Again thanks for all your great advice.

I have done all this. I have applied as many bandades as possible. It's time for us to apply a permanent solution. Thank you though.