Sure. If you have access to Enterprise Manager, you can easily change the column names. Keep in mind, SQL will allow you to use spaces - as long as you use brackets - I just find it to be extra work.
To change a column name,
1. Open Enterprise Manager
2. Register your server (if this has not already been done)
3. Expand the server and database directories and click on 'Tables'
4. Right click on the appropriate table and select 'Design Table'
5. Change your column names
Just be careful to take note of any dependent objects such as Views and Stored Procedures. These objects will not be automatically updated so you may want to analyze the amount of work this will include before taking on a 'renaming' task.
Good luck.
Michelle