Viewing 3 posts - 1 through 3 (of 3 total)
In SQL 2005 and 2008 use
Select * from sys.database_files
Select * from sys.master_files
July 1, 2010 at 11:49 pm
#1188006
Check that your tempdb is not set as 1MB default and increase the tempdb size to a reasonable size.
March 31, 2010 at 6:42 am
#1143032
I guess the tables are small ( records <10000). If yes resnapshot the publication and you will be all set.
April 14, 2008 at 9:14 am
#802123