Check the permissions of the stored proc that the application cannot find, it may have the View Definition permission denied.

Do you have a seperate server for your 2005 install ?

is this the same server as express was running on?

Run a server side trace , have a look at what excatly is casuing the problems and start from there.

Store the url as a varchar(250) or nvarchar(250) if needed.

Either insert the data via a stored proc, or via your front-end application using paramerized sql.

No, it is not possible to restore 2005 --> 2000

Under the maintenance clean up task,

you can search a folder and delete based on the extension.

Enter the UNC path for your folder on your D drive..

Automate this task to...

use a maintanence plan for clean up tasks

Under Management --> Maintenance Plans..

If you have last nights backup , then a restore of this would be easiest and you will know that everything has been copied over .

The best way to move the stored procedures across, is to right click on the database and click on tasks--> generate scripts

Use this to create the scripts for your...

There are some good third party tools out there to document the database, Redgate has one I use all the time..

For a jpg of your DB diagram you can...

I havent tried this before,

but have you thought about creating a job that runs each night and changes the permissions for those users to DENY, and then...

Are there any error codes listed under that statement;

eg. Error: 18456, Severity: 14, State: 8.

this will tell you why the login failed

Have a look at the error log in SSMS , under Management --> SQL Server Logs, and see what errors that has thrown, this should give you better information.

I usually avoid excel imports if possible for these very reasons, are you able to save the spreadsheet as CSV and import from there. would save a lot...

Try setting them to TEXT and then doing modify the datatypes once you have imported it