SQL Server / System Stored Procedures / Auto generated System Stored Procedures ‘dt_’

Searching through my staging/test database and looking for ‘text’, ‘ntext’ data types I stumbled upon 31 system stored procedure starting with the prefix ‘dt_’. 

I was mostly interested in two of them using text datatype as an input parameter.

So what are those Stored Procedures?

Using different Visual Tools against SQL Server, such as Enterprise Manager or design tools, will trigger auto generated code and create set of System Stored Procedures.
Prefix ‘dt_’ stands for ‘DaVinci Tools’ early code name for technology used to auto generate code/sp.

If you know no one is going to use design tools or enterprise manager its safe to delete them.

Similar Posts:

Leave a Reply

Your email address will not be published. Required fields are marked *