Hi,

'create schema' must the be the first line in a batch. here is the

workaround.

USE [TEMP]

IF NOT EXISTS (SELECT * FROM sys.schemas WHERE name = N'lsrSchema')

begin

select 'Test...