Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account
Using T-SQL to Verify Tables Row Counts in Transactional Replication - SQLServerCentral
Audience: I assume my audience has at least some basic understanding of transactional replication Testing: This script was tested thoroughly in the transactional replication environment that has one Publisher with 10 user databases, which are all replicated to four Subscribers by 30 publications using pull subscriptions. For each article, I can obtain from table MSarticles the following information: article name, schema name, which database it is replicated from, and which publication this article belongs to
Oracle row count for all tables in schema
Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise
I changed the @sql to @sqlTables in the drop code so I could run the drop constraints and drop tables in the query (it was complaining about declaring @sql twice). Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account
flashback table in 10g
a warning on indexes and constraints When a table is dropped without purge, any additional segments "belonging" to the table (such as indexes or LOBs) are also renamed and recorded in the recycle bin. the table has row movement enabled, either by an ALTER TABLE or at the time of CREATE as in the demonstration table above; and the user performing the flashback has either the FLASHBACK ANY TABLE system privilege or the FLASHBACK grant on the target table
Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account
In such a situation, we have two alternatives: Truncate Table In this solution, we can insert the remaining data into a temporary table, truncate the original and finally insert data back in from the temporary table
Schema-Owned Tables and Generated DROP Scripts (SQL Spackle) - SQLServerCentral
More than likely Microsoft will fix this issue at this point, but until then, just remember to tweak and test rather than assuming the engine will give you the correct solution
This doesn't take care of circumstances where another table has a foreign key to the table you want to drop - in that case, you'll want to explicity drop that foreign key first
SQL Server 2008 delete all tables under special schema - Stack Overflow
e and natural logs How often do big MMORPG update the physics? How to best store a timestamp in PostgreSQL? How do I add a number at the end of every line in notepad++? How to efficiently tell workers to return minerals before going to build something in Starcraft 2? Regular Expression for words with spaces Power player is a problem. That said, the script will also try to drop views that might exist in that schema and give you an error message because you end up trying to drop a view by issuing a DROP TABLE statement
EXEC CleanUpSchema 'MySchema', 't' -- debug GO EXEC CleanupSchema 'MySchema', 'w' -- work for me These are the known limitations of the script It can not drop a PK table in the schema with an XML index or Spatial index defined It can not drop the schema which is referred by a XML schema collection Please let me know if you find any more issues with the script. Are there any particular terms for doing this? thanks, Peter Hussey LabKey Software (and former SQL Server group program manager) Reply Ranjith said: May 31, 2011 at 5:03 pm Hi Peter, Thanks for asking and I am glad to hear that its useful to you guys
No comments:
Post a Comment