In your workplace, where do you store your common, non-database specific scripts that you use in SQL Server? Do you keep them in .SQL scripts on the file server, do you store them in the Master database, or do you keep them in a database you defined specifically for these kinds of things?
+2
A:
We store them as regular source code, so in version-control. You have then available previous versions of script, and you avoid "someone deleted the XY script" risk.
TcKs
2008-11-19 15:26:48
How do you access them in Mgt. Studio? Do you have them setup as a project?
Gern Blandston
2008-11-19 15:28:06
No, we don't use projects in management studio. All "structures" are set in directory hierarchy.
TcKs
2008-11-19 19:58:04
+1
A:
We store them in a separate database and have a custom program for easy execution and maintenance.
Kaniu
2008-11-19 16:29:26