Refer the link below.

http://www.sql-articles.com/

You need not need to do this if yopu have your client configuration referring to the particular port in the application server. I will create an alais of the server...

Other possible reason could be yur firewall blocking that port which sql listens.

Check for orphan users and resolve if any. Also you need to give execute permissions if they are not given.

Check if the below script helps.

/* Script by Sugesh */

/*posted @ sqlarticles.com */

set nocount on

Print 'Column Level Privileges to the User:'

select 'grant '+privilege_type+' on '+table_schema+'.'+table_name+' ('+column_name+') to ['+grantee+']'+case IS_GRANTABLE...

You need to cahnge either your sql server or windows server collation.

Check for your connection properties.

Yes you need to do a reindex of the table after a bulk insert.

Yes there is no way a table within sql server can have owner changed by itself there is a possibility that same table is reffered by 2 users.

cpuld you please post us the name of the extended procedure that is returning in the error message.

use the SET ISOLATION LEVEL TSQL to change the isolation level property to the one you desire.

In the database in SQL 2000 check if there is a column which has a 'space' in it. the error looks there is such a column and is failing out...

The best option is to do this in a non-production time. disable the replication do the reindexing.

You can have a look at the link given below

http://www.sql-articles.com/

Possibly no. You need to reinstall the server with the right collation.