<p>I want to use Visual Studio snippets to generate SQL code, for example we have standard naming conventions for foreign keys etc and it would be great if I could just expand a snippet in my SQL script file. </p>

<p>However as far as I can tell the only languages that are supported by the Snippet manager are C#, VB J# and XML</p>

<p><a href="http://msdn.microsoft.com/en-gb/library/ms171421(VS.80).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-gb/library/ms171421(VS.80).aspx</a></p>

<p>Does anyone know of a way to have a snippet expand to SQL?</p>

<p>Derek</p>

So, if you have a statement something like the following, you're saying that you get no 'print' result?
```
select * from sysobjects
PRINT 'Just selected * from sysobjects'
```
If you're using SQL Query Analyzer, you'll see that there are two tabs down at the bottom, one of which is "Messages" and that's where the 'print' statements will show up.
If you're concerned about the
timing
of seeing the print statements, you may want to try using something like
```
raiserror ('My Print Statement', 10,1) with nowait
```
This will give you the message immediately as the statement is reached, rather than buffering the output, as the Query Analyzer will do under most conditions.