Note that you can mitigate the downtime by having a warm server, and restore the logs (and fulls) as they're taken.

I am still not clear what you mean. A package cannot run without being scheduled or called from some other program, so you can typically arrange a workflow.

I'm also...

If you run the package as a job, then it will be recorded. If you run it some other way, you'd need to note that. The easiest way is insert...

You could write logic into the beginning of both packages to check if the other is running. This is stored in MSDB, and you can query to determine if the...

You absolutely can start with Standard and move to Enterprise, but again, you haven't given enough information for us to decide if those features matter.

The size of the database doesn't...

I'd tend to agree with Michael. It also depends on resources and time. The updates might be spread out, whereas a reinsert tends to run at once. If you index...

LOL, no, my brother. :w00t:

Actually I have quite a few contacts and friends that I see at the PASS Summit, and rarely correspond outside of that. Amazing how much you...

Jon,

download Virtual PC, free from MS. Create a VM (walks you through it), put XP CD in CD drive, capture to VM install. It's actually very simple.

I would recommend an...

Well, thanks, and I don't think I'll be working for HCL anytime soon either!

Maybe I should send him a large quantity of posts from this forum? There are plenty of...

That's a parse, not a compile. A parse isn't a check against the existence of a table.

What's HCL?

I'm after wary of outsourcing companies since they are so cost driven as to place that above being effective. That can be frustrating.

If your CEO thinks the US is...

Write an excellent cover letter, with references as to why you will be a good employee. It might help.

SET PARSEONLY

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

What do you mean generally used? I'm sure there are plenty of people using all of them. The issue is whether they will help in your environment. For that, you...

Master is a parameter in the service startup, so what you'd do it make you have a copy of your current files. Install SQL, then change the startup parameter...