Now I can't see any of the reports that I created though. Going to the home page shows me nothing other than the home page icon and the top right...

You could use a trigger on sysjobhistory to check for a job failure (if the dts is executed from there). You can then trap the raiserror as an alert.

CREATE trigger...

You could make use the dynamic properties task to execute a query against a table holding the information for all the files.

Move the log to another drive with sufficient disk space to allow for all the inserts to happen.

Alternatively you could change the recovery model to simple, that's something you would...

Try

SET @command ='KILL ''' + cast (@uow as varchar(50)) + ''''

I've found it very helpful to create your production linked server using the SQL Server radio button and the actual linked server you will be connecting to. Then in dev...

Check out http://www.sqldts.com and look at dts loops, it describes the way the logic works and has a downloadable dts example.

There might have been a change to the command extensions which prevents pushd from using UNC paths. Check out the link from http://www.ss64.com/nt/pushd.html

I think it's a great idea, and would definately include a recommended reading portion for beginners through experts on everything.

A bit obscure this, but check the clock times on the server and the loca machine. If the clocks are out of synch by even a couple of minutes it...

The only thing you could do would be to remove the unique constraint.

declare @sql varchar(1000), @col_name varchar(10), @orderby varchar(10)

set @col_name = 'column'

set @orderby = 'desc'

set @sql = 'SELECT  c1,c2,c3,c4,c5,c6

   INTO #emp_temp1 FROM #emp_temp order by ' +@col_name+' '+@orderby

print @sql

exec...

Is it possible for you to get their admin to send you the machine specs and some perfmons of the basics (disk, cpu, memory) on the box as well as...

Aside from potential licensing issues running personal edition on a server, they could be running into memory problem, are you able to get an idea of the other processes running...

Have you done a dbcc checktable?

I'd also attempt bcping the data out, creating the indexes and then running a showcontig on that, check if you get results, if so drop...