Crispin..

it ran for about 12 hours then i got an error message that it was out of virtual memory.

🙁

should i just remove the 'NOT NULL' from Varchar(500) NOT NULL?

Create Table #tmpLinks(Ident INT NOT NULL IDENTITY (1, 1), LinkID INT NOT NULL, URL Varchar(500) NOT NULL)

Hi crispin i get this error message

Server: Msg 515, Level 16, State 2, Line 12

Cannot insert the value NULL into column 'URL', table 'tempdb.dbo.#tmpLinks___________________________________________________________________________________________________________00000000009F'; column does not allow nulls. INSERT...

i guess not...

would it be possible to change the datatype at the moment then... with out affecting anything?

NVarchars were used to let all languages and symbols to be used..

Hi Crispin below is the structure of our database, how would the code change for this table, if at all?

and do i just run it in the SQL query analyser?

CREATE...

Crispin,

thats looks like double dutch to me..

can you give me more of a description, especially as to how i run that code.

appreciate the help 🙂

michael.

Crispin examples would be magic..

the database is with a hosting company on their server.

thanks

Michael