This position is still available.  Candidates with strong database administration or data warehousing experience in other RDBMS are now being considered.  Must have a strong desire to learn Teradata.

Yes, I'm using DTS.  That sort of accomplishes what I need, but not exactly.  The package fails as soon as it hits the first error, which is "column delimiter not...

I guess I didn't word my question quite right.  We need to be able to integrate the users documented within the Pegasys cardkey system with the users in AD, not...

I'm not quite sure what you mean.  The Cardkey Pegasys 2000 server is already using mixed mode authentication.  That doesn't automatically integrate the system with AD.

Ultimately, we would like to get to a single sign on environment.  This is one piece of the puzzle.  The main objective with this system would be to be able...

Is the basic structure of Pervasive SQL more similar to MS Access or SQL Server? (Does it have just one data file for the database or are there multiple...

Time wise...I'm referring to both. This system is 24x7 and downtime needs to be held to a absolute minimum. As for adding clustered indexes, I can suggest it,...

Is there no other way?? I've got 170 tables and 108 indexes to move. Creating a dummy index and then dropping it will take just as long, if...

What if there is no clustered index on the table?? Is there any other way to accomplish this?

The security patch indicates that MSDE is affected by the vulnerability, so I'm assuming that means it should be applied, but I cannot find any specifics on how to do...