It doesn't recompile the table but marks all the stored procedures that reference the table you used when executing sp_recompile, for recompilation.

I feel like a technical writer trying to...

Ok. I will have to play more later. They both ran ok for me so I left it at that. Wasn't looking for results.

Your create procedure script will work fine with the #rpt2 table but you need to take the last column out of the create statement as that is the column that...

Try changing the procedure to the following;

IF EXISTS( SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Report_Processing]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)

DROP PROCEDURE [dbo].[Report_Processing]

GO

SET QUOTED_IDENTIFIER OFF

GO...

Unless I am mistaken, you can't "alter" a table variable but you can the #temp tables. So, if that is what you are trying to do it will not add...

It looks like your procedure Report_Processing is trying to alter a #rpt table but you are creating a table variable @rpt. Am I missing something or could that be the...

Are you looking to do this as a one off or a regular process? A couple of options as follows;

-Use SSIS and create a package which will pull that...

From BOL:

If object is the name of a stored procedure or trigger, the stored procedure or trigger will be recompiled the next time that it is run. If object...

You can restore to your new server, make all your changes. Before you copy over the production using the Import / Export wizard or SSIS you can truncate all the...

Kendal Van Dyke (2/19/2009)

Thanks for the positive feedback!

I posted part 7 this afternoon. Wrapup...

Yeah if you step away for more than a couple of hours you have to go back 3...

Tim - I was able to validate that the "Total Avail Mem, KB" from that script is the MemToLeave on a test instance that I have with very little activity....

The answer is.... I don't know. I am poking around at it a bit and will take a deeper look and reply back with what I find.

I am certainly...

Tim - First of all I really like the account name that you have!

Wondering if this BLOG POST helps. Doesn't seem to answer the question completely but seems to...

Michele - Check out the isnumeric function and you should be able to use that to solve your problem.

Glad you were able to find it. I had to deal...