CTS is a very specific and often misdiagnosed injury. Please make sure your doctor does an NCV to confirm that you have CTS.
Also, although repetitive and traumatic activities casue CTS, there are a lot of underlying conditions that also cause CTS (diabetes, obesity, pregnancy, hypertension, thyroid problems and rheumatiod arthritis come to mind), for that reason your doc should eliminate the underlying conditions as the cause (if he doesnt the CTS will re-occur).
The only reason i mentino this is because if you have tendonitis (which is painful and suuuucks and takes forever to resolve- I have tendonitis) and you have CTS surgery, well, it won't help.
Also there are a lot of way to treat CYS without surgery that your doc will probably try - cock-up wrist splints, injections and exercises.
If you do need CTS surgery depending on the surgery (open or endoscopic)you will likely have almost immediate relief of the CTS symptoms, and you may be able to go back to your usual work in two to six weeks (depends on what you do) but if you are talking about weight lifting but it could take up several months to completely heal. They are cutting a ligament (ouch!)
If you do end up with surgery I'd try to get the Doc to refer you to "work hardening" or Physical therapy" - it's like having a personal trainer get you back into shape after surgery and they make sure you have proper form and it's covered by insurance.