[THIN] KB: CTX111656 - SQL Replication Test Tool Version 4.2

CTX111656 - SQL Replication Test Tool Version 4.2

This document was published at: http://support.citrix.com/article/CTX111656

Document ID: *CTX111656*, Created on: Jan 24, 2007, Updated: Jan 25, 2007

Products: N/A

<http://support.citrix.com/servlet/KbServlet/download/12300-102-16174/DS%20RepCheck%204.2.zip>Attachment:
DS
RepCheck 
4.2.zip<http://support.citrix.com/servlet/KbServlet/download/12300-102-16174/DS%20RepCheck%204.2.zip>(
141.3 K)


*SQL Replication Test Tool version 4.2*

Updated Date: 11/15/2006

*Description*

The SQL Replication Test Tool is designed to troubleshoot issues with SQL
Immediate Updating Transactional Replication.

*Installing the SQL Replication Test Tool*

Create a stored procedure on the IMA subscriber database by running the
DSRepCheck stored procedure.

*How To Use the SQL Replication Test Tool*

*Note*: Remember to back up the database before running any database
utilities.

*Running the tool through Query Analyzer*:

   1. Connect to the subscriber database as the IMA user account.
   2. Set the results to text in the SQL Server Management Studio. Refer
  to the following screen shot:


   1. Issue the following command:*

  dsrepcheck <publisher_sql>,<publisher_database>*

  Where *<publisher_sql>*, is the name of the SQL server acting as the
  publisher and *<publisher_database> *is the name of the published
  database on the publisher. Refer to the following screen shot:

*Using a script*:

   1. Create a file called sql.txt with the following SQL statements
  from the example caller script contained in the .zip file attached to this
  article (CallerScript for DSRepCheck 4.1.txt).
   2. Issue the following command to execute the script through the
  command line:*

  Osql –S <> -U sa –P citrix –I c:\sql.txt >> out.txt*

*Disclaimer*

This software application is provided to you "AS IS" with no
representations, warranties or conditions of any kind. You may use and
distribute it at your own risk. CITRIX DISCLAIMS ALL WARRANTIES WHATSOEVER,
EXPRESS, IMPLIED, WRITTEN, ORAL OR STATUTORY, INCLUDING WITHOUT LIMITATION
WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, TITLE AND
NONINFRINGEMENT. Without limiting the generality of the foregoing, you
acknowledge and agree that (a) the software application may exhibit errors,
design flaws or other problems, possibly resulting in loss of data or damage
to property; (b) it may not be possible to make the software application
fully functional; and (c) Citrix may, without notice or liability to you,
cease to make available the current version and/or any future versions of
the software application. In no event should the code be used to support of
ultra-hazardous activities, including but not limited to life support or
blasting activities. NEITHER CITRIX NOR ITS AFFILIATES OR AGENTS WILL BE
LIABLE, UNDER BREACH OF CONTRACT OR ANY OTHER THEORY OF LIABILITY, FOR ANY
DAMAGES WHATSOEVER ARISING FROM USE OF THE SOFTWARE APPLICATION, INCLUDING
WITHOUT LIMITATION DIRECT, SPECIAL, INCIDENTAL, PUNITIVE, CONSEQUENTIAL OR
OTHER DAMAGES, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. You agree
to indemnify and defend Citrix against any and all claims arising from your
use, modification or distribution of the code.

--
Jim Kenzig
Microsoft MVP - Terminal Services
http://www.thinhelp.com
Citrix Technology Professional
Provision Networks VIP
CEO The Kenzig Group
http://www.kenzig.com
Blog: http://www.techblink.com

Other related posts: