Cast to string, check if it's 1 character, and if so, add a "0".

It returns a number. "01" is not a number, according to western math.

Do you mean database backup only and not server backup?

Pretty much everything is stored inside SQL Server. If you restore master and msdb, you have covered all the issues with...

I say B. always better to keep your process and add to it, IMHO

It's mostly a visual language where you connect tasks on a designer and make property adjustments. Many of the scripting items have helpers that let you "build" an expression. however...

We'd like to see you make an attempt. Basically you are attempting a cross tab, so if you search for help there, that might work for you. Or look at...

I think you are reading too much into the wording. There is a Repair_allow_data_loss operation as part of DBCC CHECKDB. Yes, it is a parameter, but the author appears to...

I've seen lots of people use replication to do just this.

When you talk about code, are you looking for mistakes, like Spelling? The easy way to introduce custom code is...

Yes you can, look up the MCTS or MCITP certifications. you can specialize with SQL Server. For 2005, the base test was 70-433, and it has a good portion of...

http://www.mssqltips.com/tip.asp?tip=1046

I'll add this to our list.

And, unfortunately, I think some of these companies decide that they'll let some data get stolen, and deal with a few people rather than protecting it because of the costs.

Some...

I don't have much experience, other than as a client, but I'll let you know that we have a bunch of nHibernate here. It made the initial development quicker, but...

We'd like to see you try. This isn't consulting where we do the work, but rather where we help.

If you need to summarize data, you can use COUNT() or SUM(),...

It might be because it partially ran before? Are you sending to a brand new database? That error looks like an error with a naming collision.

Reporting Services (and Analysis Services and Integration Services) are parts of the SQL Server platform. They come for free, but you have to buy and install a SQL Server license.