Use a Matrix to pivot your data on the years and add three rows to the detail section of the matrix, one for each of your columns.

The answer is no.

Different Editions of SQL server use the same install. You will also have major issues with figuring out the service pack of a particular server by...

To be a bit safer, you could use the else of the IF statement

[font="Courier New"]IF @@ServerName = 'ProdServerName'

RAISERROR('Hey dopey - this cannot...

You probably had a batch separator between the error message and your subsequent statements (either GO or ;).

GO will make the actions two individual executions, so something after the GO...

If I understand you, you want to prevent a particular script from being run on your production servers because you have some developers that are - less than careful.

Something like...

Nope.

You could use sp_msforeachdb

However, it is only 40 checkboxes in a single dialog, so I would just click them.

SSIS is very data type sensitive.

It is also CASE SENSITIVE, ACCENT SENSITIVE, and SENSITIVE TO TRAILING SPACES.

In your T-SQL join, your collation settings on the columns are used, they are...

As an aside, with a little work you could create an example to show the developer. Using Merge Replication requires about 5 lines of code and the replication wizard...

If this is new development, you should do your best to convince the developer to use a SQL Server Compact Edition database (assuming this ends up a single-user application on...

Search this site for padding numbers.

You should find some options such as:

RIGHT(SPACE(10) + CONVERT(VARCHAR,MyNum),10)

There are some more creative ways and probably some good functions if you do some searching.

If it...

Simple vs. Full recovery will not make a difference. Both actually log transactions, Simple just truncates the log at every checkpoint.

You need to look at the execution plans. ...

You need to go find an MS Access forum for this type of question. This has nothing to do with SQL Server.

I think your DCount function is wrong.

I think...

What error is it giving you?

You could use mirroring for DR, but my preference would be to use an Active/Passive cluster.

The option to use - including the option of using partitioning is going to heavily...

Like I said, keeping it simple, doing a backup and a restore would be simple, easy, and probably end up the fastest solution.

The SELECT INTO option suggested could work, but...