I also have this problem, but to get around I go to the home page first then resources

Thanks Jeremy, but I don't think Shrinkfile can be used in 6.5, I have seen an option called ShrinkDB, maybe this is what I need?

The company I work for has several databases on a SQL Server Cluster, each database belonging to a different contract. To get downtime to apply Service Packs, all of the...

Sorry Tim, got the wrong end of the stick!

Pete

Here is an example of using the Case statment in a stored procedure.

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS OFF

GO

ALTER PROCEDURE NEWINSTRUMENT @QTY int AS

DECLARE @InsertCounter int, @RndNum Int

SET...

Can't do UDF's in 6.5. Could I do this in a stored procedure using a cursor maybe? and if so how do i do it?

Thanks in advance

Pete

Thanks Andy, but how do I use this against all the product codes in the column in my Table (SQL6.5)