You need to enable advanced options before running sp_configure 'ad hoc distributed queries', 1;

sp_configure 'Show Advanced Options', 1;

Go

Reconfigure

Go

sp_configure 'ad hoc distributed queries', 1;

Go

Reconfigure

Go

If you are using SQL 2008 will...

I think that your question is very poorly worded, I have upgraded MSDE database to versions other than SQL Express. I may not be able to upgrade the engine but...

Try using the -w switch to control the width of the output.

This could also be completed using one query by joining the two tables like this,

SELECT TOP 1 Survey.job_num, Projects.[Job Number]

FROM Survey Inner join Projects on Projects.[Job Number]= Survey.job_num

ORDER BY Survey.SurveyID...

If you are using SQL 2005 you could try, I'm not sure if SQL 2000 will allow the use of a variable in the top clause.

@Top...

I think that with SQL 2000 sp_executeSQL has a limit of 4000 characters on the first parameter, so you cannot concatenate strings that will exceed this in total.

EXEC statement will allow you to...

You can use the Surface Area Configuration tools to set the remote network protocols

Hrishikesh statement will not create the stored procedure if it already exists because of the else statement, remove this and the script will work.

Why don't you give the users of that database db_datareader role and not db_datawriter role, that way the user can only access the information and not change it.  As long...

Using BCP is a good option if you are transferring all columns in the destination table otherwise the import will probably fail, it is a failing of BCP program.