If thats a non-production environment where restart the sql services is possible. set the size of MODEL database. it will be get inherited when sql gets restarted

Check both the processes(code inside job) there must be some code/ logic conflict.

thanks , can you please provide the Steve email.i haven't found it here.

Try these queries

Determining the Amount of Free Space in tempdb

SELECT SUM(unallocated_extent_page_count) AS [free pages],

(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]

FROM sys.dm_db_file_space_usage;

Determining the Longest Running Transaction

SELECT transaction_id

FROM sys.dm_tran_active_snapshot_database_transactions

ORDER BY elapsed_time_seconds...

select * from sys.traces can give you trace file path

Script out the indexes from publication side and apply on subscriber.but do these pushes in business off hours with some settings like "sot in tempdb = on", ONLINE = on...

setup the profiler and trace the queries which are causing time out. Column filter Error code : 2

Why you want to keep different schema.?

Replication strong requires same PK definition

thanks johan

defragmentation generally dosesnt work for small table (1000...

yes but you need to replace it with another appropriate...

then

Msg 15151, Level 16, State 1, Line 2

Cannot find the object 'Table', because it does not exist or you do not have permission. it...

ravisamigo (3/19/2012)

We've SQLServer 2005 logshipping configured on one of production database and the size of this db is around 1 TB. It will take more time to take the backup...

mirroring or transactional replication could be possible solution here but first database size and transaction frequency should be revealed here.

your query is returning so much of data, if optimizer is going for parallelism , i don't see any harm in it. additionally exec plan comparison can give you better...