I'm trying to create a repro script for a MS connect item, and need to be able to cause a stack dump at will.
How could I do that?
DBCC DUMPTRIGGER can be used to trigger a dump on a specific error.
You can also take a dump of at will, see How to use the Sqldumper.exe utility to generate a dump file in SQL Server but those are less useful.