MS SQL

Details: Written by: Stanko Milosev; Category: MS SQL; Published: 13 March 2020; Last Updated: 13 March 2020; Hits: 2225

Here are few "DROP IF EXISTS" SQL statements, for my future reference.

Trigger from sys.objects:

IF EXISTS (SELECT * FROM sys.objects WHERE [name] = N'myTrigger' AND [type] = 'TR')
BEGIN
      DROP TRIGGER [dbo].[myTrigger];
END;
GO

Stored procedure with OBJECT_ID:

IF OBJECT_ID('dbo.mySP') IS NOT NULL
  DROP PROCEDURE dbo.mySP
GO

Temp table:

IF OBJECT_ID('tempdb..#myTempTable') IS NOT NULL DROP TABLE #myTempTable
GO

Details: Written by: Stanko Milosev; Category: MS SQL; Published: 11 February 2013; Last Updated: 04 July 2013; Hits: 8854

If you receive error like:

The login already has an account under a different user name. (Microsoft SQL Server, Error: 15063)

Then just take databse offline and back online. Frome here.

Details: Written by: Stanko Milosev; Category: MS SQL; Published: 12 November 2012; Last Updated: 26 December 2012; Hits: 5084

SQL Server Browser has to be enabled so that other machines can access it.

Details: Written by: Stanko Milosev; Category: MS SQL; Published: 12 November 2012; Last Updated: 30 November -0001; Hits: 4923

sp_password NULL,'new_password','sa' go

Page 2 of 5

Drop if exists