use a select script to generate an insert script for each row in the table and coupled with a create table script you have your table in portable format

as i said above, you can play to your hearts content without fear of retribution. Mojo pointed out the...

thank you for all the +ve comments, i just hope this is useful to you all somehow. Its great for testing and if you blow away the cluster you dont...

thanks for your reply. The document does specify you should only use for test\educational purposes and that options such as VMWare HA make this redundant. Its more for people who...

have you tried running it from the DVD?

where are you running the setup from CD, HDD, etc?

this should do it

select [name] as [DB Name], SUSER_SNAME([owner_sid]) AS [DBOwner] from sys.databases

order by 1

Hi

passive nodes first, check this link for further details

that is correct

the 2 biggest differences between std and ent are online index rebuilding and partitioning. Also AFAIK page level restores are only available in sql2005 ent

also, if i remember correctly truncate will reset any seed\incremental value on ID columns,etc

yes, i thought of that but running it through SSMS the query takes a short while and thats just on my laptop. Imagine on a server with 4 or more...

RBarryYoung (4/13/2009)

---

I apologize, but unfortunately, because of conflicts between VS 2005/.net 2.0 and VS 2008/.net 3.5, my SMO dev environment is down right now so I cannot effectively test anything.

I...

this should cut down on the amount of procedures returned

select 'exec sp_helptext ' + name from sys.objects where type = 'P'

and is_ms_shipped <> 1

order by name

you dont want...

presumably you are using sql2005 standard x64?

you may want to set the min memory to something sensible!