>>>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? >> >>I am not very familiar with NET, but in VFP I use folowing technics: make a new connection to desired DataBase and then ExecuteNonQuery("CREATE SP......") > >Thank for the response, but like I said in my original posting, I already have the code to create the SP. What I need is a way to create the SP is the proper database.
You don't need to connect to your database in your connection string, just to your server. You can then connect to the appropriate database using the "USE yourdatabase" command via a SQLEXEC. This way, you can change databases using the same connection.