Did you, by any chance, explicitly deny insert to 'public'? What error message do you get?

Hard to tell, but I'd bet one of your @variables is declared as int rather than varchar so the '+' becomes an addition operator rather than a concatenation operator. ...

Did you update the statistics on the DB after you restored it to the new server?

You were running a production system on a CTP release? Those are usually put out so the community can try them out and provide feedback to MS about issues...

So it would have to be something like:

select ProdMonth ,ProdYear from Production

where ProdYear >= cast(datepart(yyyy,DATEADD(yyyy,-1,getdate())) as int)

I second Jeff's suggestion to store dates as dates.

What's the data type of prodyear? If you are comparing an entire date against a column that only contains the year as an int or a 4 position varchar,...

One important point is that SQL Server runs as a service. That service is managed through the SQL Server Configuration Manager. You may have to start the configuration...

You can download the free SQL Server Express software. It has some DB size limitations, but might be fine for what you're doing. SQL Server is more complex...

Can you log on to the actual server the SQL Server is running on during these outages? Is it behaving normally or is it also frozen?

How is the batch being sent to the server? Is it through an ODBC or other connection that may use settings that would override the ones you set? ...

I'm not a network expert, but that doesn't show any of the problems I might have been looking for, though you might want to look at this also:

http://technet.microsoft.com/en-us/library/gg162709(v=WS.10).aspx

Does the server...

Take a look at:

http://it.toolbox.com/blogs/programming-life/tsql-tip-use-nocount-on-19362

This normal best practice.

You might want to check the NIC on the SQL Server and any errors reported by the network gear.

Can you post the code you are using? And if you are using Dynamic SQL, please post the generated SQL.

What does the column hold? If the smallint holds all the appropriate values, I'd go the other way, making the float into a smallint. Float is an approximate...