I know of one shop that uses Red-Gate SQLCompare to create a snapshot of the production server every night and that gets checked into source control. It allows a dev environment to be refreshed from production in order to rehearse deployments.

Having the CI servers rebuild from the last deployed baseline is a very useful thing to have.Having utility procs and test procs in source control is also handy. Whenever a new server is spun up the script to do so checks out the scripts to build the utility features and executes those scripts.

Knowing that ever server has your most treasured utilities ready to hand is reassuring.

I have all my db code in version control. For some new projects, I have the database code in a visual studio project. From there, I can publish it directly to a database server. I can of course also do compares etc. The feeling of that is very nice.