Not sure I agree 1GB is too little RAM. I've run small servers on it fine. However more is definitely better.

I do think you want to do some comprehensive analysis...

SS2K8 will "launch" in Feb with Windows 2008 and VS2008. However I'm hearing Q2 for the actual bits to RTM. My guess is we'll see the bits at TechEd, first...

I'm not a MetaFrame expert, been years since I worked with one. However moving a data store should be no different than with any app.

The thing you'll want to do...

Nice to see I'm not the only one having issues with estimates. Todd has a nice comment above and I tend to agree with it. With small changes, the overhead...

Aside from what John said, can you better explain what is inserted into each table and when? (order). Also, what relationships you have?

Typically you insert into the parent tables. Then...

Be careful with switching modes. Don't want to mess up your backup chain.

Never heard it called an asynchronous trigger, and don't think it should be. We have enough triggers now!

But that is what it does and I agree this is a great...

Let's hope so! No one upgrade to 2005 if you don't need it. Wait for 2008!

You are welcome and please feel free to ask more questions.

Kurt,

Glad you figured it out, thanks for the update and glad we could help.

Gotta double check those network admins 🙂

A Believer!!!

I agree with Clifton completely. wait for 2008 if you can.

Be sure you have enabled the DAC from the SQL Server configuration and do it from the local console.

If you're inclined, you can switch the angled brackets to & lt ; and & gt ; (remove the spaces )

Scott,

Thanks and I'll add this to the list. Probably a low priority, but it does make some sense to see the number of votes as well as the rating.

Steve

Nice one Hugo. I like it!