select cast(so.name as char(30)) as TableName, sc.colorder, sc.name as ColumnName

from sysobjects so, syscolumns sc

where so.id = sc.id

and so.type = 'u' 

and so.name = 'batchheader'

order by so.name, sc.number

Is there any input on the "cross database ownership chaining" option. Seems if you use 3 (or 4) part table names that reference tables in a different database than...

Vhanda's script from MS support is pretty nifty.

It appears that one of the things the script does is attempt to put the active virtual file at the beginning...

Here's another method of fixing sysjobs and sysjobsteps after this problem is encountered.

--after moving MSDB to a diff server, run the folloiwing

use msdb

go

update sysjobs set originating_server = @@servername

update...