Quick without looking it up… what does this script do:
SELECT *
FROM dbo.sysfiles
WHERE (status & 0×40) <> 0
So if you’re like me and don’t have all the bit compares memorized for all the tables you probably didn’t know that this is how (in SQL 2000) you would query the current database to find all the transaction log files.
Every now and again I take for [...]
My Thoughts on SQL Server and anything else I can think of…
