Worked like a charm!! Thank you so much.

no, they are on different machines and use tcp/ip.

no, i checked that. autoclose is turned off. is there maybe a way to establish a permanent or cached connection between the web server and SQL server or set SQl...

Anyone have an idea on this?

Auto-close is not checked. I do not think it is .NET. I have the same page in simple ASP and it is just as slow. And fact is that all of this...

Thanks for your help,

no, it's not DNS. I am using an IP and the ping is less than 1ms. Are there any settings in SQL serer I need to adjust,...

Works like a charm. Thank you.

the hard-coded numbers were inserted by me as I added items in the columns. The Spanish column does allow nulls, but the primary key 'ID' certainly does not. The problem...

The ID column is not an autopopulate, it is set with ascending static nmbers like, 1,2,3...

I think the error is that insert trys to append the data, instead of put...

Ok, I am new to SQL Server and DBs and I tried the following

INSERT INTO db2..mytext (Spanish)

SELECT Spanish FROM db1..mytext

However, I get the following error message:

Cannot insert the value NULL...

It worked like a charm! Thank you so much.

Thanks again.

Your script worked and showed all my tables with vachars in them.

I have about 150 tables, and they are all set up the same way. They have one column...

Thanks a lot for the replies guys. I am not so savvy with DBs. Could you please tell me a little more detailed how I can run this below script?...