Meaning ??? negative number and out of lock

[John]

Help

Why is the unsed space is negative number? Whould that affect the database? How do you fix the negative number?

If 'out of lock' happen, how do you check at what level the object was/is locked and how many locks is needed to configure?

Thank you ahead of time

[Doug Mongeon]

I am assuming you are using SQL Server6.5? If so, we just ran into the same problem. It was a BAD CD-ROM....the version of SQL Server had a problem with the Enterprise manager. If you look from another server....from another disc...you will find that the size is actually as posted.....try to find a replace SQL Server CD to see if this fixes the problem.

------------
John at 9/28/99 10:47:53 AM

Help

Why is the unsed space is negative number? Whould that affect the database? How do you fix the negative number?

If 'out of lock' happen, how do you check at what level the object was/is locked and how many locks is needed to configure?

Thank you ahead of time

[Ray Miao]

Try 'sp_spaceused @updateusage=true'. If you out of lock, just increase number of locks with sp_configure.


------------
John at 9/28/99 10:47:53 AM

Help

Why is the unsed space is negative number? Whould that affect the database? How do you fix the negative number?

If 'out of lock' happen, how do you check at what level the object was/is locked and how many locks is needed to configure?

Thank you ahead of time