Jim,

Thank you! I did consider sharing my choices at some length when writing the article, however, I decided not to in the end, because there are so many variables involved,...

Thanks for the compliment TSG. Not sure how they can do this, as the dynamic SQL that SQL Server 2000 Enterprise Manager kicks off to get the database details is...

Thanks for the comments guys, useful feedback like this is always much appreciated.

Unfortunately, yes, scripting of the table & stored proc security permissions does seem to be a limitation of...

Excellent article Brian, and one which applied equally to sysadmins and security managers. Highlights too the failings of auditors, who all too often seem to only be after ticks in...

Declan, Michael,

I can't comment on your experiences of the companies involved as I've not personally had dealings with them or their products.

However, from a "usefulness to other DBAs and developers"...

Nice one Steve, I enjoyed that. Short, sweet, to the point and relevant. Also makes a change to the totally technical stuff that SSC specialies in (that's not a criticism...

Very nice Alzdba, wasn't aware of SCPTXFR

Try this one too if you fancy doing some SQLDMO coding:

http://msdn.microsoft.com/msdnmag/issues/01/05/sqldmo/default.aspx

Pleasure, if I discover a better way, I'll post back here and let you know.

Aspurr,

Good point Vidas, but you might want to script the structure only, for source control reasons or to satisfy audit requirements. If you've got a 50Gb database it might...

Many thanks Frank, Antares. Must admit I've seen a few copies of the Pinnacle publication some years back, and I thought that SQL Server Magazine was the better buy, so...

Greg,

I believe the Developer Edition will have all of the features of the Enterprise Edition, but with the development only licensing restrictions, as per SQL Server 2000.

Thanks Kishore, I didn't know you could do it through EM, I'd always used QA previously. As an aside, it's not possible to even copy an .mdf/.ldf of an attached...

Woah, stop right there.

Yes it can be attached without a log file.  Kishore is correct in stating that sp_attach_single_file_db can be used to attach an .mdf file without a matching...

David,

My own experience says that if your database files are on the same data and log volumes as each other, it's probably a good idea to stagger the maintenance plans...

Just to add to what Frank's already stated:

Say if i build my mdf database in SQL server developer edition, load data, test data, run queries. Then send the mdf and...