Hey!!!!!!!!! script the table using Database publishing wizard which gives you both the schema & objects (values). Drop the exisiting table. Re-design the index and do the rest of the...

It depends on the functionality/business process on how we do the data restoration. Better, u create jobs by invoking connections, pointing to the particular databases, set the time and...

In this case, better create a temp table so as to update the records as when the correction / modification is done to the source file. Then, dump the source...

try to implement DTS package for pulling the records / editing or modifiying the records of the existing table in the databases. Or try to use SSIS for this kind...

try to implement by adopting some the keys mentioned overhere.....

http://www.sqlservercentral.com/articles/Monitoring/basicsofc2auditing/1547/

try this link with the samples.

http://www.vbmysql.com/articles/vb6-mysql/using-mysql-visual-basic-6-and-crystal-reports-9/

better try this link example.

http://support.microsoft.com/kb/317058

better try this link samples : I think this will solve your issues.

http://www.codeproject.com/asp/Webmaster_Email.asp

try out this link with following samples.

http://support.microsoft.com/kb/258038

this can happen due to already installed files get corrupted or some supporting files running the sql can be tampered/destoryed. Better, un-install all the sqlserver 2005 files from your computer/server....

Instead of DTS, better try to pull the data using Import/Export Data methodoly. But the only hindrance here is you need to change the data types of access so as...

please use identity insert off/on and try to update the respective types accordingly.

it will work when u migrate from 2000 to 2005 as the similiar funtionality being carried by sqlserver

Try using DBPublishing wizard which will create a script alongwith (schema & data) of the existing server -2000. Keep a back up of this script.

Run the script into 2005 server....

Where is your destination server that is pulling the data thrugh transformations / jobs. My suggestion will be initially through ssbistudio, create a dummy table, run the package and check...