I think you're ok with memory as well, but with 8GB, you probably want to give 6-6.5 to SQL and see if performance improves

Make sure you have AWE on and...

It doesn't always start itself. Might be more consistent in 2000, been awhile since I've worked with this, but I know it used to need to be started.

There are two...

DBCC CHECKDB will check the consistency of a database.

There is no check for a server.

Do you know what you're trying to do? A "healthy" server could mean any...

What is Integration SQL DB?

I'm not sure why the results would be different. Is there data that's greater than 4000 char and might be getting lost in an implicit conversion?

Also,...

What app is this?

Clipped should be Fox 2.x or dBase IV if I remember. I'd think that any DBase driver would read it.

Use the Import Wizard in SQL Enterprise Manager and try some...

I'm assuming this means that you solved the problem yourself?

Please post a followup that explains what worked so we know it's solved.

You also need to provide a user/password in mixed mode. Without a domain, you would add a "SQL Server Authenticated" login to SQL Server, then use the same name/pwd in...

I'd use ALZDBA's solution.

If that doesn't make sense, give us an idea of what the conditions are and we can help (tables/cols)

The only thing that I've done in the past is check for a change to the user. When the user changes a password, the data in syslogins is updated (some...

I believe because of the SID mapping in 2000 that you can only have one login in each db mapped to a user. So you'd need to make the changes...

In 2005 you have all sorts of event triggers (look up Event Notifications) for logins and changes.

For data changes, you really should use Profiler with a server side trace. It...

Can you provide some more information?

When you log in through ODBC, which login do you use and what are the rights?

When you create a table, how do you do it...

What is in the package? This is definitely some type of network error. Are you sure you're checking the names referenced in the package? You might try saving it out...

Moved to the Anything not SQL forum.