>>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.
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook