"Procedure already exists" message ...

Author Message
 Posted 11/21/2013 11:42:19 AM
StrataFrame User

StrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame UserStrataFrame User

Group: Awaiting Activation
Last Login: 4/9/2020 9:18:41 AM
Posts: 174, Visits: 12,825
I'm a little stumped by this one ... just about every time I deploy from the DDT to the development database I usually get a message stating that the SP already exists in the server.  Well, yes, in fact it does ... I'd kind of like you to overwrite it if it is different.

The odd thing is that this does not happen with every stored procedure that already does exist.  The DDT just goes on its merry way either overwriting or ignoring (don't know which) the exiting stored procedure.

Why do some SPs generate this warning and some don't?

In order to get a clean deployment I have to delete those stored procedures the DDT does not like and run the deployment again.

Stumped.

Thanks.


Charles T. Blankenship
Senior Consultant
Novant Consulting, Inc.
704.975.7152
http://www.novantconsulting.com
Post #32318
Add to Twitter Add to Facebook
 Posted 11/21/2013 7:25:42 PM
StrataFrame VIP

StrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIPStrataFrame VIP

Group: StrataFrame Users
Last Login: 4/9/2021 12:42:36 PM
Posts: 2,436, Visits: 24,184
Hi Charles,

The DDT will create Extended Properties for all is objects "DDT_Priority" and I believe it is using this property to determine if that object was created by the DDT or was manually created by you or some other tool which in that case it will not touch that object and ignore it.

So if you delete all the objects you are getting warning, assuming you have a good backup first, then always made all the changes to your database via the DDT, then you should be OK.  Also another trick I use for quick updates, is to generate and stored procedure script from MSSMS which will also create the Extended Properties and make some quick changes to update a customer, but always go back to the DDT and made those changes there for future update.


Edhy Rijo
(Using VB.Net 2019/SQL Server 2017)
Post #32319
Add to Twitter Add to Facebook


Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Site Map - Home - My Account - Forum - About Us - Contact Us - Try It - Buy It

Microsoft, Visual Studio, and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.