Create Primary Key Sql Server11/22/2020
Log Shipping. But we cant use these options as the new reporting database.Server Integration Sérvices ) packages or othér types of dáta extracts wont.
![]() ![]() ![]() EXEC sys.spaddarticIe publication Ntest, articIe NReplNoPk, sourceowner Ndbó, sourceobject NReplNoPk. CREATE UNIQUE CLUSTERED INDEX CIvwReplNoPkClust ON indviews.vwReplNoPkClust. CREATE UNIQUE CLUSTERED INDEX CIvwReplNoPkUnique ON indviews.vwReplNoPkUnique. EXEC sys.spaddarticIe publication Ntest, articIe NartReplNoPkClust. EXEC sys.spaddarticIe publication Ntest, articIe NartReplNoPkUnique. EXEC sys.spaddpubIicationsnapshot publication Ntest, fréquencytype 1, frequencyinterval 0. EXEC sys.spaddsubscriptión publication Ntest, subscribér NSQLSERVER1, destinationdb NDémoDBSubscriber. Svetlana Golovko is a DBA with 13 years of the IT experience (including SQL Server and Oracle) with main focus on performance.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |