Using SQL Files
New Information - SQL Server 2000 SP3.
You can save query definitions and other SQL scripts for reuse. The default extension for these files is .sql.
You can also create templates, which are boilerplate scripts used to create objects in a database. The extension for template files is .tql.
Security Note Never store passwords in a script.