Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    1

    Unanswered: please help -- 512 error when generating replication script

    Hi,


    I'm trying to script out my replication objects using
    the 'Generate SQL Script...' option under Tools >
    Replication in Enterprise Manager. Under 'Replication
    components to script', I check 'Distributor properties'
    and 'Publications in these databases:' and choose all
    databases listed. I get a 512 error:

    Error 512: Subquery returned more than 1 value. This is
    not permitted when the subquery follows =, !=, <, <=, >,
    >= or when the subquery is used as an expression.

    The server is 2000 sp2, and the Ent Mgr client is 2000.
    Using the same Ent Mgr client to script replication
    objects in other 2000 sp2 servers, I don't receive any
    errors.

    I appreciate any help you can provide.

    Thanks,
    LB
    .

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Try scripting individually.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •