On the other hand I have been known to crunch mints one after another when everything has gone 'Pete Tong'.  I can get throught packets in a day

Don't be daft...........CHOCOLATE!!

Dear all

Thanks for keeping going whilst I was on my Christmas break.  We are nearly there!  The programmer is re-writing the old code so I will need to check...

We delved further with this and discovered that it was the old issue; American dates versus English dates.  The programmer re-wrote the select statement.  This got him pass the error...

Logging on to the network as a generic NT login worked and we could then change the owner of the dts packages.  However, to do any work on these transfered...

The programmer ran the code

The actual query (VB replaced) is

SELECT * FROM rai_ProbIdea where ((handler = 'ACFO(FS)') and ((status <> 'DECISION') and (status <> 'INAPPROPRIATE') and (DATEDIFF(d, CONVERT(datetime,...

I shall discuss with the programmer soonest; he's got someone with him and I haven't got a clue what it is supposed to show. 

I stick to DBA; originally the...

The statement is:

rs.open"SELECT * FROM rai_ProbIdea where (("&filter&" = '"&SearchOn&"') and ((status <> 'DECISION') and (status...

Further delving in the woodwork has revealed that sp_reassign_dtspackageowner requires 3 parameters.  @Name being the name of the dts package, @id being the unique identifier (you can obtain this from...

We have found the undocumented stored procedures in msdb called sp_reassign_dtspackage owner.  It has three parameters of 'name', 'id' and 'new name'.

I have run this with the correct names and...

Are you not sure that your previous life wasn't better???

I would have favoured doing a backup of the original database to a device, copying the device across to the new location and then doing a restore rather than simply copying...

I would be curious about this scenario as well.  I have a case where MS Access is being used to access SQL Server in order to download information for an...

No problem.  At least next time (and there is always a next time) you will be prepared and know what does and doesn't work.

Is this problem sorted?  I haven't heard for a couple of days and I'm curious as to why this problem happened.