Solved

Urgent!!!Replication problem

Posted on 1998-11-16
21
1,135 Views
Last Modified: 2008-02-20

           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
Comment
Question by:prats_sr
  • 9
  • 8
  • 4
21 Comments
 
LVL 2

Expert Comment

by:aliciaam
Comment Utility
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
 
LVL 2

Expert Comment

by:connex
Comment Utility
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
 
LVL 2

Accepted Solution

by:
aliciaam earned 80 total points
Comment Utility
Make sure that network name resolution is assured. This can
be accomplished by using LMHosts lookup, DNS or WINS.

0
 

Author Comment

by:prats_sr
Comment Utility


  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
 

Author Comment

by:prats_sr
Comment Utility


  I am using TCP/IP and using a NT pass-through account to set up Replication without trusted connections.
0
 

Author Comment

by:prats_sr
Comment Utility
What do you mean by an authentication maodel?
0
 
LVL 2

Expert Comment

by:aliciaam
Comment Utility
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
 

Author Comment

by:prats_sr
Comment Utility


   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
 
LVL 2

Expert Comment

by:connex
Comment Utility
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
 
LVL 2

Expert Comment

by:connex
Comment Utility
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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 2

Expert Comment

by:aliciaam
Comment Utility
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
 
LVL 2

Expert Comment

by:aliciaam
Comment Utility
Once replication cannot create the tables, it cannot find them to keep the whole process up.
0
 
LVL 2

Expert Comment

by:aliciaam
Comment Utility
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
 
LVL 2

Expert Comment

by:aliciaam
Comment Utility
the stored procedure  creates the tables  and so forth.
0
 

Author Comment

by:prats_sr
Comment Utility


    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
 

Author Comment

by:prats_sr
Comment Utility


    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
 
LVL 2

Expert Comment

by:connex
Comment Utility
we have replication here over the WAN with about 50 SQL-Servers.
It works fine.

connex

0
 

Author Comment

by:prats_sr
Comment Utility


 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
 

Author Comment

by:prats_sr
Comment Utility

   Thanks for Ur help
0
 
LVL 2

Expert Comment

by:aliciaam
Comment Utility
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
 

Author Comment

by:prats_sr
Comment Utility

   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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now