Your code may be generating temp tables even you are not explicitely...

Run these procedures one by one in QA after enabling the query plan and see which part of the...

Your date starts at the same position in all columns so you can use SUBSTRING and CONVERT functions to get the date data...

declare @string Varchar(1000)

select  @string = '0600000000 0.030000 0...

Most of the times GUI will not work as it suppose to be...

Use DBCC SHRINKFILE command...and before running the shrinkfile command run the BACKUP LOG command if the recovery model...

What do you mean by change on publication database?

Are you trying to modify the non replicated objects?

If you are adding columns to replicated tables then you should use sp_repladdcolumn procedure...

Then copy the files to different location before shutting down pssdiag...

My guess is you are asking about schema change...

In sql 2005 you can use DDL trigger to keep track of schema changes where in 2000 there is not built in...

Only SQL server instances not ALL servers..

You guys are talking different types of replication...

I think Shamshad is refferring to merge replication and Charbel is transactional...

I think Merge replication uses these types of triggers..

Use OSQL with -L switch...

OSQL -L

I don't think ther is any build in function or procedure to do this job..

Third party tools like DBArtizan will do this job for you...

OR

YOu can write your own code...

1....

Based on sysobjects it is table it is system table exists in 2000 but not in 2005..

In 2005 I believe you can use sp_indexes_rowset_rmt procedure...

Other than job scheduling there are some feature no available in Express edition...

Check the following SQL Server 2005 Features Comparison...

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Delete and and repopulate may take more time because delete is logged operation...

You better test for optimal solution..

1. Truncate the table, drop the indexes and repopulate the using bcp/dts.

2. Truncate...

In sql server it is called IDENTITY...

Check IDENTITY property/fuction....

http://msdn2.microsoft.com/en-us/library/ms186775.aspx

http://msdn2.microsoft.com/en-us/library/ms189838.aspx

If you have Windows Firewall turned on, turn it off.

http://support.microsoft.com/kb/328306/en-us