I agree...but some things are worth mentioning explicitly.

Make sure to remove / change email addresses etc.

It's a simple point, but could have horrible consequences if overlooked.

you also may wish to google SSIS 0x800A03EC

There are issues around excel automation with interop running on a server.

good luck.

I reckon it's to do with the fact that when you schedule with a job, it runs under the sql agent service account. This means different permissions and a...

The advertisement which follows suggests that you can

"....reduce mistakes with Contiuous Integration..." but apparently not spelling mistakes! (Continuous.)

But unfortunately h.parajuli cannot spell CALENDAR.

Not sure which one works...but h.parajuli can spell BUSINESS correctly unlike Adrian.

I love it! Especially the conclusion.

It's time we stopped being afraid to whisper the words 'Recursive CTE' for fear of being heard by the RBAR police! 😉

Have...

I strongly suggest then that you keep doing it your way 😉

J Livingston SQL (7/9/2012)

Andy Hyslop (7/9/2012)

It's a little extra work, but I always try to add a new column 'in the right place' where applicable. I concede that it doesn't...

J Livingston SQL (7/9/2012)

as others have already said...the answer is yes.

but why would you...

You can't do it by script, except by creating a new table and inserting into it.

SSMS can help you generate the script for that if you follow Andy's...

excellent 😛

what does na mean?

Thanks....I was puzzled why you introduced underscores into the mix. Would [a-z0-9] not be more appropriate (more restrictive) e.g. wouldn't allow funny characters.