Interesting. Despite having no rows, there are over 5000 pages that belong to the table. I would hazard a guess that they all have ghost records on them (marked as...

stephen.wolfe (10/27/2008)

---

I was wondering if it would be as easy as restoring a backup, so, I could essentially do that now with the plain jane version of the database I...

Can you perhaps query sys.dm_db_index_physical_stats for that table and post the results?

At least find out from the vendor where that locked rows report is coming from.

If the subscription gets reinitialised, a new snapshot must be generated. The...

Try something like this

SELECT ref, design, armazem, SUM(CASE origem WHEN 'BO' THEN qtt WHEN 'FT' THEN -1*qtt ELSE 0 END) AS sumqtt

FROM SL

GROUP BY ref, design, armazem

20%...

If you used the import/export wizard, it will just bring the data across and create tables based on that data. No keys, no constraints, no indexes, no defaults, etc

For that...

And a SELECT count(*) FROM tbDataList returns 0?

Is it possible that there are two tables named tbDataList in different schemas?

Can you post table definition (as a create statement), some sample data (as insert statements) and your desired results please.

Can you post table structure, query and Statistics IO output for running the query? (SET STATISTICS IO ON)

Dan Guzman (10/27/2008)

---

And maybe post 5 questions per month for registered users (un limited responses to your own questions) and maybe 5 or 10 respones to other users questions....

todd_dawson (10/27/2008)

---

I have users trying to run queries, their program is telling them that a user has some rows locked, but the user hasn't been in the system for months....

Great. Now make sure that you have regular log backups scheduled so that this doesn't happen again.

Why? What are you trying to achieve here?