Search results for query: *

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.

TreeSizeProfessional There is a free version that works well. I've purchased the Pro version for extra options and better performance as I use this tool often. http://www.jam-software.com/treesize/

Forgive me as I am sure this has already been an issue, if so can someone link me to the string. If not I would really appreciate some help. We have a Terminal server with about 50-60 users working on it at time. Performance is good with no high peaks of CPU and Memory. The only problem we...

The reason why I think it will is this; I work for a company that merged with another company. We have 2 databases for each company. Right now users from company1 can see the calendar and availability of company2 users and vise versa, but can't see the contact record and other relevant data...

Awesome! It sounds like it could work. Thanks for the reply.

Goldmine is a sales tool we use. Its data comes from Sql Server. Goldmine’s security and user views are very bad. I am trying to do something as basic as not letting user1 see user2’s data. There is a long step process that when completed still doesn’t work right. Whenever user2 needs a list of...