Use this code to see all the mails generated by Database Mail. Perhaps the status will inform you for where to look.

USE msdb ;

GO

-- show a list of all mail-items

SELECT...

Use convert(varchar, getdate(), 112)

Change the number (112) to display/use the date to your needs (see BOL on CONVERT)

You can find manual to enable and configure database-mail in BOL.

Basicly it comes down to:

1) On the SQL server: Enable 'SQL Mail' using the 'SQL Server 2005 Surface Area Configuration'

2)...

After configuring Database mail you can use the SP sp_send_dbmail to send an email. (See also BOL)

Did you create an operator and add this to the job?

SQL 2005 keeps track of the usage of all the queries in sys.dm_exec_query_stats. You can query this systemtable to see the usage of queries. Keep in mind that the results...

You can migrate the data without problems. When you encounter...

To check in which table(s) the duplicate rows exist, you can extract the joins from the SP to single queries and execute them seperatly.

select * from Roster where sID =...

When I applied SP2 I had the opportunity and time-window to do it off working hours. In my case I had no active users. I know it is not required...

Keep in mind that several things have changed in 2005. Check the whitepapers for the differences between 2000 and 2005. For instance many of the system tables (like sysobjects /...

Can you explain how the application is programmed to connect to the database. So: what is the connection string used by the application.

Are the users logging in to the application...

Be aware that proper permissions needs to be set on two places. First is as share-permissions (when creating the share) and second in the security tab for the access-permissions.

Check the...

I see several other posters allready beat me to it...

there are several system tables that contain the required info.

Example:

select * from sys.database_files

select * from sys.filegroups

It is an "Operation System Error". That implies the location is not accessable. Either because you don't have accessrights, or because the location doesn't exist / isn't available.