Viewing 15 posts - 736 through 750 (of 1,790 total)
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 4:00 pm
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 3:57 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 3:47 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 3:30 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 2:54 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 2:37 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 2:31 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 27, 2009 at 2:22 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 26, 2009 at 6:18 am
Kendal Van Dyke (2/19/2009)
Perry Whittle (2/19/2009)
Great blog Kendal (you have way too much time on your hands 😀 )very informative
Thanks for the positive feedback!
I posted part 7 this afternoon. Wrapup...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 19, 2009 at 3:35 pm
Steve Jones - Editor (2/19/2009)
And after lunch, I'm lost again in this thread.
Yeah if you step away for more than a couple of hours you have to go back 3...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 19, 2009 at 1:58 pm
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....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 19, 2009 at 11:47 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 19, 2009 at 10:09 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 19, 2009 at 9:56 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 18, 2009 at 6:30 pm
Viewing 15 posts - 736 through 750 (of 1,790 total)