By "Never get committed" what do you mean?
Do you have orphaned users in the restored DB? These will be visible either
EM - Look in users and they are the ones with no login name
QA - Exec sp_change_users_login 'Report'
--
--
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Shawn" <anonymous (AT) discussions (DOT) microsoft.com> wrote
Quote:
I have a package that does a database backup and restore. Once the
restore task completes, I have a task that adds users to the newly restored
|
database. This task executes and package logs show it executes
successfully, but the sql statements in the task never get committed. It
doesn't seem to matter what sql I have in there - it doesn't work.
Quote:
Any ideas as to why this may be happening?
Thanks!
|
Re: package fails to execute task after database restore -
05-13-2004
, 10:48 AM
Linear Mode
