views:

95

answers:

4

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?

+1  A: 

We store them in a wiki where everyone can access them.

Kevin
+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
How do you access them in Mgt. Studio? Do you have them setup as a project?
Gern Blandston
No, we don't use projects in management studio. All "structures" are set in directory hierarchy.
TcKs
+1  A: 

We store them in a separate database and have a custom program for easy execution and maintenance.

Kaniu
A: 

I horde them all in template format on my hard drive. CTRL+SHIFT+M will fill the placehoders. It's great.

Sam