Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1213
  • Last Modified:

Urgent!!!Replication problem


           I have succeeded in setting up Replication using TCP/IP without using Trusted connections in my trial environment.However in the real place I have come up with a hurdle.I am not able to see the SQL Executive of m/c A in m/c B and vice versa.I am able to ODBCPing but I am not able to start the SQL Server of remote
m/c.In fact there is no light(nored no green) and both Stop and Start are enabled.When I try to start it I get an error(Error 1722-RPC server is unavailable).
 
      When I tried to Install Publishing on the local m/c I met with failure.
 
      What am I doing wrong???
 
                  Thanks  for Ur help.
 
                                                                                                   
                                                                                                With love,
 
                                                                                                          Prathaban
                                                                                                         
 
0
prats_sr
Asked:
prats_sr
  • 9
  • 8
  • 4
1 Solution
 
aliciaamCommented:
If you have changed the Windows NT Server computer name, but not the SQL Server name, and the @@SERVERNAME variable is neither NULL nor matches the Windows NT Server computer name, you must run the sp_drop server and
sp_addserver <server name>, LOCAL commands to alter the SQL Server name.

0
 
connexCommented:
Are A and B in the same Domain?
A bit more information would be helpful. Like what client protocol is used. What Authentication-Model?

0
 
aliciaamCommented:
Make sure that network name resolution is assured. This can
be accomplished by using LMHosts lookup, DNS or WINS.

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
prats_srAuthor Commented:


  I am currently looking into the DNS resolution error possibility.

  The other problem is that I am not able to set up publishing.
I am sending the instdist.out output along.



   1> 2> 3> 4> 5> 6> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 1> 2> 3> 1> 2> 3> 4>                                                    
 ------------------ ------------------------------
 At top, db_name()= distribution                  

(1 row affected)
1> 2> 3> 4> 5> (1 row affected)
1> 2> 3> 1> 2> Configuration option changed. Run the RECONFIGURE command to install.
1> 2> 1> 2> 3> 4>  
Time established during sequence mode 1 before creates is  '1998/11/16
14:42:48' (spid=46, db=distribution)
 
1> 2> 3> 4> 5> 6> 7> 8>  
Create distribution tables
 
Msg 2812, Level 16, State 4, Server KGDENIM, Line 7
Stored procedure 'sp_create_distribution_tables' not found.
1> 2> 3> 4> 5> 6> 7> (0 rows affected)
1> 2> 3> 4> 5> 6> (1 row affected)
1> 2> 3> 4> 5> 6> 7> 8> 9> 10>  
Dropping all distribution stored procedures
 
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 6> (1 row affected)
1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> 1> 2> 3> 4> 5> (1 row affected)
1> 2> 3>  
1> 2> 3> Creating 'sp_MSdistribution_cleanup'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_cleanup, Line 18
Invalid object name 'MSsubscriber_status'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_cleanup, Line 28
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_cleanup, Line 38
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_cleanup, Line 52
Invalid object name 'MSsubscriber_status'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_cleanup, Line 52
Invalid object name 'MSsubscriber_status'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_cleanup, Line 52
Invalid object name 'MSsubscriber_status'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_replcleanup'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188> 189> 190> 191> 192> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 55
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 56
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 57
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 60
Invalid object name 'MSjob_subscriptions'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 92
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 102
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 102
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 102
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 146
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 146
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 146
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 146
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 146
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 169
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 169
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_replcleanup, Line 169
Invalid object name 'MSjobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSadd_job'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202> 203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217> 218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232> 233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247> 248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262> 263> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277> 278> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292> 293> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307> 308> 309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319> 320> 321> 322> 323> 324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334> 335> 336> 337> 338> 339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349> 350> 351> 352> 353> 354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364> 365> 366> 367> 368> 369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379> 380> 381> 382> 383> 384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394> 395> 396> 397> 398> 399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409> 410> 411> 412> 413> 414> 415> 416> 417> 418> 419> 420> 421> 422> 423> 424> 425> 426> 427> 428> 429> 430> 431> 432> 433> 434> 435> 436> 437> 438> 439> 440> 441> 442> 443> 444> 445> 446> 447> 448> 449> 450> 451> 452> 453> 454> 455> 456> 457> 458> 459> 460> 461> 462> 463> 464> 465> 466> 467> 468> 469> 470> 471> 472> 473> 474> 475> 476> 477> 478> 479> 480> 481> 482> 483> 484> 485> 486> 487> 488> 489> 490> 491> 492> 493> 494> 495> 496> 497> 498> 499> 500> 501> 502> 503> 504> 505> 506> 507> 508> 509> 510> 511> 512> 513> 514> 515> 516> 517> 518> 519> 520> 521> 522> 523> 524> 525> 526> 527> 528> 529> 530> 531> 532> 533> 534> 535> 536> 537> 538> 539> 540> 541> 542> 543> 544> 545> 546> 547> 548> 549> 550> 551> 552> 553> 554> 555> 556> 557> 558> 559> 560> 561> 562> 563> 564> 565> 566> 567> 568> 569> 570> 571> 572> 573> 574> 575> 576> 577> 578> 579> 580> 581> 582> 583> 584> 585> 586> 587> 588> 589> 590> 591> 592> 593> 594> 595> 596> 597> 598> 599> 600> 601> 602> 603> 604> 605> 606> 607> 608> 609> 610> 611> 612> 613> 614> 615> 616> 617> 618> 619> 620> 621> 622> 623> 624> 625> 626> 627> 628> 629> 630> 631> 632> 633> 634> 635> 636> 637> 638> 639> 640> 641> 642> 643> 644> 645> 646> 647> 648> 649> 650> 651> 652> 653> 654> 655> 656> 657> 658> 659> 660> 661> 662> 663> 664> 665> 666> 667> 668> 669> 670> 671> 672> 673> 674> 675> 676> 677> 678> 679> 680> 681> 682> 683> 684> 685> 686> 687> 688> 689> 690> 691> 692> 693> 694> 695> 696> 697> 698> 699> 700> 701> 702> 703> 704> 705> 706> 707> 708> 709> 710> 711> 712> 713> 714> 715> 716> 717> 718> 719> 720> 721> 722> 723> 724> 725> 726> 727> 728> 729> 730> 731> 732> 733> 734> 735> 736> 737> 738> 739> 740> 741> 742> 743> 744> 745> 746> 747> 748> 749> 750> 751> 752> 753> 754> 755> 756> 757> 758> 759> 760> 761> 762> 763> 764> 765> 766> 767> 768> 769> 770> 771> 772> 773> 774> 775> 776> 777> 778> 779> 780> 781> 782> 783> 784> 785> 786> 787> 788> 789> 790> 791> 792> 793> 794> 795> 796> 797> 798> 799> 800> 801> 802> 803> 804> 805> 806> 807> 808> 809> 810> 811> 812> 813> 814> 815> 816> 817> 818> 819> 820> 821> 822> 823> 824> 825> 826> 827> 828> 829> 830> 831> 832> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 329
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 337
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 345
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 353
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 361
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 369
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 377
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 385
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 393
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 401
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 409
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 417
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 425
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 433
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 441
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 449
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 457
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 465
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 473
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 481
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 489
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 497
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 505
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 513
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 521
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 529
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 537
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 545
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 553
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 561
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 569
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 577
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 585
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 593
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 601
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 609
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 617
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 625
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 633
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 641
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 649
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 657
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 665
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 673
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 681
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 689
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 697
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 705
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 713
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 721
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 729
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 737
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 745
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 753
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 761
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 769
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 777
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 785
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 793
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 801
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 809
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 817
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job, Line 825
Invalid object name 'MSjobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSadd_job_command'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173> 174> 175> 176> 177> 178> 179> 180> 181> 182> 183> 184> 185> 186> 187> 188> 189> 190> 191> 192> 193> 194> 195> 196> 197> 198> 199> 200> 201> 202> 203> 204> 205> 206> 207> 208> 209> 210> 211> 212> 213> 214> 215> 216> 217> 218> 219> 220> 221> 222> 223> 224> 225> 226> 227> 228> 229> 230> 231> 232> 233> 234> 235> 236> 237> 238> 239> 240> 241> 242> 243> 244> 245> 246> 247> 248> 249> 250> 251> 252> 253> 254> 255> 256> 257> 258> 259> 260> 261> 262> 263> 264> 265> 266> 267> 268> 269> 270> 271> 272> 273> 274> 275> 276> 277> 278> 279> 280> 281> 282> 283> 284> 285> 286> 287> 288> 289> 290> 291> 292> 293> 294> 295> 296> 297> 298> 299> 300> 301> 302> 303> 304> 305> 306> 307> 308> 309> 310> 311> 312> 313> 314> 315> 316> 317> 318> 319> 320> 321> 322> 323> 324> 325> 326> 327> 328> 329> 330> 331> 332> 333> 334> 335> 336> 337> 338> 339> 340> 341> 342> 343> 344> 345> 346> 347> 348> 349> 350> 351> 352> 353> 354> 355> 356> 357> 358> 359> 360> 361> 362> 363> 364> 365> 366> 367> 368> 369> 370> 371> 372> 373> 374> 375> 376> 377> 378> 379> 380> 381> 382> 383> 384> 385> 386> 387> 388> 389> 390> 391> 392> 393> 394> 395> 396> 397> 398> 399> 400> 401> 402> 403> 404> 405> 406> 407> 408> 409> 410> 411> 412> 413> 414> 415> 416> 417> 418> 419> 420> 421> 422> 423> 424> 425> 426> 427> 428> 429> 430> 431> 432> 433> 434> 435> 436> 437> 438> 439> 440> 441> 442> 443> 444> 445> 446> 447> 448> 449> 450> 451> 452> 453> 454> 455> 456> 457> 458> 459> 460> 461> 462> 463> 464> 465> 466> 467> 468> 469> 470> 471> 472> 473> 474> 475> 476> 477> 478> 479> 480> 481> 482> 483> 484> 485> 486> 487> 488> 489> 490> 491> 492> 493> 494> 495> 496> 497> 498> 499> 500> 501> 502> 503> 504> 505> 506> 507> 508> 509> 510> 511> 512> 513> 514> 515> 516> 517> 518> 519> 520> 521> 522> 523> 524> 525> 526> 527> 528> 529> 530> 531> 532> 533> 534> 535> 536> 537> 538> 539> 540> 541> 542> 543> 544> 545> 546> 547> 548> 549> 550> 551> 552> 553> 554> 555> 556> 557> 558> 559> 560> 561> 562> 563> 564> 565> 566> 567> 568> 569> 570> 571> 572> 573> 574> 575> 576> 577> 578> 579> 580> 581> 582> 583> 584> 585> 586> 587> 588> 589> 590> 591> 592> 593> 594> 595> 596> 597> 598> 599> 600> 601> 602> 603> 604> 605> 606> 607> 608> 609> 610> 611> 612> 613> 614> 615> 616> 617> 618> 619> 620> 621> 622> 623> 624> 625> 626> 627> 628> 629> 630> 631> 632> 633> 634> 635> 636> 637> 638> 639> 640> 641> 642> 643> 644> 645> 646> 647> 648> 649> 650> 651> 652> 653> 654> 655> 656> 657> 658> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 310
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 317
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 324
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 331
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 338
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 345
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 352
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 359
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 366
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 373
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 380
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 387
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 394
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 401
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 408
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 415
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 422
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 429
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 436
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 443
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 450
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 457
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 464
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 471
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 478
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 485
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 492
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 499
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 506
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 513
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 520
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 527
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 534
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 541
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 548
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 555
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 562
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 569
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 576
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 583
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 590
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 597
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 604
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 611
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 618
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 625
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 632
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 639
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 646
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_job_command, Line 653
Invalid object name 'MSjob_commands'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSsubscriber_status'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSsubscriber_status, Line 25
Invalid object name 'MSsubscriber_status'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSsubscriber_status, Line 35
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSsubscriber_status, Line 59
Invalid object name 'MSsubscriber_status'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSadd_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173> 174> 175> 176> 177> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscription, Line 49
Invalid object name 'MSjob_subscriptions'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscription, Line 61
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscription, Line 71
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscription, Line 116
Invalid object name 'MSsubscriber_info'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSdrop_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscription, Line 25
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscription, Line 25
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscription, Line 44
Invalid object name 'MSjob_subscriptions'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscription, Line 62
Invalid object name 'MSjob_subscriptions'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscription, Line 73
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscription, Line 73
Invalid object name 'MSjobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSupdate_subscription'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscription, Line 26
Invalid object name 'MSjob_subscriptions'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscription, Line 39
Invalid object name 'MSjob_subscriptions'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSadd_subscriber_job'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 13
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 17
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 17
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 17
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 17
Invalid object name 'MSjob_subscriptions'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 38
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 38
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 38
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_job, Line 38
Invalid object name 'MSjob_subscriptions'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSget_subscriber_jobs'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 21
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 33
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 45
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 45
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 45
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 65
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 65
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_subscriber_jobs, Line 65
Invalid object name 'MSjobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSfind_subscriber_job'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSfind_subscriber_job, Line 12
Invalid object name 'MSsubscriber_jobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSget_last_job'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_last_job, Line 11
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_last_job, Line 15
Invalid object name 'MSjobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> 4> 5> 6> 7> (1 row affected)
1> 2> 3> 4> Creating 'sp_MSget_last_trans'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_last_trans, Line 9
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSget_last_trans, Line 9
Invalid object name 'MSjobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSadd_subscriber_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_info, Line 54
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_info, Line 58
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSadd_subscriber_info, Line 64
Invalid object name 'MSsubscriber_info'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSupdate_subscriber_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> 115> 116> 117> 118> 119> 120> 121> 122> 123> 124> 125> 126> 127> 128> 129> 130> 131> 132> 133> 134> 135> 136> 137> 138> 139> 140> 141> 142> 143> 144> 145> 146> 147> 148> 149> 150> 151> 152> 153> 154> 155> 156> 157> 158> 159> 160> 161> 162> 163> 164> 165> 166> 167> 168> 169> 170> 171> 172> 173> 174> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 34
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 38
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 43
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 48
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 53
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 58
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 63
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 68
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 73
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 78
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 83
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 88
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 93
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 98
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 103
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 108
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 113
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 118
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 123
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_subscriber_info, Line 128
Invalid object name 'MSsubscriber_info'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSdrop_subscriber_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscriber_info, Line 11
Invalid object name 'MSsubscriber_info'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdrop_subscriber_info, Line 14
Invalid object name 'MSsubscriber_info'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MShelp_subscriber_info'.
1> 2> 3> 4> 5> 6> 7> 8> 9> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MShelp_subscriber_info, Line 8
Invalid object name 'MSsubscriber_info'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSkill_job'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSkill_job, Line 13
Invalid object name 'MSsubscriber_jobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> 4> Creating 'sp_MSnew_sync'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSnew_sync, Line 22
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSnew_sync, Line 22
Invalid object name 'MSjob_commands'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> 4> Creating 'sp_MSdistribution_counters'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_counters, Line 37
Invalid object name 'MSjob_subscriptions'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_counters, Line 55
Invalid object name 'MSsubscriber_status'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_counters, Line 55
Invalid object name 'MSsubscriber_status'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_counters, Line 71
Invalid object name 'MSsubscriber_jobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSdistribution_counters, Line 80
Invalid object name 'MSsubscriber_jobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> Creating 'sp_MSremove_published_jobs'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> 23> 24> 25> 26> 27> 28> 29> 30> 31> 32> 33> 34> 35> 36> 37> 38> 39> 40> 41> 42> 43> 44> 45> 46> 47> 48> 49> 50> 51> 52> 53> 54> 55> 56> 57> 58> 59> 60> 61> 62> 63> 64> 65> 66> 67> 68> 69> 70> 71> 72> 73> 74> 75> 76> 77> 78> 79> 80> 81> 82> 83> 84> 85> 86> 87> 88> 89> 90> 91> 92> 93> 94> 95> 96> 97> 98> 99> 100> 101> 102> 103> 104> 105> 106> 107> 108> 109> 110> 111> 112> 113> 114> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSremove_published_jobs, Line 82
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSremove_published_jobs, Line 82
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSremove_published_jobs, Line 95
Invalid object name 'MSjobs'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSremove_published_jobs, Line 102
Invalid object name 'MSjob_commands'.
Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSremove_published_jobs, Line 109
Invalid object name 'MSsubscriber_status'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3> 4> Creating 'sp_MSupdate_job'.
1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 19> 20> 21> 22> Msg 208, Level 16, State 1, Server KGDENIM, Procedure sp_MSupdate_job, Line 12
Invalid object name 'MSjobs'.
1> 2> 3> 4> 5> (0 rows affected)
1> 2> 3>  
1> 2> 3> 4> 5> 6> 7>  
Create users
 
1> 2> 3> New user added.
1> 2> 3> New user added.
1> 2> 3> 4> 5> 6> 7>  
Granting privileges on distribution stored procedures
 
1> 2> 3> 4> 5> 6> Msg 208, Level 16, State 2, Server KGDENIM, Line 1
Invalid object name 'sp_MSadd_subscription'.
Msg 208, Level 16, State 2, Server KGDENIM, Line 2
Invalid object name 'sp_MSupdate_subscription'.
Msg 208, Level 16, State 2, Server KGDENIM, Line 3
Invalid object name 'sp_MSdrop_subscription'.
Msg 208, Level 16, State 2, Server KGDENIM, Line 4
Invalid object name 'sp_MSdistribution_counters'.
Msg 208, Level 16, State 2, Server KGDENIM, Line 5
Invalid object name 'sp_MShelp_subscriber_info'.
1> 2> 3> 4> 5> (1 row affected)
1> 2> 3> 1> 2> 3> 4>  
The datetime established earlier during sequence mode 1 was
'1998/11/16 14:42:48' (spid=46, db=distribution)
The number of objects updated with category | 2 was 0. (spid=46,
db=distribution)
 
1> 2> 3> Configuration option changed. Run the RECONFIGURE command to install.
1> 2> 3> 1> 2>

   Aliciam I will evaluate Ur answer once I have finished checking up on my DNS.
0
 
prats_srAuthor Commented:


  I am using TCP/IP and using a NT pass-through account to set up Replication without trusted connections.
0
 
prats_srAuthor Commented:
What do you mean by an authentication maodel?
0
 
aliciaamCommented:
When you run your script make sure you are on the master database, I see that you have invalid objects such as stored procedures that replication should run from Master (that is where they exist) such as sp_create_replication_tables. If you don't want to do that you will have to edit your script and add in front of each stored procedure on master the following.
master.dbo.sp_create_replication_tables....
0
 
prats_srAuthor Commented:


   I am not using any scripts.I am just installing replication using Enterprise Manager.I am new to SQL Server and this is my first crack at it.When I installed it in my trial environment
also I did not use any scripts and did not use the master at all.
I had a separate device and database for replication publishing and subscribing.


   Also there does not seem to be any problem with DNS.    

0
 
connexCommented:
Open the SQL Client Configuration Manager ,
Check the "Net-Library"-Tab an see what protocol is used there.
If it's named pipes change it to use TCP/IP and it should work.
(very common problem .) )

0
 
connexCommented:
Oh and, be sure to have SQlExecutive set up NOT using the
Localsystem account! As described in the documentation the SQLExecutive requires to be run as a normal account to use replication.

0
 
aliciaamCommented:
Double check that you have those stored procedures under Master/objects/stored procedures. When you install replication SQL runs these sp for you and apparently cannot find them.

Stored procedure 'sp_create_distribution_tables' not found.

this is the one stored procedure replication is "looking" under master database. I hope this can help you. Let me know
0
 
aliciaamCommented:
Once replication cannot create the tables, it cannot find them to keep the whole process up.
0
 
aliciaamCommented:
this is the sp

CREATE PROCEDURE sp_create_distribution_tables
AS

BEGIN
   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'MSjobs' and type = 'U')
   BEGIN
      /****************************************************************************/
      PRINT ''
      PRINT 'Creating Table:  dbo.MSjobs'
      PRINT ''
      /****************************************************************************/
      CREATE TABLE MSjobs
      (
      publisher_id smallint,
      publisher_db varchar (  30 ) ,
      job_id int,
      type tinyint, /* 0- sql cmd 1-noop cmd 2-sql script 3/4-bcp cmd 5-manual sync*/
      xactid_page int,
      xactid_row smallint,
      xactid_ts binary (  8 ) ,
      entry_time datetime
      )

      /* Set category bit to reflect MS objects */
      UPDATE sysobjects SET category = category | 2 WHERE sysstat & 0xf = 3 AND
         name = 'MSjobs'

      PRINT ''
      PRINT 'Creating Clustered Index: ucMSjobs'
      PRINT ''
      CREATE UNIQUE CLUSTERED INDEX ucMSjobs ON dbo.MSjobs
         (publisher_db, publisher_id, job_id)
   END

   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'MSjob_commands' and type = 'U')
   BEGIN
      /****************************************************************************/
      PRINT ''
      PRINT 'Creating Table:  dbo.MSjob_commands'
      PRINT ''
      /****************************************************************************/
      CREATE TABLE MSjob_commands (
      publisher_id smallint,
      publisher_db varchar (  30 ) ,
      job_id int,
      command_id int,
      art_id int,
      incomplete bit,
      command varchar (  255 ) NULL
      )
      /* Set category bit to reflect MS objects */
      UPDATE sysobjects SET category = category | 2 WHERE sysstat & 0xf = 3 AND
         name = 'MSjob_commands'

      PRINT ''
      PRINT 'Creating Clustered Index: ucMSjob_commands'
      PRINT ''
      CREATE UNIQUE CLUSTERED INDEX ucMSjob_commands ON dbo.MSjob_commands
         (publisher_db, publisher_id, job_id, command_id)
   END

   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'MSsubscriber_jobs' and type = 'U')
   BEGIN
      /****************************************************************************/
      PRINT ''
      PRINT 'Creating Table:  dbo.MSsubscriber_jobs'
      PRINT ''
      /****************************************************************************/
      CREATE TABLE MSsubscriber_jobs
      (
      publisher_id smallint,
      publisher_db varchar (30),
      job_id int,
      subscriber_id smallint,
      subscriber_db varchar (  30 ) ,
      command_id int
      )

      /* Set category bit to reflect MS objects */
      UPDATE sysobjects SET category = category | 2 WHERE sysstat & 0xf = 3 AND
            name = 'MSsubscriber_jobs'

      PRINT ''
      PRINT 'Creating Clusteredd Index: ucMSsubscriber_jobs'
      PRINT ''
      CREATE UNIQUE CLUSTERED INDEX ucMSsubscriber_jobs ON dbo.MSsubscriber_jobs
         (publisher_db, publisher_id, subscriber_db, subscriber_id, job_id, command_id)

      PRINT ''
      PRINT 'Creating NonClustered Index: ncMSsubscriber_jobs'
      PRINT ''
      CREATE NONCLUSTERED INDEX ncMSsubscriber_jobs ON dbo.MSsubscriber_jobs
         (publisher_db, publisher_id, job_id)
   END


   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'MSsubscriber_status' and type = 'U')
   BEGIN
      /****************************************************************************/
      PRINT ''
      PRINT 'Creating Table:  dbo.MSsubscriber_status'
      PRINT ''
      /****************************************************************************/
      CREATE TABLE MSsubscriber_status
      (
      publisher_id smallint,
      publisher_db varchar (  30 ) ,
      job_id int,
      subscriber_id smallint,
      subscriber_db varchar (  30 ) ,
      completion_time datetime,
      delivery_latency int,
      delivered_jobs int,
      delivery_rate int,
      status int
      )

      /* Set category bit to reflect MS objects */
      UPDATE sysobjects SET category = category | 2 WHERE sysstat & 0xf = 3 AND
         name = 'MSsubscriber_status'

      PRINT ''
      PRINT 'Creating Clustered Index: ucMSsubscriber_status'
      PRINT ''
      CREATE UNIQUE CLUSTERED INDEX ucMSsubscriber_status on dbo.MSsubscriber_status
       (publisher_db, publisher_id, subscriber_db, subscriber_id, job_id)

   END

   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'MSsubscriber_info' and type = 'U')
   BEGIN
      /****************************************************************************/
      PRINT ''
      PRINT 'Creating Table:  dbo.MSsubscriber_info'
      PRINT ''
      /****************************************************************************/
      CREATE TABLE MSsubscriber_info
      (
      publisher  varchar (30),
      subscriber  varchar (30),
      type tinyint,           /* 0: MS SQL Server 1: ODBC Data Source */
      login varchar(30) NULL,
      password varchar(30) NULL,
      commit_batch_size int,
      status_batch_size int,
      flush_frequency int,
      frequency_type int,
      frequency_interval int,
      frequency_relative_interval int,
      frequency_recurrence_factor int,
      frequency_subday int,
      frequency_subday_interval int,
      active_start_time_of_day int,
      active_end_time_of_day int,
      active_start_date int,
      active_end_date int,
      retryattempts int,
      retrydelay int,
      description varchar(255) NULL,
      )

      /* Set category bit to reflect MS objects */
      UPDATE sysobjects SET category = category | 2 WHERE sysstat & 0xf = 3 AND
       name = 'MSsubscriber_info'

      PRINT ''
      PRINT 'Creating Clustered Index: ucMSsubscriber_info'
      PRINT ''
      CREATE UNIQUE CLUSTERED INDEX ucMSsubscriber_info ON dbo.MSsubscriber_info
       (publisher, subscriber)
   END
   ELSE
   BEGIN
      IF NOT EXISTS (select * from syscolumns
            where name = 'description'
            and id=object_id('MSsubscriber_info'))
      BEGIN
         /****************************************************************************/
         PRINT ''
         PRINT 'Alter Table:  dbo.MSsubscriber_info'
         PRINT ''
         /****************************************************************************/
         ALTER TABLE MSsubscriber_info ADD description varchar (255) NULL
       UPDATE MSsubscriber_info SET description = 'SQL Server 6.0'
      END
   END

   IF NOT EXISTS (SELECT * FROM sysobjects WHERE name = 'MSjob_subscriptions' and type = 'U')
   BEGIN
      /****************************************************************************/
      PRINT ''
      PRINT 'Creating Table:  dbo.MSjob_subscriptions'
      PRINT ''
      /****************************************************************************/
      CREATE TABLE MSjob_subscriptions
      (
      publisher varchar ( 30 ),
      publisher_id smallint,
      publisher_db varchar (  30 ) ,
      subscriber varchar ( 30 ),
      subscriber_id smallint,
      art_id int,
      subscriber_db varchar (  30 ) ,
      status tinyint,
      ts binary (8)
      )

      /* Set category bit to reflect MS objects */
      UPDATE sysobjects SET category = category | 2 WHERE sysstat & 0xf = 3 AND
       name = 'MSjob_subscriptions'

      PRINT ''
      PRINT 'Creating Clustered Index: ucMSsubscriptions'
      PRINT ''
      CREATE UNIQUE CLUSTERED INDEX ucMSsubscriptions ON dbo.MSjob_subscriptions
       (publisher_db, publisher_id, art_id, subscriber_id)
   END
END

GO


0
 
aliciaamCommented:
the stored procedure  creates the tables  and so forth.
0
 
prats_srAuthor Commented:


    Is it possisble to set up replication over a WAN using TCP/IP
in SQL Server 6.5.The SQL Server 7.0 documentation says that it can be accomplished using a ftp server.Is the same thing possible using SQL 6.5?How?


0
 
prats_srAuthor Commented:


    Is it possisble to set up replication over a WAN using TCP/IP
in SQL Server 6.5.The SQL Server 7.0 documentation says that it can be accomplished using a ftp server.Is the same thing possible using SQL 6.5?How?


0
 
connexCommented:
we have replication here over the WAN with about 50 SQL-Servers.
It works fine.

connex

0
 
prats_srAuthor Commented:


 When I remove NetBEUI and WINS to simulate a TCP/IP only connection the SQl Executive does not start.Can U tell me how to do this?
0
 
prats_srAuthor Commented:

   Thanks for Ur help
0
 
aliciaamCommented:
Do you have any errors to which to refer to on Event Viewer? It is possible the way you have SQL Executive account. If you ping the domain to which that account belongs, do you see it?

0
 
prats_srAuthor Commented:

   In the Event Viewer I am getting errors in this sequence--


   The SQLExecutive service depends on the Net Logon service which failed to start because of the following error:
The dependency service or group failed to start

The TCP/IP NetBIOS Helper service depends on the NetworkProvider group and no member of this group started.

The Workstation service terminated with service-specific error 5728.

The Server service terminated with the following error:
A device attached to the system is not functioning.  

Could not load any transport.



2.Yes,I am able to ping the other domain


    What I am unable to understand is that using pure TCP/IP there R three services ftp,www,gopher.SQL Server 7.0 documentation says he uses ftp.How can U do it in SQL 6.5 without using ftp?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 9
  • 8
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now