By default the express edition of SQL Server, you have a named instance. I believe it's SQLEXPRESS, which means the name is [machine name]\SQLEXPRESS and you will need to use...

I'm not big on Wikis either, and I'm concerned about ending up settling battles between people that argue back and forth on a topic.

Wiki sounds good until people start to...

xp_cmdshell or an Agent Job.

T-SQL works within the server. It cannot see anything outside of the SQL service without a shell like xp_cmdshell.

You would use the same commands that you...

There may be some resources for free, but almost all exam related books cost money. Authors work hard to build these books and you ought to pay them for their...

Well it's 9:56pm, Wed night, and I'm finally getting to this, after a busy day. I did get time off to run, run the kids around, karate, so it hasn't...

My pleasure. I don't like to give the whole answer until you've had a chance to try it, but if you get stuck, post what you've got and we'll help...

No, no issue in general, but if you have code in your trigger that is v7 specific, it might be an issue.

Moved to SQL 2000. Please post in the appropriate...

I had to read it 3 or 4 times to make sure I wasn't missing something. Is the logic for estimation really that hard?

Calculate the 2nd Friday in T-SQL. It's not a hard algorithm, but you need to work through the possible range of days and check the date.

So if you can do...

it's a time and bandwidth issue.

If it takes 10 hours to copy, the secondary is then "backup time" + 10 hours + restore time = time behind primary when you...

I've got a better one.

Made me laugh

I believe that CALs need to be upgraded along with the server.

You'd be better off doing this in Powershell or VBScript and calling the script from T-SQL if you need to.

Really? You have 15GB in 5 days. Can't you do the estimate for a year?

15GB * (365/5) = xxGB

Why a new instance? You'll be really juggling memory between them. Why not add a database for the new app?