Results 1 to 3 of 3

Thread: Transfer Database problems

  1. 03-09-1999, 11:44 AM #1
    Alex Guest

    Transfer Database problems

    Hey everyone,

    I'm trying to do something which seems very simple. I'm trying to copy over extended procedures from
    the master database, into another database which I created. I need to run xp_sendmail from my database
    that I created, but it won't allow me to do it unless if I run the command from the master database.

    I get the following errors from the transfer database log:

    Does anyone know how I can fix these errors so that I can copy over the extended procedures?
    The ad-hoc error seems to be excessive. I can't find how to enable it. Any ideas?

    Also is there a way around this -
    'sp_addextendedproc' can only be executed in master database

    Thanks!

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysprocesses'.

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslocks'.

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 13
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'dbo.MS_sqlctrs_users'.

    ::Error::
    In file TMC05.master.PRC in statement on line 16
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 20
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 27
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 30
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSSQLOLE65_version' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 45
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSSQLOLE_version' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 68
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 343
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdatabases'.

    ::Error::
    In file TMC05.master.PRC in statement on line 539
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 542
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSdependencies' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1043
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSenumsubsystems' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1080
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSfilterclause' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1118
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeach_worker' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1227
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeachdb' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1282
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeachtable' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1319
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSgetalertinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1369
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSgetexecinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1401
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelpcolumns' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1715
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelpindex' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1763
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelptype' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1893
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSindexspace' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2012
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 2043
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2046
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2046
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2166
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2169
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSmatchkey' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2246
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSobjectprivs' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2466
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSsetalertinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2509
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSsetexecinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2545
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 2560
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2634
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2637
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablechecks' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2669
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablekeys' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2941
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablerefs' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3134
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablespace' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3185
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSuninstall_publishing' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3314
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSuniquename' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3365
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3369
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3373
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3377
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3381
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3385
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3389
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3393
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_a_count_bits_on' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3517
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'spt_committab'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3517
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'spt_committab'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3541
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 3619
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 3622
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 3622
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4081
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4084
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_addextendedproc' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 4107
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4178
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdatabases'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4705
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4708
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4915
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5481
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5601
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5601
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5825
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6180
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6183
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6538
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6865
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6868
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6868
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6956
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabl
    Reply With Quote Reply With Quote
  2. 03-10-1999, 03:08 AM #2
    Patrick.Fediere Guest

    Transfer Database problems (reply)

    Hi Alex,

    May be you have good reasons for doing a copy of the contains of the Master Database However, the Proc. involved are of very/extremely high technical level. I mean that they relate and work with a lot of real and pseudo tables and other objects that "your database context" can't offer.

    My advise is of avoid this approach. the risk is maximum.

    Regars
    Patrick


    ------------
    Alex at 3/9/99 11:44:06 AM

    Hey everyone,

    I'm trying to do something which seems very simple. I'm trying to copy over extended procedures from
    the master database, into another database which I created. I need to run xp_sendmail from my database
    that I created, but it won't allow me to do it unless if I run the command from the master database.

    I get the following errors from the transfer database log:

    Does anyone know how I can fix these errors so that I can copy over the extended procedures?
    The ad-hoc error seems to be excessive. I can't find how to enable it. Any ideas?

    Also is there a way around this -
    'sp_addextendedproc' can only be executed in master database

    Thanks!

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysprocesses'.

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslocks'.

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 13
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'dbo.MS_sqlctrs_users'.

    ::Error::
    In file TMC05.master.PRC in statement on line 16
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 20
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 27
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 30
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSSQLOLE65_version' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 45
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSSQLOLE_version' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 68
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 343
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdatabases'.

    ::Error::
    In file TMC05.master.PRC in statement on line 539
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 542
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSdependencies' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1043
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSenumsubsystems' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1080
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSfilterclause' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1118
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeach_worker' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1227
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeachdb' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1282
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeachtable' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1319
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSgetalertinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1369
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSgetexecinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1401
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelpcolumns' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1715
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelpindex' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1763
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelptype' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1893
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSindexspace' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2012
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 2043
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2046
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2046
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2166
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2169
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSmatchkey' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2246
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSobjectprivs' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2466
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSsetalertinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2509
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSsetexecinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2545
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 2560
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2634
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2637
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablechecks' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2669
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablekeys' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2941
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablerefs' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3134
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablespace' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3185
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSuninstall_publishing' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3314
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSuniquename' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3365
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3369
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3373
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3377
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3381
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3385
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3389
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3393
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_a_count_bits_on' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3517
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'spt_committab'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3517
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'spt_committab'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3541
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 3619
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 3622
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 3622
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4081
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4084
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_addextendedproc' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 4107
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4178
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdatabases'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4705
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4708
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4915
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5481
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5601
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5601
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5825
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6180
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6183
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6538
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6865
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6868
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6868
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6956
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabl
    Reply With Quote Reply With Quote
  3. 03-10-1999, 03:30 PM #3
    Kenneth Wilhelmsson Guest

    Transfer Database problems (reply)

    No, you cannot move xp_'s from master to a user db, and you shouldn't even if it were possible.
    The fact that 'sp_addextendedproc' can only be executed in master database also tells you that.

    Now to your problem. If you want to send mail from your user db, just use a full qualified name, like 'exec master..xp_sendmail' and you'll be just fine.

    /Kenneth


    ------------
    Alex at 3/9/99 11:44:06 AM

    Hey everyone,

    I'm trying to do something which seems very simple. I'm trying to copy over extended procedures from
    the master database, into another database which I created. I need to run xp_sendmail from my database
    that I created, but it won't allow me to do it unless if I run the command from the master database.

    I get the following errors from the transfer database log:

    Does anyone know how I can fix these errors so that I can copy over the extended procedures?
    The ad-hoc error seems to be excessive. I can't find how to enable it. Any ideas?

    Also is there a way around this -
    'sp_addextendedproc' can only be executed in master database

    Thanks!

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysprocesses'.

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslocks'.

    ::Error::
    In file TMC05.master.PRC in statement on line 1
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 13
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'dbo.MS_sqlctrs_users'.

    ::Error::
    In file TMC05.master.PRC in statement on line 16
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 20
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 27
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 30
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSSQLOLE65_version' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 45
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSSQLOLE_version' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 68
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 343
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdatabases'.

    ::Error::
    In file TMC05.master.PRC in statement on line 539
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 542
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSdependencies' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1043
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSenumsubsystems' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1080
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSfilterclause' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1118
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeach_worker' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1227
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeachdb' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1282
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSforeachtable' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1319
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSgetalertinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1369
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSgetexecinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1401
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelpcolumns' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1715
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelpindex' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1763
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MShelptype' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 1893
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSindexspace' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2012
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 2043
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2046
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2046
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2166
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2169
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSmatchkey' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2246
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSobjectprivs' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2466
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSsetalertinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2509
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSsetexecinfo' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2545
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 2560
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 2634
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 2637
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablechecks' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2669
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablekeys' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 2941
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablerefs' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3134
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MStablespace' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3185
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSuninstall_publishing' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3314
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_MSuniquename' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3365
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3369
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3373
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3377
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3381
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3385
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3389
    Transfer Status: Creating Stored Procedures on destination database
    'sp_addextendedproc' can only be executed in master database


    ::Error::
    In file TMC05.master.PRC in statement on line 3393
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_a_count_bits_on' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 3517
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'spt_committab'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3517
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'spt_committab'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 3541
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 3619
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 3622
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 3622
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4081
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4084
    Transfer Status: Creating Stored Procedures on destination database
    Object 'sp_addextendedproc' group number 1 already exists in the database. Choose another procedure name

    ::Error::
    In file TMC05.master.PRC in statement on line 4107
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4178
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4181
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdatabases'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4289
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslanguages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4563
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysmessages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4705
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4708
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 4915
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 4918
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5134
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysusages'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5309
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5481
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5484
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5601
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysremotelogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5601
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysservers'.

    ::Error::
    In file TMC05.master.PRC in statement on line 5825
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6180
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6183
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6538
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6541
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'sysdevices'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Invalid object name 'syslogins'.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6702
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6865
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6868
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6868
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6956
    Transfer Status: Creating Stored Procedures on destination database
    You may only GRANT or REVOKE permission on objects in the current database.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabled. System Administrator must reconfigure system to allow this.

    ::Error::
    In file TMC05.master.PRC in statement on line 6959
    Transfer Status: Creating Stored Procedures on destination database
    Ad-hoc updates to system catalogs not enabl
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules