I covered this topic in an article on Simple-Talk. You can actually calculate the order using TSQL.

https://www.simple-talk.com/sql/t-sql-programming/database-deployment-the-bits---getting-data-in/

If I remember rightly, I believe that there is an error message event in SMO that you can attach a listener to in order to get scripting errors.

I'd always wondered what that script option did. I'm still not really sure, even after you've so kindly explained it. Does it mean' over-ride all the settings you've laboriously made...

as if to prove my point, Joomlart.com crashes and burns due to the fact that they kept their passwords in plain text, without any encryption or access control.

http://www.joomlart.com/blog/news-updates/emergency-we-are-hacked-and-database-compromised

It is sad...

@matt-2. Yes, true. Nobody in IT should ever be 'indispensable'. Even if one finds the thought of being mortal as ridiculous, keeping the documentation up-to-date means tranquil holidays. That's good...

@gary

Hmm. Yes, I missed that one. Good point.

There isn't much wrong with the code actually. You were close. Actually, you need an array of hashtables, one of which needs an array to hold the services. This object,...

Just out of interest, This is possibly a lot more difficult to understand, but shorter. (the same code will detect the nth day you specify. I just stripped it down...

This looks excellent. Thanks so much. I can't wait to try it out.

I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion of the candidates....

If you are a CIO/IT Director trying to avoid committing to the latest BIG THING, hiring a consultant or two can prove to be a good strategy. Unless the consultant...

@Sergei

Please correct me if I'm wrong but I'd always believed a primary key was enforced by a constraint which was implemented by means of both a UNIQUE index and...

@PurpleLady

arggg... I knew the answer - it's not an index, but creating a primary key does create a corresponding index (if it doesn't already exist). I better cut back on...

In addition to what's been said: In...

Thanks. The reason I felt motivated to enter it as a QOTD was that I became intrigued by the way that constraints were recorded...