to resolve the error : failed to register url access denied
Solution:
use window + R to open RUN
type below line in it and hit enter/run.
netsh http delete urlacl url=http://*:62940...
Tuesday, August 25, 2015
Thursday, March 12, 2015
Cleans all views, SPS, functions PKs, FKs and tables
/* Drop all non-system stored procs */
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...
Subscribe to:
Posts (Atom)