August 13, 2019
SQL Server Management Studio (SSMS) cannot be closed
Category: SQL
September 1, 2017
SQL Agent Error: unable to connect to sql server ‘(local)’. the step failed
Cause: The error is caused by either database is not selected in Job Step or the database have been renamed. Solution “Edit Job Step” and select a database as shown below:
June 1, 2017
SQL table trigger template
Simple and easy to use trigger template: Create Trigger [dbo].[Trigger_IU] on [dbo].[TableName] after INSERT, UPDATE, DELETE as begin Set nocount on; declare @activity char; set @activity = ”; declare @i int, @d int; select @i = count(*) from inserted; select @d = count(*) from deleted; if @i > 0 and @d = 0 begin set