There is not really something like libraries in database world.
But in SSMS you can create solution/projects which include several SQL script files.
See
Projects (SQL Server Management Studio)
Create a New Solution
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I am trying to setup a library where I can store SQL scripts that can be accessed by other team members.
Please I need suggestions.
Thanks
There is not really something like libraries in database world.
But in SSMS you can create solution/projects which include several SQL script files.
See
Projects (SQL Server Management Studio)
Create a New Solution
Hi Tobz,
You can try to create the templates in the SSMS view menu->Template Explorer, and share with your team members. Please refer to SSMS Shared SQL Templates and Standard template in SSMS which might help.
In addition, you can try to create a script repository stored in table with the PowerShell. Please refer to this article which might help.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.