Stumbled over something interesting here the other day. It seems that when you create a DB in MDT 2012 Update 1 there are some attributes that are gone. I could not find anything written about this in the MDT documentation. The attributes I am talking about is the SMS 2003 OSD attributes.
When you create a MDT database using MDT 2012 (not update 1), the attributes are there. If you upgrade to MDT 2012 Update 1 the attributes are there still. But if you create a new database after you are running MDT 2012 Update 1, the attributes are not there. The reason I stumbled over this was because of Johan’s Computer name generating Stored Procedure. (A great solution by the way, I love it)
His default Stored procedure uses OSDInstallSilent=1 . If you try to import it , it will give the message: invalid column name ‘OSDInstallSilent’.
So how do we fix this? Just change the code from this:
To this (just remove OSDInstallSilent and ‘1’:
Than execute it and Voila, you should now have a working Stored Procedure for name generating purposes in MDT 2012 Update 1.
These variables are legacy ,so maybe this is good riddance anyway. Thought it could be interesting to know for the hardcore deployment guys….
A comment from Michael Niehaus confirms this finding. See in the comments for this post.
UPDATE #2 23.08.2012:
Maik Koster has a complete table of the database version history starting from MDT 2008 Update 1. Read his excellent post about this. http://myitforum.com/cs2/blogs/maikkoster/archive/2012/08/23/mdt-database-version-history.aspx
And a direct link to MDT Database version history here: http://mdtwebfrontend.codeplex.com/wikipage?title=MDT%20Database%20version%20history
UPDATE #3 23.08.2012:
Informations flows fast today. Maik made a comment about what he published. I must say, this is really a great documentation.
Michael Niehaus has written a blog post on this subject here: http://blogs.technet.com/b/mniehaus/archive/2012/09/09/database-changes-in-mdt-2012-and-mdt-2012-update-1.aspx