Not going to provide you with a full working script, but only some directions...

make use of:

syslogins

syspermissions

sys.database_permissions

sysusers

I can only think of running it on Mirrored Drives, which I would never recommend for performance.

SQL replication/mirroring will as you said replicate the changes to the databases.

Because the mdf...

Why? If it's a local DB instance on each machine, and each user is in control of the...

Try Microsoft's tool, SSMA, I've used it for several migrations without issues.

http://www.microsoft.com/sqlserver/2005/en/us/migration-sybase.aspx

Thanks for the question...these RAID questions are nice, they let you think a bit 😉

Try Microsoft's Migration assistant tool, I've used it for several migrations, you might need to do some manual changes, but overall a great tool..

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9dfb1773-5594-44a9-869f-a891629f80a5&displaylang=en

Got it right, but was a bit confusing, as I agree that there are multiple correct answers.

connect using the ip or ".", then in a query run SELECT @@SERVERNAME.

is this name the same as your host?

Make sure all three nodes are configured in Windows Clustering, that all three have potential access to the shared disks, the quorum being essential.

In your setup, you should be able...

http://msdn.microsoft.com/en-us/library/ms176064.aspx

Good question...had a related question in the 70-450 exam last month.

Coming to Melbourne (from South Africa) on Sunday for 2.5 weeks...business trip..

Anything you can recommend I do/see while I am there?

Nice article, thank you Roy.

you must DECLARE variables, and no comma's after each.

try it as:

ALTER PROCEDURE [dbo].[SP_EMP]

DECLARE @STARTDATE DATETIME

DECLARE @ENDDATE DATETIME

DECLARE @STARTDATE2 DATETIME

SET @STARTDATE2=DATEADD(yy, 1, @STARTDATE)

select DATEADD(yy,1,getdate())

this statement will add 1 year to getdate().

yy indicates you are adding years, 1 is the amount of years.

for your SP and script...use this sort of method:

declare @d datetime

set...