October 25, 2007 at 7:24 am
Guys,
A develop alias is login id to dbo. I am looking for a way to set dbo login name column in sys.sysobjects view to null. Do any one has a way to upadate system views or table in SQL server 2005?
October 25, 2007 at 2:09 pm
I am not 100% sure but I belive that you can not change system tables in 2005 like you could in 2000.
That being said I'm also not sure I understand the purpose of what you are trying to do?
Also just an FYI this is the 7,2000 administration forum not 2005.
Kenneth Fisher
Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]
October 27, 2007 at 10:29 am
You cann't update System tables in SQL server 2005
Regards..Vidhya Sagar
SQL-Articles
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply