I forgot to mention that you can also query the information schemas to get quick access to detailed table and column information.

SELECT *

FROM INFORMATION_SCHEMA.COLUMNS

You will not be able to get away with this one, using your current methodology. You will have to use dynamic sql, unless anyone else has other options.

IF EXISTS...

I would include some logic to prevent the sp from being created in the system databases. I would also check for existence; otherwise, you can get an error.

sp_MSforeachdb

'USE...

I feel obliged, for the sake of accuracy, to point out that although your co-workers steps for adding a column to a table bear an eerie similarity to the scripts...

I dont think it matters. The service pack should update on a per instance basis. Meaning when you install service packs it will update all nodes for that...

Are you trying to search for 'cat' in a particular column or every column of every table? What exactly is the purpose for this search?

Good point Michael. If positioning of the column is needed, the alter statement will not help you.

You may want to turn on profiler and catch what is going on when the stored procedure runs. this way you can see what the memory,io, and locking really...

Thanks for doing the legwork :). I have been learning a lot of new stuff, in the past few days 😀

Adam, i think the whole drop thing and rename etc is only scripted by SSMS when you alter a column (create new table with new structure, copy accross the data,...

Simple recovery does not mean the log is not used. If transaction were not logged in the t-log how would you rollback transactions? This is why the t-log...

Chris,

The reason the developer prefers this method is Microsoft creates its change script just like this. If you make a change to a table via SSMS, a create change...

Not quite.

Basically the question is can you put this into over().

sum(werksmassFM / (Sum_Lmenge.SumCol/ls.lmenge)* p_transpreis)

Matt, can you use over with the sum of a calculation? I have never tried, but I believe the over is used for deterministic columns. Like I said...

This will only work if you use a group by in your query. You cannot perform aggregate functions without a group by, if multiple...