Cameron (ca******@yahoo.co.uk) writes:
Using SQL data compare i get the following error message:
Could not allocate space for object '(SYSTEM table id: -701903460)' in
database 'TEMPDB' because the 'DEFAULT' filegroup is full.
The comparison is being run on one server between to databases. It has
been run several times but each time we get that error message, the
table ID number tends to change each time. We also had a problem
before where the 'TEMPDB' did not have enough space in its log file
but that was fixed by allowing the database to expand in size.
I don't really know what SQL data compare is, so I can't say why you
run out of space in tempdb. But the problem is obviously with a work
table; this is why you get a different id each time.
How big is your tempdb? And how big are the databases you are working
with. Unless tempdb is already excessively huge, I would enlarge it.
Else you may have to review the indexes on the tables, so that SQL Server
does not have to create the work tables. I assume that the data compare is
some vendor product, and that you cannot enhance it as such.
--
Erland Sommarskog, SQL Server MVP,
es****@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp