August 30, 2010 at 6:46 am
Hi,
We have an audit report which says one of our dba deleted all system procedures in one of user database (sql 2000) and then re-created it. I see type for each of these proc is SYSTEM insted of USER. I also see that creation time of these procs is same as what is mentioned in the report however the dba is denying it.
I created a test database in 2005 and tried to delete system SP but it did not allow me even though i have sysadmin privilage. Can't test it out on 2000 as i do not have a 2000 test server.
Can we drop system SPs in 2000 and create them as system SPs?
August 30, 2010 at 7:50 am
Yes. You can do it in SQL Server 2000. 'allow updates' should be 1 in sp_configure and after creating the stored procedure all you have to do is modify the status column in sysobjects to "-1610612735" to make the SP as system.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
August 30, 2010 at 7:54 am
ps. (8/30/2010)
Hi,...
I created a test database in 2005 and tried to delete system SP but it did not allow me even though i have sysadmin privilage. Can't test it out on 2000 as i do not have a 2000 test server.
...
As you've experienced, SQL2005 doesn't let you mess with the systems stuff.
And that 's a good thing :w00t:
With sql2000 you could mess with all that, but sooner or later, you would run into troubles.
"Don't do it !" is the only advise.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply