July 15, 2005 at 10:39 am
Somehow one of my sysdtspackages tables has turned into a "user" table. Does anyone know how to change this back to a "system" table?
Thanks,
George
July 15, 2005 at 11:21 am
That's strange.
sp_configure 'allow updates', 1
reconfigure with override
update the table
reverse the first two statements.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
July 15, 2005 at 11:26 am
There is also the undocumented stored procedure sp_MS_marksystemobject.
K. Brian Kelley
@kbriankelley
July 15, 2005 at 11:41 am
Thanks Brian. Sounds like it might be exactly what I am looking for!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply