ok how big is your database? are you going to be replicating everything or a sub section of the database?

I think you are better using Snapshot replication based on your...

How to Shrink TempDB

I think this is being made to look more complicated than it is...

Create a blank test database - a suggestion would be to not call it production_nameTest as they...

or leave the compatibility to 90?

Rather than working around the problem why not just fix up the data?

Is there a primary Key on the table as from the 2 rows youve provided the only key...

try this:

EXEC sp_replicationdboption @dbname = N'MCSTST7', @optname = N'publish', @value = N'True'

If not, i would wipe the whole replication by right clicking the publication in SSMS and deleting it. This...

Ok several questions above but i will try to disect a little. Just as a side point - why dont you create a test instance(s) and try out your questions?

answer...

Can you give more details about your setup?

@david-2 Levy - thanks for keeping this topic alive and for your suggestion. I will try this when(!) i come across the issue again.

Yea - this is what i have suggested - SP3 - will take the user to 9.00.4035 which is good enough and tested client version for using sql 2008 instances.

Thanks.. i must be going blind. thought i checked Help tab and couldnt find the 'About' section.

His version is base 2005 - 9.00.1399 so i think the client tools need...

The log shrinks fine but the data file doesnt change in size

This doesnt work for me - ive tried the checkpointing option before.

Thanks anyway

Hi,

I ran updateusage against tempdb and it didnt resolve the minus free space issue.

Im a bit baffled about it all - a friend mentioned that it may be because the...

I know that tempdb can get currupted and i have read the various Ms kb articles. I wouldnt be doing this during the day, but the transaction that caused the...