Sorry, no good way that I know of to do this. I might import it as one large text field and then use T-SQL with charindex/patindex to parse things out.

You can determine if it is running by trying to start SQLMail from a job and noting the return message. This is the best way to check on this and...

Sorry, not sure where the results are. I received a copy of the survey in email since I participated. Here are some more details, but I didn't see the same...

Glad you liked the conclusion I try to live my life that way and finding an enjoyable situation is worth some $$. I...

I'll have to keep an eye on that one. Got questions for a few weeks, but I might use that one in a...

Agree with above. Consolidate to 1 if you can, but keep a backup. Use log shipping, etc. to get your data moved to the second server and ready in case...

You can't be assured that no one is working in temp as ORDER BY, GROUP BY, etc. all use tempdb.

Use the shrink files from EM (database, right click, all tasks,...

charindex and/or patindex. Use them to find test (numericl position), then get the numerical position of the next \ wher you want to stop. Use patindex again, but a starting...

Advantages:

It's more scalable and should handle larger loads. Access/Fox is a file based system, so it's like everyone is using not only the same files, like people sharing an Excel...

Got to look in the mirror. I know it's been me in the past a few times

Good points, and I agree that's the case in many places. But are you sure you're code is better than someone elses?

I think this is valid in some cases, there...

I was wondering how many people might not know. I'd hope if you came here you'd have seen it, but maybe not.

Hopefully they...

Steve,

You can have it if you want. It's sitting under my desk, but for the shipping cost, you could probably get one on ebay that would beat it's socks off.

I...

I tend to agree that technology is exasterbating the problem. The big reason is that it makes it easier to collect more and more information at a greater level of...

No one cares