The title of this article is "Its not yours".  While I definitely agree with that, I'm the DBA for the company I work for.  That means that I'm charged with...

You can certainly do this with OUTPUT or MERGE.... the trick is that you need something in your insert to be common with the original table you're inserting from and...

Agreed.  I've reported this as a "Terms of use" violation for possible plagiarism.  It explains a lot about several of this user's recent posts not having any decent information about...

The other issue is of a huge concern and generally a huge PITA for users and that can all be described in a simple, very well worn statement...

"Change...

Ah... and to add to that, shrinking a file or a database causes a type of fragmentation that can actually cripple the database.  If you shrink a file or a...

While I agree that people need to review any and all code they get from the internet, I have to tell you that if you drop someone's version of sp_help_revlogin,...

Thanks for posting a script but, when you make claims like a script being "smart" or that it will "make your work easier", you really need to include some more...