Erland Sommarskog (email@example.com) writes:
OK, so this really weird. Tonight when I tried, the timeout worked as
advertised. And to make it even more crazy: Last night I closed and
restarted SSMS with no effect. But I had SSMS running all day, and suddenly
the change has effect.
And then I reset the timeout to 0, but the timeout kept coming. Yes,
even after a restart.
I have no idea what is going on.
Erland Sommarskog, SQL Server MVP, firstname.lastname@example.org
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx