Allen, thanks for the link, I did actually look at my print out of the file before asking the question.

A thought, the userid is in the Actions table so I could order the Actions on userid, build a message while the userid stayed the same. Then email this before...

I ended up recreating all the templates on the Production Server using Excel 97. This proved to be easier than I first imagined.

I created a new workbook.

Copied and...

It happened again, this time I pressed CTRL SHIFT ESC to open the Task Manager and found and killed the hidden Excel process.

It happened again, this time I pressed CTRL SHIFT ESC to open the Task Manager and found and killed the hidden Excel process.

It is easy to see the script created by Enterprise Manager.

Open a sample table, make the changes and then click on 'Save Changes Script'

See example below:

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER...

"Do you know of any process which might be using this file"

Yes I have worked out exactly which process caused the problem.

There is a job running which runs a DTS...

Why didn't I thank of that! Thanks for the lateral thinking which I will certainly bear in mind for quick fixes.

Thanks for this but are there any examples of the code required to set up and close this type of connection?

Yes this is the short term solution I have adopted except that when they report problems I tell users to use English (United Kingdom) rather than colonial slang

I guess this on the right track but I am not sure how to interpret the result. I got 36 rows starting as below.

So are you saying that irrespective of...

Found the answer re how to use INI files - Excellent tutorial:

"Updating SQL Server Connection Properties from the DTS Package INI File"

http://www.databasejournal.com/features/mssql/article.php/3073161

The next step I guess is to...

"I ended up programming something in C# to use the DTS COM"

Unfortunately I can not program in C#.

"You could use an INI file or something like it to read...

If I have say 20 independent packages, does this mean that I have to change 20 lots of global variables every time I move the packages to a new instance.

I tried WITH MOVE option:

RESTORE DATABASE [KbUserTrial] FROM DISK = N'C:\temp\temp2.bak' WITH REPLACE,

MOVE 'KB1_Data' TO 'C:\KnowledgeBase\Data\KbUserTrial.MDF',

MOVE 'KB1_Log' TO 'C:\KnowledgeBase\Data\KbUserTrial_log.MDF'

But still got a successful restore with...