-
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
-
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
-
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
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
|
|