You may have a set of disks built for ghosted workstations. I.E., someone built the disks specifically for client tools only.

I love polite respondents. Heck, I love people who actually respond once you give them advice. It's nice to know when advice doesn't go down the rabbit hole and who...

Glad I could help. Please let us know if you have any additional questions.

I assume this is in SSIS? You're using the Script Transformation Editor?

What exactly does your input and output data look like (examples, please)? Are you pulling from SQL Server or...

Aha. There are similarities in this code for what I did as an article today. Using spaces to alter character case. In this situation, though, I'd advise looking at the...

You don't completely...

You need to follow both Gail's and Jeff's advice. You can embed a REPLACE inside of a CONVERT to fix the hypen problem, then switch that column to datetime or...

Sounds like you need to use some ANSI searches to find those. What's your collation set as, BTW?

I know nothing about Avast, but if you want a separate named instance on your server for the Avast DB, that's perfectly okay.

Yes, you need the install disks or...

WayneS (10/16/2010)

"I've got this task, needs to be done in an insert trigger".

So, I give the code for doing so.

"Now, can you incorporated it into my...

My company offered Office through this program. A couple of months ago, though, we were informed that anyone who'd bought the software through this program would no longer be covered...

I've looked at your file and I notice you have a First Pass and a Second Pass. Can you explain these better please?

Because when I sort that file by GUID,...

I don't see an attached Excel file.

EDIT: Nevermind. I thought you meant attached to current posts. Not your previously attached file.

Gail,

Isn't your project's "deadline" sometime next week?

WHOO!

I'm #50 (overall) for about the next few minutes before I drive down to Orlando for the weekend for SQL Saturday 49 and lose my standing to the weekend posting...