Vinay  Arora
How to Dropped All Stored Procedure in Database in SQL Server 2012?
By Vinay Arora in SQL Server on Apr 30 2013
  • Divendra Ojha
    Jul, 2014 17

    -- drop all user defined stored procedures Declare @procName varchar(500) Declare cur Cursor For Select [name] From sys.objects where type = 'p' Open cur Fetch Next From cur Into @procName While @@fetch_status = 0 Begin Exec('drop procedure ' @procName) Fetch Next From cur Into @procName End Close cur Deallocate cur

    • 0

Most Popular Job Functions

MOST LIKED QUESTIONS