Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can not modify table properties (Urgent) Expand / Collapse
Author
Message
Posted Tuesday, July 24, 2012 8:54 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:42 PM
Points: 22, Visits: 126
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.
Post #1334877
Posted Tuesday, July 24, 2012 10:34 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:48 AM
Points: 23,227, Visits: 31,926
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.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1334889
Posted Wednesday, July 25, 2012 2:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 5,218, Visits: 5,067
Have you tried to remove the table from the publication?



Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1334951
Posted Wednesday, July 25, 2012 2:34 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:42 PM
Points: 22, Visits: 126
replication has removed. but the table hang on with replication trigers so i cant remove the table
Post #1334967
Posted Wednesday, July 25, 2012 2:37 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:20 AM
Points: 5,218, Visits: 5,067
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




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1334969
Posted Wednesday, July 25, 2012 10:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 17, 2013 10:42 PM
Points: 22, Visits: 126
thanks for ur link
Post #1335264
Posted Thursday, July 26, 2012 10:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:26 AM
Points: 13,277, Visits: 12,108
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 Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1335955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse