Viewing post 1 (of 1 total)
Use "with execute as 'dbo' "
------------------------------------------------------------------------------------------------------------------
-- Prep
------------------------------------------------------------------------------------------------------------------
-- Create test users and test db
USE [master]
GO
CREATE LOGIN [testAdmin] WITH PASSWORD=N'Dork', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
CREATE LOGIN [testUser] WITH PASSWORD=N'Dork', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
CREATE DATABASE [testDB]...
October 12, 2010 at 4:40 pm
Viewing post 1 (of 1 total)