Script Object as CREATE/ALTER

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
ryankuhta
Posts: 1
Joined: Wed 07 Sep 2022 13:16

Script Object as CREATE/ALTER

Post by ryankuhta » Thu 08 Sep 2022 13:30

Hello! I use SQLComplete and have noticed a bug and wanted to depict the error here so that it hopefully can be solved. To recreate this bug you need to do the following.

1) Once in a new Query type out the Stored Procedure or View you want to Script to a new File
2) Highlight the Stored Procedure or View and right click and select "Script Object as CREATE/ALTER"
(or use ctrl + f12)
3) You will recieve the error message "Cannot find object definition to open."

If one tries to write "EXEC" infront of the (for eg) Stored Procedure the function works perfectly, but without the EXEC infront it doesn't work.

Please correct me if im using the function in a wrong way, but it would make my life easier, if I could just Script any function that I choose to write without hanging anything infront of it.

Post Reply