thanks for the replies

Heres an example of the types of thing that im talking about, this is a part of a script that someone had set up and sent to me.

I cant find an example in a sproc at the minute, ill keep looking 🙂

BEGIN TRANSACTION

SET QUOTED_IDENTIFIER ON

SET ARITHABORT ON

SET NUMERIC_ROUNDABORT OFF

SET CONCAT_NULL_YIELDS_NULL ON

SET ANSI_NULLS ON

SET ANSI_PADDING ON

SET ANSI_WARNINGS ON

COMMIT

is this over the top?