As a further update to this, I can enable the sysadmin account then logon and create server logins/db users manually, but not via the stored procedure it would seem.

I've also...

Cool, that's fixed the syntax error but not the permissions error:

CREATE LOGIN [test1] WITH PASSWORD = N'wibble',DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;

Msg 15247, Level 16, State 1, Line 1

User does not have permission...

Have created the superuser but get the following error now :angry:

CREATE LOGIN [test1] WITH PASSWORD = 'password',N' DEFAULT_DATABASE=[Master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF;

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after...

Apologies, I forgot to add that Obewan is part of the DB_owner role for the DB, and is a sysadmin as server level.

So do you need to grant explicit perms...

OK, I've tweaked the elevated perms SP script as follows:

USE [SM_Test]

GO

/****** Object: StoredProcedure [dbo].[pr_CallBoostedSecurityProcess] Script Date: 10/07/2013 14:27:38 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [dbo].[pr_CallBoostedSecurityProcess]( @name...

Thanks for the reply, I'm not too hot on T-SQL but will read through it and see if I can work it out 🙂