Makes sense to me.

Sounds like you're getting an incorrect error message, but anything I say at this point would be guesswork. That sounds like something that'll require access to the actual code...

Shouldn't have any measurable effect on performance.

You're welcome.

Yep, and you're welcome.

Yep.

There are definite weaknesses in the wizard and the plan builder. I prefer custom code for that kind of thing. The plans are great for new DBAs who...

The questions on accounts will depend on your security needs.

It's doubtful that you'd need different accounts for the same service on different servers. You might, if they need to...

You're welcome.

He left out an open-bracket on it. Should be:

declare @proc sysname

set @proc = 'InsertWarehouseCountExisting'

SELECT schema_name(sp.schema_id) [Schema], object_name(sasm.object_id) [Procedure]

FROM sys.all_sql_modules sasm

INNER JOIN sys.procedures sp ON sasm.object_id = sp.object_id

WHERE sasm.definition like...

I can't share my company's documents, because they are IP of the company. However, I can say, the best place to start is probably MSDN. They have a...

This seriously looks like homework. Is it?

The way I'd do this is build a CTE that uses the Rank() function to rank the titles by price within each subject,...

To answer the original question: Yes, you can build in eval and port to full. I believe an in-place upgrade is allowed. If not, you move code/objects from...

I'm used to cursors working with "while @@fetch_status = 0" instead of the nested version you have.

What is it you're actually doing with the cursor? Most likely, you're going...

It might matter, if the application somehow ends up receiving those as output from the stored procedure. I've seen problems like that with procs that don't have "set nocount...