Groups > comp.databases.ms-sqlserver > #182

Re: SSMS 2008: Confusing/Incorrect Error Message Take 2

From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SSMS 2008: Confusing/Incorrect Error Message Take 2
Date	2011-04-15 11:13 -0700
Organization	A noiseless patient Spider
Message-ID	<oe2hq6licisakkl0c3o67dn81rv97rc1oo@4ax.com> (permalink)
References	<emseq6t05kacde727krpm75une3e3u42ar@4ax.com>

Cross-posted to 2 groups.

Show all headers | View raw

On Thu, 14 Apr 2011 15:29:55 -0700, Gene Wirchenko <genew@ocis.net>
wrote:

[snip]

>     Maybe, I am overlooking something trivial, but at this point, I
>have no idea what.

     A co-worker found
          http://support.microsoft.com/kb/925719
This documents a bug.  What set it off for me is not having a primary
key in the Subaccounts and TranTypes tables.  I mistakenly specified
"unique" instead of "primary key".  With that change, the error went
away.

     Edit Top 200 Rows still gloms onto a connection, and I can not
rerun my script which drops the database prior to recreating it.  That
problem is minor.

[snip]

Sincerely,

Gene Wirchenko

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SSMS 2008: Confusing/Incorrect Error Message Take 2 Gene Wirchenko <genew@ocis.net> - 2011-04-14 15:29 -0700
  Re: SSMS 2008: Confusing/Incorrect Error Message Take 2 Gene Wirchenko <genew@ocis.net> - 2011-04-15 11:13 -0700
  Re: SSMS 2008: Confusing/Incorrect Error Message Take 2 Erland Sommarskog <esquel@sommarskog.se> - 2011-04-15 23:33 +0200
    Re: SSMS 2008: Confusing/Incorrect Error Message Take 2 Gene Wirchenko <genew@ocis.net> - 2011-04-16 21:18 -0700

csiph-web