ALTER DATABASE TempDB MODIFY FILE
(NAME = templog, FILENAME = 't:\templog.ldf')

Unable to open the physical file Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5

SET IDENTITY_INSERT tablename ON

INSERT INTO tablename (column1, column2)

SELECT column1, column2 FROM table2

SET IDENTITY_INSERT tablename OFF

-- RAISERROR with severity 11-19 will cause execution to 
-- jump to the CATCH block.

RAISERROR ('Error raised in TRY block.', -- Message text.

               16, -- Severity.

               1 -- State.

               );

BEGIN TRY

 BEGIN TRANSACTION
 
 -- Do whatever you need to do
 

 COMMIT TRANSACTION

END TRY

BEGIN CATCH

 -- Rollback if in a transaction

 IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION
 
 -- Do whatever error logging you need to do

END CATCH

EXECUTE msdb.dbo.sp_send_dbmail @recipients='to@xxx.com',
@subject = 'Test email',
@body = 'Test email body',
@reply_to='from@yyy.com'

Private Sub ContextMenuHandler_Click(ByVal sender As Object, ByVal e As System.EventArgs)

' Do something when the user clicks on a node

' Use the sender.tag to determine which menu item was clicked

End Sub

' This could be a strip added via form designer

Dim oContextMenu As New ContextMenuStrip

' Add a toolstrip Item

Dim oNewToolStripItem As New ToolStripMenuItem

oNewToolStripItem.Text = "Parent"

oNewToolStripItem.Tag = "1"

AddHandler oNewToolStripItem.Click, AddressOf ContextMenuHandler_Click

oContextMenu.Items.Add(oNewToolStripItem)

' Add a couple of children

Dim oNewToolStripItem2 As New ToolStripMenuItem

oNewToolStripItem2.Text = "Child 1"

oNewToolStripItem2.Tag = "2"

AddHandler oNewToolStripItem2.Click, AddressOf ContextMenuHandler_Click

oNewToolStripItem.DropDownItems.Add(oNewToolStripItem2)

Dim oNewToolStripItem3 As New ToolStripMenuItem

oNewToolStripItem3.Text = "Child 2"

oNewToolStripItem3.Tag = "3"

AddHandler oNewToolStripItem3.Click, AddressOf ContextMenuHandler_Click

oNewToolStripItem.DropDownItems.Add(oNewToolStripItem3)

-- This returns 1

select ISNUMERIC('1.1')

-- This returns 1

select ISNUMERIC('12')

-- This returns 0

select ISNUMERIC('aaaa')

USE DATABASENAME
GO
DBCC SHRINKFILE(LOGNAME, 1)
BACKUP LOG DATABASENAME WITH TRUNCATE_ONLY
DBCC SHRINKFILE(LOGNAME, 1)