Thanks Jack, while we're on the 2008 subject. I've once heard that there is a "free" upgrade path from 2005 standard to 2008 standard. Is that a myth,...

Any recommended products from your experience?

Wow thanks Perry. This is something we are just exploring at the moment, we have nothing setup.. My client wants to build the best DR plan possible for...

If there's only 1 VM setup on the server, no competing software whatsoever, is there any noticable performance degradation (anything above let's say 5-10%)?

This is an idea I have. It seems fair and truly random. Let me know what you think.

insert into #temp

Select top 100 id, value from baseTable order by...

Just add the code in the after_insert event and synchronise the logins within the application.

Other option is to add a job that works the logins. Then run that job...

What type of trigger are you using?

Also why are you trying to do this?

DB means db engine

CI means case insensitive

BI means business intelligence

X64 is for 64 bits

I have no idea what LT means (maybe has something to do with ETL (SSIS) but that's...

Here's the download page for all the versions fo AdventureWorks

http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Seems to me like you need to go with analysis services here and show them how to use it to run reports (on there own sandbox server). That way...

jeffrey yao (10/25/2008)

---

I see what proposed in the article is an overkill most of time in SQL2K5 EE. For DB side rollback, is there anything better/quicker than the database snapshot?...

Have you tried the same trick using a view?

Geek101, You better post that question on a new thread, you're far more likely to get help that way.

Stupid question here... but what happens if you reverse the order of the servers just after creating the migration scripts?

Doesn't that help you create the rollback scripts.

I'm sure it won't...

I don't know if it's possible, but to repair the framgentation problems, you need to defrag the drive with the DB detached (otherwise defrag won't touch those files). If...