Hi,

I am using the following script

set @Query='

USE ['+@DatabaseName+']

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

CREATE SCHEMA ['+@SchemaName+'] AUTHORIZATION ['+@UserName+']

'

exec (@Query)

While executing its giving error "Incorrect...

I have tried this sp_defaultdb lsr, temp... but in user mappings only the public check box is showing as checked...