Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2009-09-11 : 11:54:12
|
| Hi,I am trying to copy a database FROM: SQL 2005 Ent. 32-bit (SP2) - Windows Server 2003 Ent. 32-bitFROM: SQL 2005 Ent. 64-bit (SP3) - Windows Server 2008 Ent. 64-bitThe error I'm receiving isDescription: ERROR : errorCode=-1073548784 description=Executing the query "EXEC sp_procoption N'[dbo].[smDEX_Build_Locks]', 'startup', '1' " failed with the following error: "The procedure 'sys.sp_procoption' cannot be executed within a transaction.".Does anyone have any ideas?Regards,Terry |
|
|
|
|
|
Copy Database Wizard