SQL Server - I need code that will cause a stack dump

349 Views Asked by At

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?

1

There are 1 best solutions below

2
Remus Rusanu On BEST ANSWER

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.