Can I still modify system objects like in SQL Server 2000?
Updated: 6/20/2008 12:25:00 AM
Requests: 5470

SQL Server 2005 no longer provides a way to modify system tables and procedures. Most of the stuff you're interested in is not even stored in master anyway, but rather in the hidden database "mssqlsystemresource"...

So if you've been using this workaround in the past, you're going to have to come up with a new approach before you transition to the new version.

© 2004-2010 Aaron Bertrand, All Rights Reserved. SQL Server 2005, of course, belongs to Microsoft.