Send him this link. Tell him you "found it" during research.

Steve Jones

steve@dkranch.net

Thanks for the feedback. It appears that your Access database uses a different collation (kind of like language) than SQL.

Create a temp table and insert the data, then move it...

Glad to give opinions. Keep checking back, I'm sure Andy will weigh in tonight.

Steve Jones

steve@dkranch.net

Kind of. Personally I do the following:

Backup SQL to disk locally. gives me immeditate access to restoring dbs in case of data errors and allows fast backup.

Copy to remote disk...

yes, sorry. thanks. I meant disk.

Most people prefer backup to disk. At TechEd 2000, a number of the sql team also recommended this. Not to disparage vendors, but unless you...

haven't seen it. You might have a problem with MMC (a windows app) rather than EM (an MMC snap in.

Can you manage the Itnernet services through MMC?

Steve Jones

steve@dkranch.net

You can backup the logs to tape automatically, but you still get into the "time factor".

One other issue with tape libraries. This also applies to disk. What happens if there...

resetting the pwd will prevent future infection. Not sure about later, but it should. My guess is the worm keeps attaching via sa.

Your description of the web sites sounds fine.

Steve...

Haven't had too many restores with Verias and actually need to do a DR sometime, but I convinced our admin to skip it and just grab the files.

One issue with...

An interesting problem and one I've given some thought to lately as I've been doing a little MySQL work. I think the only way to build a good cross platform...

.NET is the new direction for all MS apps, supposedly T-SQL. This will mean that T-SQL will support inheritence, encapsultion, etc. Not sure how that will work, but supposedly T-SQL...

There are a few possibilties.

Connecting over TCP/IP uses ports 1433 adn 1434 and 445 (I believe) for EM. Be sure these are not blocked.

Be sure you have the same protocols...

You are welcome and this is the number of error before it fails.

Techincally, I beleieve that these erors are omitted from the transaction count, but I'dhave to test it.

Thanks...

On the last tab of the Transform task, you can set the error out count.

Steve Jones

steve@dkranch.net

Profiler, check books online for the syntax of starting. you can log to a table and then search the text of each command being run.

For the print statements, ADO will...