Hi

Just remove bulit\administrator account from login.

Hi

You dont wont to loss any functionality after upgrade to SQL 2008 R2. SQL functionality are depending SQL server editions only not OS. You do not worry about...

Hi

You can remove build in administrator account and add your own windows authentication. Now no one can access your server other than you.

Hi

It is SQL server management studio. We need to register SSMS once upgrade is completed.

Hi

you can achieve this using below method

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks2008R2 Administrator',

@recipients = 'danw@Adventure-Works.com',

@query = 'SELECT COUNT(*) FROM AdventureWorks2008R2.Production.WorkOrder

...