http://www.sqlservercentral.com/columnists/sjones/codingstandardspart1.asp

http://www.sqlservercentral.com/columnists/sjones/codingstandardspart2formatting.asp

A separate db is overkill unless you have an already loaded machine, then you'd want a separate server as well, or you anticipate a high volume of reports that might...

It would be interesting to have some testing done. 12 hour is interesting, what about putting tempdb on it? Lots of order bys, group bys, etc, might benefit from it.

You should be able to just copy both files to a location on the new server and attach from EM.

There isn't a good way that I know of. You could script out the logins and permissions from EM, then do a search and replace. Not sure if there's a...

does sa work?

Why not remove them manually? I'm sure the server doesn't remove them in case they are user dbs that you need. People sometimes detach their dbs, uninstall, reinstall to a...

Is that a senior admin? If so, it seems low, but it might be ok in that area.

I used to randomly allot my time between projects (in corporate work), varying the amount per day, adding them up to 8 or 10 randomly. Just to make life easier....

You don't want to do this. The backup process is extremely intolerant of network delays and you'll find it failing for no apparent reason. You'd be better off backing up...

Sounds like something weird, maybe an SP (SQL) difference?

Can you save as a file and reopen on the workstation?

Haven't seen it and although I rarely reboot, it hasn't happened to me. Are you running as admin on the XP machine? Maybe they're not being saved?

yes, this was addressed a long time ago by MS.

If the users are employees, or authenticated by your AD, then you need CALs for all the employees/devices OR you can...

When a job is running, it will get put into sysjobhistory with a status. BOL lists the various status values.

I think you'd need to scan all the tables for the FKs and then somehow alter them. I'm not sure you can just add not for replication, but I could...