have you got the right versions of the patches (32 bit rather than 64 bit say?)

Having verified the database is SQL2008 compatible and the app still works and attached the database to the SQL2008 instance you should run the following, mainly for performance reasons

-- set...

just to finish off this thread and put some info out there.

Went the drop column route in the end. DB in simple recovery mode

17GB table, 9.4 million rows, drop column...

I'm surprised Gail and Jeff haven't jumped all over this but that does not look like a good candidate for a clustered index, its certainly not narrow or ever-increasing.

Changing the...

two ways basically -

Using a command line utility called bcp

Or use SSIS. You get started with that by using using the wizard from SSMS. Right click the database and choose...

Also I always use the 'update_one' option

Its still valid in SQL2008 but is marked to be deprecated. try alter user instead.

What error do you get?

the databases were suspect so the GUI would not alow any action on them. Going up one level to the database root node should allow you to restore a database...

It is perfectly acceptable to get your system databases back by moving the files back into place. I always have this option available to me for DR purposes. Its basically...

As Perry...

when you get into terrabyte databases the emphasis shifts (IMHO) and direct backups to tape begin to make more sense. Thats a lot of disk to tie up for backups

However...

have you tried without the rollback immediate?

trace flags can be set on the fly.

dbcc traceon(1222,-1)

dbcc traceoff)1222,-1)

If you backup to disk then offsite this backup to tape this also gives you two copies of the backup.

you keep perhaps 3 on disk for speedy recovery and a...

people may also want to look at sp_help_job and xp_sqlagent_enum_jobs

Only sysadmin will give them that level of control.

Otherwise set up a SQL account, have all jobs owned by that account and get everyone to log on with that account...