Re: Terminating this procedure. Cannot have an open transaction when this is run.

From: Tibor Karaszi (tibor.please_reply_to_public_forum.karaszi_at_cornerstone.se)
Date: 12/19/03 

Date: Fri, 19 Dec 2003 11:48:17 +0100

Sounds to me like an sp_configure issue. Can you post the output from sp_configure form that server? 

-- 
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"DavidM" <scandal_123@cox.net> wrote in message news:u%233cS8cxDHA.2064@TK2MSFTNGP10.phx.gbl...
> Hello -
>
> I'm trying to run
>
> Exec sp_change_Users_login 'report'
>
> From a few databases on our production server. When I try to execute, I'm
> receiving the following error message:
>
> Server: Msg 15289, Level 16, State 1, Procedure sp_change_users_login, Line
> 27
>
> Terminating this procedure. Cannot have an open transaction when this is
> run.
>
> This appears to run other servers. The particular server I'm trying to get
> this to work on is our DSS serer where tables are either truncated and/or
> dropped and created nightly for about 15+ databases.
>
> Transaction log is set to Simple and we're running SQL Server 2000.
>
> Thanks
>
>
> -- 
> ...david
> http://www.micro-mess.com
> http://www.va-mustang.com
> If you wish to reply to me personally, please remove
> the "underline" from scandal_123@cox.net. The is done to avoid SPAM!
>
>

Relevant Pages

  • Re: How to move system databases to new SAN drive in cluster serve
    ... I have moved model, msdb, and tempdb on a cluster ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrate stand alone sql server to a cluster without downtime
    ... Use backup and restore to create the databases on the new system. ... Run a log backup WITH STANDBY on each database on the old server. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: SPS 2003 Portal change SQL server
    ... select portal site to delete and choose to NOT delete the databases ... server farm, you can just copy them over. ... attach the databases to the new sql server. ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Moving SQL Server 2000 to a new machine
    ... In addition to all the CYA advise, you CAN move the system databases. ... Once you've got the new server at SQL2K, SP2, and the physical paths to ... > Recently I was tasked to move our entire SQL Server 2000 to a new server. ...
    (microsoft.public.sqlserver.server)
  • Re: Moving databases to a new server
    ... Moving Databases between Servers ... Disaster Recovery Articles for SQL Server ... I am leaning toward the detach and> attach method but I want to make sure there are not any hidden problems with> this method. ...
    (microsoft.public.sqlserver.setup)