Either turn on casade deletes so that the foreign key refernce row is deleted as well, or delete the foreign row first.

This needs to be done with cautioin...

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...