Reseed/Reset Table Identity Value

DBCC CHEKIDENT Used To Reset Your Table Value
For Example

    If  We Want Next Record To Have Identity As 135 We Need To Run Sql Query To :

DBCC CHECKIDENT (yourTABLEname, reseed, 134)

                                                             For More Details Visit Microsoft Tech Lab

WebService Url

http://www.mikesdotnetting.com/Article/104/Many-ways-to-communicate-with-your-database-using-jQuery-AJAX-and-ASP.NET

WebService , Ajax

  <script type="text/javascript">
    $(document).ready(function(){
    $("#Customers").change(function(){
    //Using Load Method
       $("#CustomerDetails").load("FetchCustomer.aspx?CustomerID=" + $('#Customers').val());
     });

    //Using getMethod
    $.get("FetchCustomer.aspx",
       { CustomerID: "" + $('#Customers').val() + "" },
       function(data){
                $('#CustomerDetails').html(data);
                });
 
     //Using Ajax Method
      $.ajax({
               contentType : "text/html;charset=utf-8",
               data:"CustomerID="+$('#Customers').val(),
               url:"FetchCustomer.aspx",
               dataType:"html",
               success:function(data){
                $('#CustomerDetails').html(data);
                }
             });
          });
     });
    </script>

Drop All Procedures

DECLARE @name VARCHAR(128)

DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null

BEGIN

    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'

    EXEC (@SQL)

    PRINT 'Dropped Procedure: ' + @name

    SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 AND [name] > @name ORDER BY [name])

END

GO