I've been posting in Programming as initially I thought this was a code
problem, but thought I would try here. I've included my script at the end.

Basically, when I run the script logged in as me, everything works as
expected. However, when I run the script logged in as the machine account SQL
Server runs under, I get an error. And the error moves depending on how I
specify the logins. I'm looking for help trying to track this problem down,
as the production server DBA's also create the databases under a machine
account, then let me log in to create the objects.

TIA, Bob

--!01_SetupScript.SQL
-- This is a test script when trying to figure out how to bulk insert files
-- without giving users specific bulkadmin permissions
-- This runs fine under my domain account,
-- but fails when I run it under the machine domain account.
-- SQL Server 2005 starts in.
USE master;
SET NOCOUNT ON;
GO
-- Drop existing database and login accounts
IF EXISTS(SELECT * FROM sys.databases WHERE name = 'BulkCopyTest')   
DROP DATABASE BulkCopyTest;
IF EXISTS(SELECT * FROM sys.server_principals WHERE name = 'BulkUser')   
DROP LOGIN BulkUser;
IF EXISTS(SELECT * FROM sys.server_principals WHERE name = 'BulkAccount')   
DROP LOGIN BulkAccount;
GO

CREATE LOGIN BulkUser WITH PASSWORD = 'bulk$1user';
CREATE LOGIN BulkAccount WITH PASSWORD = 'bulk$1account';
GRANT ADMINISTER BULK OPERATIONS TO BulkAccount;
--REVOKE CONNECT SQL FROM BulkAccount;
GO

CREATE DATABASE BulkCopyTest;
ALTER DATABASE BulkCopyTest SET TRUSTWORTHY ON;
GO

USE BulkCopyTest;
-- If I don't use the FOR LOGIN clause, I get msg 33009 when I EXECUTE AS
later
IF NOT EXISTS(SELECT * FROM sys.database_principals WHERE name = 'BulkUser')   
CREATE USER BulkUser FOR LOGIN BulkUser;
IF NOT EXISTS(SELECT * FROM sys.database_principals WHERE name =
'BulkAccount')   
CREATE USER BulkAccount FOR LOGIN BulkAccount;
GO

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME =
'vContext')   
DROP VIEW dbo.vContext;
GO
CREATE VIEW dbo.vContext AS
SELECT
    GETDATE() AS CurrentTime
    ,ORIGINAL_LOGIN() AS OriginalLogin
    ,SUSER_SNAME() AS SUserSName
    ,SYSTEM_USER AS SystemUser
    ,USER_NAME() AS UserName
    ,SESSION_USER AS SessionUser
    ,CURRENT_USER AS CurrentUser;
GO
GRANT SELECT ON dbo.vContext TO public;
GO

IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE =
'BASE TABLE' AND TABLE_NAME = 'BulkTable')
BEGIN
    CREATE TABLE dbo.BulkTable
        (RowNum    INT    IDENTITY(1,1)    PRIMARY KEY
        ,DT DATETIME DEFAULT (GETDATE())
        ,H1 VARCHAR(36)
        ,H2 VARCHAR(36)
        );
    GRANT INSERT ON dbo.BulkTable TO BulkAccount;    --Not sure I need this,
considering ownership chaining.
END;
GO

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME =
'vBulkTable')   
DROP VIEW dbo.vBulkTable;
GO
CREATE VIEW dbo.vBulkTable AS   
    SELECT H1,H2 FROM dbo.BulkTable;
GO
GRANT INSERT ON dbo.vBulkTable TO BulkAccount;
GO

IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_TYPE =
'PROCEDURE' AND ROUTINE_NAME = 'BulkInsertTest')   
DROP PROCEDURE dbo.BulkInsertTest;
GO

CREATE PROCEDURE dbo.BulkInsertTest
(@UNCFilePath AS VARCHAR(256)
,@FirstRow AS INT = 2
,@ErrorString VARCHAR(4000) = '' OUTPUT
) WITH EXECUTE AS 'BulkAccount'
AS
DECLARE    @SQL    VARCHAR(4000);
BEGIN
    SET @SQL = 'BULK INSERT dbo.vBulkTable FROM ';
    SET @SQL = @SQL + CHAR(39) + @UNCFilePath + CHAR(39);
    SET @SQL = @SQL + ' WITH (TABLOCK,FirstRow=' + CAST(@FirstRow AS VARCHAR) +
')';
    SELECT *,@SQL AS SQLStatement FROM dbo.vContext;
    EXEC(@SQL);
END;
GO
GRANT EXECUTE ON dbo.BulkInsertTest TO public;
GO

--Get msg 33009 here if not using FOR LOGIN clause when creating users
EXECUTE AS LOGIN = 'BulkUser';   

SELECT * FROM dbo.vContext;
DECLARE @strError AS VARCHAR(4000);

--Get msg 33009 here if using FOR LOGIN clause when creating users
EXEC dbo.BulkInsertTest
    @UNCFilePath = 'H:\SQLServerBulkInsertTest\ServiceBrokerBulkFile.txt'
    ,@FirstRow = 2
    ,@ErrorString = @strError OUTPUT;
--Actual Message
--Msg 33009, Level 16, State 2, Procedure BulkInsertTest, Line 0
--The database owner SID recorded in the master database differs from the
database owner SID recorded in database 'BulkCopyTest'. You should correct
this situation by resetting the owner of database 'BulkCopyTest' using the
ALTER AUTHORIZATION statement.

IF LEN(ISNULL(@strError,'')) > 0   
    SELECT @strError AS ErrorString;
REVERT;
SELECT * FROM dbo.vContext;
SELECT * FROM dbo.BulkTable;
GO

-- Clean Up
USE master;
IF EXISTS(SELECT * FROM sys.databases WHERE name = 'BulkCopyTest')    DROP
DATABASE BulkCopyTest;
IF EXISTS(SELECT * FROM sys.server_principals WHERE name = 'BulkUser')    DROP
LOGIN BulkUser;
IF EXISTS(SELECT * FROM sys.server_principals WHERE name =
'BulkAccount')    DROP LOGIN BulkAccount;
GO