Month: December 2010

Below Code will execute FTP Commands from SQL Server. First thing you need to take care is create a text file with the name “ftp” and type all your ftp commands and then create the below procedure in SQL Server -- ============================================= -- Author: V.U.M.Sastry Sagi -- Create date:12/28/2010 -- Description: Executes a FTP Command

The Below Procedure will drop the Database by force though it is accessing by the End Users. -- ============================================= -- Author: V.U.M.Sastry Sagi -- Create date: 12/05/2010 -- Description: Drops a Database by Force -- ============================================= CREATE PROCEDURE [dbo].[dropDBByForce](@DBName VARCHAR(100)) AS BEGIN DECLARE @sql NVARCHAR(MAX) SET @sql='ALTER DATABASE ['+@dbname+'] SET SINGLE_USER --or RESTRICTED_USER WITH ROLLBACK