What does SELECT SERVERPROPERTY('Servername') return?

Alan, like AJ Ahrens says you do not have the updated version of Books Online. You can download it from http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp.

You can also see the online version topic...

I think the process described in KB http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q246133 should still work. I am referring to the second alternative, where you create a procedure in master that outputs T-SQL commands...

Please post an update here if you give it a try.

UPDATE STATISTICS tablename WITH FULLSCAN

Note however that I am only recommending this since I get the impression you have a huge maintenance window. On a large table this will take...

Yes, I have no doubt that SP4 solves a lot of bugs and issues with AWE memory incl those you linked to. However, what I am pointing out here is...

Well each modification every hour will not trigger a recompile. Assuming your table has more than 500 rows, the stats will need to be updated when there have been a...

> I wanted to ensure that my understanding of optimisation is correct, that if I execute the 3 steps above in sequence, whatever database tables I execute them on will...

Are you looking for something like this?

ALTER PROCEDURE [dbo].[pr_tbl_CAP_Insert]

@sShortDescription varchar(50),

@iScoreID int

AS

INSERT [dbo].[tbl_CAP] ([ShortDescription], [SubjectID])

SELECT @sShortDescription, SubjectID

FROM tbl_UserAssignment

WHERE tbl_Score.ID = @iScoreID

-- Get the IDENTITY...

Ok, then it involves doing text parsing of those queries. That is generally something that I personally avoid doing in T-SQL, since it is not really very good at it....

> 3. Each procedure will have had it's query plan regenerated with the most to date update index/stats information and so will execute as efficiently as it possible for it...

What do you mean exactly? Is this a query that is stored somewhere and you want to parse it?

> I just have to make sure, becase I dont want to get kicked for this if I screw up our business core on the production server.

You could always test...

Without more information it is difficult to say much. Here is some information: http://support.microsoft.com/default.aspx/kb/890637

petmani, Microsoft recommends that you do not install SP4 on a server with more than 2GB memory and using AWE.

Warning: Microsoft has found an issue with the final build of...