There is a link on the above mentioned page but just in case you miss it DTS Backup 2000 is a free utility to transfer and backup DTS Packages. A...

I guess I had two problems

Firstly the default instance of SQL Server used the machine name rather than the DNS name.

I solved this by getting the machine name renamed to...

"If you get 5 then you didn't type it in correctly. There are four blanks in total, two at the start and two at the end"

Actually I copied it and...

I promise you I get 5 on my PC !!!!!

I pasted the code into QA and the result was 5.

It suddenly occurred to me that I might resolve the problem by changing the machine name to the DNS name. Sure enough it solved the problem. I can now connect...

I wish it was as easy as just restoring the database.

In view of the struggle I am having in restoring Master to a new instance and lack of an answer...

Thanks for the reply.

I can not stop the Production server so have to use the second option.

The default instance on the development server is a copy of production...

Hoping for an answer to my earlier email?!

Brendthess, thanks, that must be what I am looking for.

Presumably I need to use something similar when I restore msdb, model and and the user databases.

I have removed the instance...

This is what I used to restore Master on the new instance. Hope you can advise where I have gone wrong.

USE MASTER

GO

RESTORE DATABASE MASTER

FROM DISK = '\\ihqs60d1\salesdata$\knowledgebase\Backup\master\master_db_200311140100.BAK'

GO

After you have set the Excel sheet up, create two SQL Tasks. The first to drop the table (Excel worksheet) the second to create the table (Excel worksheet).

You can copy...

I am using the function below to convert to Proper Case.

--**********************************************************

CREATE FUNCTION ProperCase

(@STRING AS VARCHAR(8000))

RETURNS VARCHAR(8000)

AS

BEGIN

DECLARE @tstring VARCHAR(8000)

DECLARE @trimmed VARCHAR(8000)

DECLARE @index INT

SELECT @trimmed = RTRIM(LTRIM(@STRING))

If @trimmed...

I don't think this is the problem. The DTS Package was created on the same PC as the Server and the job. Both my id and the account used to...

I think I got a sort of answer from my ISP. They blocked various ISP's because spam was coming from users on that ISP.

They seem to think they were doing...