When upgrading a database from MSDE to Visual Studio 2005 Express, I've noticed that the system tables in the MSDB database don't get upgraded. For example, the SYSSCHEDULES table doesn't get added. Is this by design or a bug?
-Doug
Belatedly moving this thread to the Express forum for an answer.|||Given that there is no SQL Agent support in Express this may well be by design
|||Hi Doug,
This has been addressed in SP1, which you can get from http://msdn.microsoft.com/vstudio/express/sql/download.
Regards,
Mike Wachal
SQL Express team
Mark the best posts as Answers!
|||I did find a fix to this problem. If I run the INSTMSDB.SQL script from the install directory on the updgraded database, it will install all of the new MSDB system tables.
No comments:
Post a Comment