October 20, 2008 at 10:44 am
I am trying to modify a table column in SQL Server 2000 using Enterprise Mgr. When I try to save the table, I get
'tblPlatform' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot DROP TABLE 'dbo.tblPlatform' because it is being referenced by object '1655012977'.
However, there is no object '1655012977' that I can locate!
Anyone have any ideas what is going on and how I can fix it?
October 20, 2008 at 12:50 pm
milzs, have you tried?
SELECT
*
FROM sysobjects
WHERE id = 1655012977
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2008 at 12:57 pm
Sounds like a foreign Key reference.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
October 20, 2008 at 12:58 pm
Oh yeah, first thing I tried. Zero rows returned... This is baffling.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply