March 7, 2003 at 5:32 am
In our development server, I just noticed that:
System Stored Procedure have been changed from Type "System" to Type "User".
These are namely - dt_addtosourcecontrol, dt_addtosourcecontrol_u, etc, etc
Can someone please help me determine, how these can posssibly be changed?
What are the impact of the changes?
What permissions does one need to carry these out?
How do we make the changes over again?
March 7, 2003 at 9:30 am
Not sure how it can be changed, but this should be no impact to the use. Are they still owned by dbo?
It should be sysadmin only. I suspect that someone connecting and installing some development tool might have altered these.
there is a way to change this back, can't find it right now. Perhaps someone else will chime in.
Steve Jones
March 7, 2003 at 9:46 am
EXEC sp_MS_marksystemobject @objname = '???' should be able to marks them back as system objects...
Tim C.
//Will write code for food
Tim C //Will code for food
March 7, 2003 at 9:02 pm
Hello Steve & Tim.
Thank you for u'r feedback.
The undocumented stored procedure "sp_MS_marksystemobject" helped me make the change over.
However, I did not observe any impact after the objects had been changed from System to User.
All objects are owned by the "dbo"
Also, found "sp_MS_upd_sysobj_category" useful
Thanks
NRK
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply