SQL: Create missing stored procedures using a linked server

added by DotNetKicks
10/3/2019 2:07:57 PM

174 Views

I answered an interesting question the other day on Stack Overflow. What the person who posted was after was a way to create all missing stored procedures on one database that were present on another database on another server. Here's an example of how to do that: [crayon-5d951e3d41611236762394/] I start by querying sys.procedures, sys.schemas, and ...


0 comments