SQL Server Database Administrator Question:

Can we have a nested transaction?