2009-02-27 04:52:01 UTC
I came accross a problem with tran. replication on db which was detached
from 2005 and attached to 2008.
Logreader was failing with:
The process could not execute 'sp_replcmds' on 'serv1\IN1'. (Source:
MSSQL_REPL, Error number: MSSQL_REPL20011)
Get help: http://help/MSSQL_REPL20011
Cannot execute as the database principal because the principal "dbo" does
not exist, this type of principal cannot be impersonated, or you do not have
permission. (Source: MSSQLServer, Error number: 15517)
All agents were started with the same user which is local admin and sql
sysadmin on the same host.
When I created db's 'new' on 2008, the same exact set up started working.
Do you have any explanation to it?
Are you aware of any functional shortcomming from detaching / attaching db's
as an upgrade path?