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)
http://www.deploymentresearch.com/Blog/tabid/62/EntryId/24/Generate-Computernames-in-MDT-2010-based-on-prefix-and-a-sequencenumber.aspx
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….
UPDATE 23.08.2012:
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
Great info!
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.
# UPDATE:
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
We removed these fields as SMS 2003 hasn’t been supported for several years. That just means that they won’t be present in newly-created databases; we won’t remove them from any previously-created databases.
Thank you for confirming my “finding” Michael. And thank you for Reading Our blog. 🙂
I published the complete MDT Database history with all new and deprecated settings since MDT 2008 Update 1 at MDT Database Version History. Might be useful for you and other hardcore deployment guys 😉
This is very useful Maik.
Thank you for Reading Our blog, and I love your webservices. I use it all the time. 🙂