Open Microsoft SQL Server -> Enterprise Manager




Right Click and Select New SQL Server Registration


Click Next.

Enter the Servername and click Add button



Then Click Next button



Again Click Next


Click Next




Click Finish



Once the server is connect click Close




Now the server is connected and it will list the database. Select the corresponding database.





Click Stored Procedure from the Tree



Select all the procedure in the right side grid using Ctrl + A


Now right click select All Tasks -> Generate SQL Script and click Ok



Progressing


Now the script is saved successfully


Now we can view the script from the My Documents folder where we saved initially

Query to display the duplicate values from the table
---------------------------------------------------


SELECT a.* FROM dbo.dept As [a]
 INNER JOIN
  (
      SELECT dept_name, mgr_name FROM   dbo.dept
    GROUP BY dept_name, mgr_name
      HAVING Count(*)  >1
  ) As [b]
    ON a.dept_name = b.dept_name
   AND a.mgr_name  = b.mgr_name


Output
---------