Makes sense- thanks.

Yep, it happens every time.  Just happened again.

Can you verify it doesn't happen to you?  Do you have the same versions of SqlServer and SSMS that I have?

There's apparently some kind of time limit on when those changes completely go away after I have close it without saving.
After waiting a few minutes, now the changes have...

Haha! I just noticed the paymentID column is a varchar(3) for some reason. Changed that to an it, that fixed it.

Ah, I see. I thought a trans log backup just basically copies your entire trans log file. But I guess it actually loops through all the VLFs inside...

I'm reading about Tail-Log Backups now-- looks like that's probably what would help out here...

GilaMoster, I'm not talking about regular backups. All I'm trying to do right now is get rid of all the unused space in the trans log.

When I do DBCC LOGINFO,...

GilaMonster (6/15/2016)

---

ztoddw (6/15/2016)

---

So it still thinks the trans log backup is still happening? I left that backup running last night and it showed backup successful this morning and I...

It shows :

select log_reuse_wait_desc from sys.databases where name = 'Lobby_queue'

LOG_BACKUP

So it still thinks the trans log backup is still happening? I left that backup running last night and it...

Thanks y'all... so now I have backed up the transaction log, and it shows in the disk space report that the trans log has 99% space free, but when I...

I sort of found an answer- On the Job Step Properties --> Advanced, if you check the box for "Log to table", then once it starts running, you can click...

Thanks for the bug report Jeff- it's awesome when folks help me test. Got that fixed. I didn't realize Sql Server had the little quirk with the len...

I admit I don't know for sure that it's more efficient- it just seems like your solution was doing more work than it needed to- although I'm not sure since...

This way is probably more efficient-

declare @STRING varchar(1000);set @STRING='100010111100010001';

select pos=ltrim(str(n))+'-'+ltrim(str(len(sub)-len(ltrim(replace(replace(sub,' ','~'),'0',' ')))+n-1))

from (select n=number, sub=substring(@STRING,number,len(@STRING))

from master.dbo.spt_values where type='P'

and (number between 1 and len(@STRING))) t

where (n=1 or substring(@STRING,n-1,1)<>'0')

and substring(@STRING,n,1)='0'

This looks simple-...