I have this script to find open transactions, wanted to create it as a SP sp_GetOpenTransactions in the master db, but I get a syntax error. Works just fine in the other DB. Server is sql 2008. I noticed that the master db compatibility level is 80, the
userdbs are in level 100. Wondering if that is the problem here ? Why not the system dbs get their compatibility level changed after an upgrade ?
- SELECT L.request_session_id