Try the following...

declare @sciid int

select @sciid = 0

while 1 = 1

begin

update city top (1) sciid = @sciid + 1 where sciid is null

if @@rowcount = 0 break

select @sciid + 1

end

You can write the header information to a different txt file then you can merge both txt file into one...

I beleive merging is simple...

I don't think there is any fix within the sql...

But how it got half of the original image...sql will not shrink then who did?

If there is an option I will prefer tempdb with raid 10 and see the reason to create more than 1 file in the following article...

http://support.microsoft.com/kb/328551

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/tempdb_capacity_planning_index.mspx

http://blogs.msdn.com/sqlcat/archive/2005/11/21/495440.aspx

If you want to copy the data from one database to another database on the same server you don't need to use dts package...

It can be done using TSQL...

Insert into...

I don't think you use local variables in the view...

1. Move Dev2 login to 2005 server using sp_help_revlogin.

2. Backup the sql 2000 user database and restore on to sql 2005.

Or

Dettach the database manually using sp_dettachdb command and copy the...

If it is inplace upgrade you upgrade distributor first then publisher and susbcriber...

If you are doing side by side upgrade it is better to create replication script in sql 2000...

Did you confguration sql agent mail?

You need to enable mail profile in sql agent properties...

Make sure there is no access issue...

Looks like your SSMS got corrupted...Try unistall and resintalling work station componenst on the laptop...

March update means SP2 hotfix? I think that hotfix is...

I don't think there is any issue with coexistance of sql server 2000 and 2005...

Job status available in msdb..sysjobhistory table but I don't think SUSPENDED status exists...

You see the SUSPENDED status in sysprocesses table...

If the job status is in progress find the SPID of...

Check SQLCMD/osql utility with L switch

Qualify view with schema/owner...

Try

CREATE DATABASE FOR ATTACH_REBUILD_LOG option...

See BOL for details...

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