Basically when an ntext datatype is used you have textimage_on on that table. Its not a datatype.

U have to install sql 2000, and use the sql 2000 upgrade wizard to upgrade 6.5 to sql 2000. Good luck.

moniter job success and blocking.

The sql agent must be using the startup account which might be the local account. Try to change the stahtup credetials for sql agent and that should do the trick.

...

would like to watch the replies. though my thinking says not so easy other then if there is a way to cheat the system.

I guess what you said is right...you need to upgrade to MDAC 2.7 though there have not been issues as most of the current sql server and OS installations are...

They have CBLOB datatype which can hold 4GB of data

Canceling vs kill is different. Kill command rolls back where as cancelling would not rollback unless explicitely specified and the rollback meets the criterea that's explicitely coded.

See the timeout perion set on sql server and u might need to increase that or the timeout period in query analyser if u r using one for running the...

It would be advisable to have backup of all the db's and the logins (thro' bcp so that u won't need to sync the id's).

Like you said, you can create and drop a clustered index by which the data pages will be defraged. So you don't need to have an clustered index and by...

Though its not recommended, but u can get the proc names from sysobjects in master database. Good luck.

Check for the table design and are there too many indexes on that table, which can also slow the process down. Check for fragmentation of the data pages on that...

Error handleing can be done using VB script or to have a condition with in the sql script that is executed.

We have about 125 db's ranging from 50MB to 3GB. There are about 40 of then that are about 2.5GB. They are run in sequence without any time interval. Though...