I think it depends on how they used the CRC. Is it on a table, a table row, or ???? If anybody knows the answer please post.

First determine if...

CRC errors are data corruption errors. Look it up on wikipedia.

There must have been a CRC checksum and you have been warned that your data is bad. Try to...

The only valid objection to ODBC that I can think of is the maintenance of the DSN on the client machines, and maintenance of ODBC drivers on machines. This can...

Jan, in Access 2003, it looks like ODBC was the only viable choice. I'm puzzed though as to why you cant link to the new SQL 2005 server. Since you...

I installed Service Pack 2 yesterday, so you probably need to upgrade.

Hope this helps

Thanks. You saved me lots of time, so I'll leave you with this....

Every man dies......But few REALLY live!

Have a great day....

Sorry about that, good luck with your problem. I tried to do the same in SQL 2000, but you can't add a server login inless you're SA. DBO's could make...

please excuse me for interrupting, but I'd like to do something related, but with a different twist.

Rather than creating a SQL login for each database user, do you have an...

Simon, it should not be that difficult (only tedious) to go from VB6 /ADO/SQL. There's seems to be no reason to use access in the middle.

Most of...

Check out the tools at redgate or make your own. There are SQL DMO objects you can use in .NET. you can probably create a simple tool to loop through...

William, I'd agree that its negotiable and I don't like surprises in the final invoice like Steve said. If you're dealing with someone that knows the software business it should...

Thanks to the person that posted the SQL to show changed objects based on the modifiy date. Here's a different version that calculates the days since last change as "DaysOld"...

This is what I'd do:

1) compare Development to production and create an "update" script with the new procs, tables, etc. (redgate tool works great)

2) Ask programmers what reference tables they...

The simplest thing to do is to start profiler and find out what's going on at the SQL server. And search this site, there are similar posts that...

You also have the option of adding a single sql agent job and separate job steps for each database.

you can also try this in a single job step:

use xxxxxx

go

exec...