July 24, 2012 at 8:54 pm
Hi all,
i need to update a property of one of my table. Ex. update sys.tables set is_merge_published='0' where object_id='123456' when i run the query it gives an error like "Ad hoc updates to system catalogs are not allowed" then I tried with "sp_configure 'allow updates', 1 GO RECONFIGURE WITH OVERRIDE GO" but it doesnt work. im using sql server 2005.
thanks.
July 24, 2012 at 10:34 pm
Starting with SQL Server 2005 you can no longer update the system tables. like you were able to do in SQL Server 2000 and earlier.
July 25, 2012 at 2:06 am
Have you tried to remove the table from the publication?
July 25, 2012 at 2:34 am
replication has removed. but the table hang on with replication trigers so i cant remove the table
July 25, 2012 at 2:37 am
Looks like replication didnt cleanly remove all articles from the publication.
I would look through and follow this link http://support.microsoft.com/kb/324401
July 25, 2012 at 10:12 am
thanks for ur link 🙂
July 26, 2012 at 10:04 am
cox1ray (7/26/2012)
is essential to take your company’s uptime during and after the disaster. begins with the development of an urgent situation plan. The first thing is pulling together a team which includes a lead person from each department critical to getting and keeping your business running,partner that are experts in the requirements of banks can help you remain on top of regulations, compliance requirements and customer needs.
reported
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply