Many Tables in DB, Cant Add New Table

[toetag]

We have a database with 8535 tables (not my design, it's an application vendors configuration).

When we try to use their application to create a new table OR use Enterprise Manager, it just hangs. No Table is ever created.

In the logs i'm getting:

WARNING: EC 4fc73af0, 0 waited 1200 sec. on latch caf408, class MISC. Not a BUF latch.
Waiting for type 0x4, current count 0xa, current owning EC 0x4DD27B10.

If i script a table:

CREATE TABLE [dbo].[Testing_Create] (
[name] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

and run this in QA against the Database in question, it works fine.

I'm out of ideas. Any possible suggestions?

"The only desert to an Irishman is an empty glass".

 

[Catadmin]

Sounds like the application is trying to call or alter code in SQL Server when it does the DB creation which is failing. Perhaps it's looking for a proc that doesn't exist in your version of SQL?



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[mrdenny]

Do a checkdb on the database. Sounds like sysobjects or sysindexes is corrupt.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com