When your solution works as required, there is no need to change it. If you want to get rid of the scheduled task: in your scenario SSIS has to be...

I'm sorry, but I don't have the time to provide a answer/sample.

I can give you a hint though: probably you can use the COUNT to see how many scores are...

Can you tell which of the indexes (which index_id) are missing?

I am also very curious about how other think about this.

Recently a company asked my advice on this. After consulting some of my collegues, we decided to follow Microsoft's statement...

Microsoft has a website for troubleshooting Database Mail

http://msdn.microsoft.com/nl-nl/library/ms188663(en-us).aspx

No, Database Mail is not available in SQL Server 2005 Express Edition.

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