Drop if exists

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 3110
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

The login already has an account under a different user name.

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 10031

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.

Access SQL Server from other machines

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 5933

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

How to change sa password.

Details
Written by: Stanko Milosev
Category: MS SQL
Hits: 5810

sp_password NULL,'new_password','sa' go

  1. Query to Find Column From All Tables of Database
  2. Select all from all tables in DB
  3. Invoke or BeginInvoke cannot be called on a control until the window handle has been created..
  4. Data into fields

Subcategories

C#

Azure

ASP.NET

JavaScript

Software Development Philosophy

MS SQL

IBM WebSphere MQ

MySQL

Joomla

Delphi

PHP

Windows

Life

Lazarus

Downloads

Android

CSS

Chrome

HTML

Linux

Eclipse

Page 79 of 168