Noel, you certainly found it!!!!!!  That did the trick.  Thanks a million.

No permission problem.  I asked one of the other adminstrators to create a table in the master DB and it failed as well with the same error.

I'll let you know...

Not sure yet.  The DBA is looking into that restore process.  Every minute or so it tries to restore a DB. This probably looks some systemtables.

Follow up

I found out that another process is continuously trying to restore a DB.  This is probably causing the weird behaviour.

Thanks for the quick replies.

Peter

I used

--------------------

use master

Select Name, XType, user_name(uid) as Owner from dbo.SysObjects where name like '%test1%'

--------------------------

I also tried to create a table called 'abracadabra' (that certainly does not exist) but it failed...

-----

use master

CREATE TABLE [test1] (

 [pk] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

------

Nothing else.  Very strange.

Ok - I ran the following command in QA

use master

CREATE TABLE [test1] (

 [pk] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]

GO

Server: Msg 2714, Level 16, State 6, Line 1

There is...

further info

I cannot create any table in the master DB.

I always get the error message

'test' table

- Unable to create table. 

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]There is already...

The migration tool seems to create temporary tables in the master DB.

I have no idea which account was used to create this table.  I'm not even sure whether the object really exists...

Probably the best solution. But I'll use a function instead of a stored procedure.

Thanks,

Peter

Jeremy. Your solution is very similar to using a cursor.

My solution was:

==============================

declare @MaxValue as int

Select @maxValue = Max(*) from SoldItems

SELECT IDENTITY(int, 1,1) AS ID_Num

INTO ##SoldItemsTemp

FROM SoldItemsImport

Insert into SoldItems

select ID_Num...

Brokenrulz,

I cannot change table "soldItems". This table is generated by a third party application.

Jeremy,

The problem is not selecting the items from SoldItemsImport. I need all the rows from...

Hi Frank,

I have the .Net framework installed. Any ideas?

I tried to use it but got an error message "request failed".

Thanks for the replies. I'll look into the solutions mentioned. I thought of another one myself. I could create an XML file and do a bulkupload via...