Results 1 to 2 of 2

Thread: query help

  1. #1
    Join Date
    Apr 2004
    Posts
    101

    Unanswered: query help

    hi, i need generate a report to get the procs/function names and compare between two servers for all databases. The final goal is to generate a list of objects missing on Server2(for all databases).

    example :

    ServerName Database Proc Function
    Server1 Test1 Testproc1 TestFunction1
    Server1 Test2 Testproc2 TestFunction2

    ServerName Database Proc Function
    Server2 Test1 Testproc1 TestFunction1


    Thanks for your help

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Object Catalog Views (Transact-SQL)

    sys.objects is your friend
    George
    Home | Blog

Posting Permissions

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