Thank you, I ran it and under o open transactions is 0, anything else I should pay attention to?

Also, if I re start sql agent my temp db, should get...

How can I check long pending opened tran ??

Thank you

I have 24Gb now, is this enough??

I shrink tempdb and on drive still the same size,but when I check on properties for data and log, it got smaller, what else I need to do for temp...

How can I fix this problem? Primary filegroup is full,

Sorry,

LEFT(LTRIM(RTRIM(SUBSTRING(prefix,7,4) + phone)),20)

If I get prefix null,this formula won't work,how can I work around it?

Thank you

Thank you, the code is working but not 100%

Here is my data 794546,794548,794549

Results I get:4 794546,794548,7945

Thank you very much

I get error message

Incorrect syntax near ')' and MID is not recognized function

can we use MID there?

What can I use instead?

Thank you

Thank you

Thank you

Thank you so much, should I always keep this option unchecked?

Thank you

Thank you, I only have string data coming

Thank you