SPID...

??

Thanks, I thought that's what it was after...

GilaMonster (9/13/2016)

---

sys.dm_tran_database_transactions gives information about how much log space was used for a transaction.

Extended events writes should give you total writes, if the correct events are selected (sql vs sp),...

GilaMonster (9/13/2016)

---

Redo? The only time you get a redo (roll forward) is during crash recovery (after opening a DB/starting SQL Server) or restoring a backup.

Can you explain in more detail...

The database server has SSIS installed & running. I want to connect to it via SSMS.

Some supplier requires access but we can't give OS access (shared cluster) but also...

We were thinking of doing it Tonight but decided it was too risky as the people who manage the more critical apps of the instance were on holiday Today. Decided...

It was done by Ola's job/script. The pid, as far as SQL Server is concerned, doesn't exist on the server any more (in task manager)...only the spid is there

No, 2008r2 SP2 CU 11 (of 13).

dm_tran_locks output:

request_session_idresource_typeresource_subtyperequest_moderequest_typerequest_statusrequest_owner_type

127DATABASEBULKOP_BACKUP_LOGNULLLOCKGRANTTRANSACTION

127DATABASEBULKOP_BACKUP_DBULOCKGRANTTRANSACTION

127DATABASESLOCKGRANTSHARED_TRANSACTION_WORKSPACE

Apparently it's a known backup bug: http://stackoverflow.com/questions/12216866/cant-kill-spid-transaction-rollback-in-progress

but unable to find the hotfix & restarting sucks with 15 apps on the cluster :f

*This is a test*

Edit: There seems to be an issue creating new threads but not commenting on existing ones?

Hi,

Everywhere I look I see identical TSQL...what requires changing?

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',

'ADSDSOObject', 'adsdatasource'

I assume the only part that changes is 'ADSI' with an AD server name? Or...

2008r2