Unless your running Enterprise or Data Center editions of your Server OS

Are you still having issues with the Berlin and London domains, if you have any more details relating to specifice AD issues post them here and i'll see if one...

Tip 1 don't use select *

Edit, ok make that Tip 2

you can also use sp_changedbowner but remember to 'use database_name' first!

I don't know why you wouldn't if you've put that much time and effort into it, SQL Server 2008 is going to be around for a very long time yet...

The firebrand training course will be very intensive and I would only reccomend that you do something like this once you have had some experience, do some reading and get...

In report server configuration have you checked the 'specify an execution account' box?

The publisher and distributer are typically on the same instance, in this case the subscriber is the later version which is ok or have I read the setup the wrong...

Please post a reply letting me know how it goes, and good luck!

Don't see any problem with that

to move temp db use:

Use Master

go

alter database tempdb

modify file (name = tempdev, filename = 'Drive:\folder\folder\tempdb.mdf');

go

alter database tempdb

modify file (name = templog, filename = 'Drive:\folder\folder\templog.ldf');

go

Setting a static port will not impact you applications ability to use a servername\instance connection string if the SQL browser service is running

think your getting confused with the log file name and the physical log file name

also check out the Microsoft security bulletin (released on the second Tuesday of every month) http://technet.microsoft.com/en-us/security/bulletin/advance

Edit: patches here are usually aimed more at your server admins but its...

periodically read the SQL Server Release blog at http://blogs.msdn.com/b/sqlreleaseservices/ to keep up with any updates...