>I am trying to create a Stored Procedure in a specified database programatically using the ExecuteNonQuery() method of an SQLCommand object. I am coming across a problem where the SP is being created in the Master Database because the "sa" account is being used. I attempted to preface my Create Procedure command with "USE ;" but SQL spits back that the Create Procedure command must be the first statement executed in a batch. How can I tell SQL to create this SP in the proper database?


USE
GO

CREATE PROCEDURE ...