•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the C# section within the Software Development category of DaniWeb, a massive community of 456,554 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,485 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our C# advertiser: Programming Forums
Views: 2879 | Replies: 1 | Solved
 |
•
•
Join Date: Apr 2006
Posts: 87
Reputation: 
Rep Power: 3
Solved Threads: 2
Junior Poster in Training
Hi all,
I have been trying to drop a stored proc for sometime using SMO. I can create with ease but can't seem to drop. Any ideas? I thought it might be permission but for testing used SA account. No luck...
I keep geting a error of "You cannot execute this operation since the object has not been created". It is created, I can execute it, I can modify it, heck I can even delete it in SQL Management Studio with no problems.
???
I have been trying to drop a stored proc for sometime using SMO. I can create with ease but can't seem to drop. Any ideas? I thought it might be permission but for testing used SA account. No luck...
private void btnCreate_Click_1(object sender, EventArgs e)
{
SqlConnection sqlConn = new SqlConnection("Connection String HERE");
Microsoft.SqlServer.Management.Common.ServerConnection serverConn = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConn);
Server svrSql = new Server(serverConn);
Database db = svrSql.Databases["DBTest"];
StoredProcedure spNew = new StoredProcedure(db, "StoredProc");
spNew.TextMode = false;
spNew.AnsiNullsStatus = false;
spNew.QuotedIdentifierStatus = false;
spNew.TextBody = "Select * from TestTable";
spNew.Create();
svrSql = null;
}
private void btnDestroy_Click(object sender, EventArgs e)
{
SqlConnection sqlConn = new SqlConnection("Connection String HERE");
Microsoft.SqlServer.Management.Common.ServerConnection serverConn = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConn);
Server svrSql = new Server(serverConn);
Database db = svrSql.Databases["DBTest"];
StoredProcedure spNew = new StoredProcedure(db, "StoredProc");
spNew.Drop();
svrSql = null;
}I keep geting a error of "You cannot execute this operation since the object has not been created". It is created, I can execute it, I can modify it, heck I can even delete it in SQL Management Studio with no problems.
???
•
•
Join Date: Apr 2006
Posts: 87
Reputation:
Rep Power: 3
Solved Threads: 2
Junior Poster in Training
Man this sucks. It's always after I post a question I then answer it. You have to use the spNew.Refresh(). It believe it asks the SQL Server the current status of the stored proc. Then you are allowed to delete it with ease. 
private void btnDestroy_Click(object sender, EventArgs e)
{
SqlConnection sqlConn = new SqlConnection("Connection String HERE");
Microsoft.SqlServer.Management.Common.ServerConnection serverConn = new Microsoft.SqlServer.Management.Common.ServerConnection(sqlConn);
Server svrSql = new Server(serverConn);
Database db = svrSql.Databases["DBTest"];
StoredProcedure spNew = new StoredProcedure(db, "StoredProc");
//HERE IS THE KEY!
spNew.Refresh();
spNew.Drop();
svrSql = null;
} |
•
•
•
•
•
•
•
•
DaniWeb C# Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ad advertising ajax architecture asp backup beta business centro crash daniweb database dell developer development doubleclick enterprise google hacker internet linux longhorn mail microsoft mmorpg msdn news novell office open qmail red hat rhel security server smtp software source sql survey suse vista windows windows server
- Updated : Simple ASP.Net Login Page (ASP.NET)
- filling combobox with data stored in a table in sql server (VB.NET)
- How to connect a SQL stored procedure to a windows application? (VB.NET)
- Must declare the scalar variables in storedprocedure in sql 2005 (MS SQL)
- ASP.net/Stored Proc & Login Verification (ASP.NET)
- Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)
- Sql2k, How to set or unset IDENTITY Property of a column through code or stored (Legacy and Other Languages)
- Working with SQL's Text data type (ASP.NET)
Other Threads in the C# Forum
- Previous Thread: Compiling Problems code snippets
- Next Thread: Anyone using dotnet 3.0
