Re: Enterprise Mgr - alter table fails
- From: stephanie.harrell@xxxxxxxxxxxxx
- Date: 28 Mar 2006 04:48:30 -0800
I thought I would let you know that I found the problem. The
XACT_ABORT option had been turned on server-wide. The new tools with
SQL 2005 allow you to turn that option off/on in the server properties
and someone had turned it on. Once I turned it back off, Enterprise
Manager worked like a champ again. Guess this is why we have
development servers - to learn lessons the hard way.
Erland Sommarskog wrote:
Thank you for your reply and you are certainly entitled to your opinion
on who should change tables. Our set up works for us. We support a
large audience of developers at varying levels of expertise and this is
the first time we've encountered any problems with the tool.
That you know of. Some of the problems that I pointed out are of the
kind that you may not notice directly when they cause problems. If you
lose an FK constraint, you may not notice until years later when you find
some junk in the column.
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
Books Online for SQL Server 2000 at
- Prev by Date: Re: Open a file in Existing Query window ( SQL 2K5 )...
- Next by Date: Re: bcp accent problem
- Previous by thread: Re: Enterprise Mgr - alter table fails
- Next by thread: Re: SMO