umm thats odd thanks for your help. Trying to remeber how i created those stats now maybe i did it with a script or something funny??? Pretty sure they are...

here the error message i was getting. As i said earlier i only starting getting this after we upgraded to 2005

Msg 5074, Level 16, State 1, Line 1

The statistics...

--This code will drop all stats on a given table/column combination

declare

@TableName varchar(50), @ColumnName varchar

thanks a lot for this i will sort out he dynamic drop commands from this.

stats were auto generated and the error is a dependency issue. It says i cant drop the columns becasu ethe stats are dependednt on it. if i drop the stats...

----------------------

------DDL-------------

----------------------

create

table customer(

CustomerID

int,

CustomerName

varchar (20),

is there a db wide setting wich i can set so that the stats will be automatically droped?

i dont think it is the report cach e because the report refreshes fine if i reprocess the cube . How do i get the cube to show incremental changes...

But isnt it possible to make the cube real time as in jholap or rolap which listens for changes and updates automatlically? Is this not possible if your dimensions and...

Jeff how would you do it with a function?

Not sure about DB2 but this solution is fairly 'ansi'. And should be alot more efficient than a looping structure.

------------------------------------

if object_id('a') is not null -- Drop Test Table

drop table...

Strange it appears to see the 2 as part of the sp name rather than as a parameter

try this

Create procedure [dbo].[usp_GetErrorLog] @servername sysname

AS

SET NOCOUNT ON

declare @sql varchar(100),...

nope thats why i said probably.

Would be interesting to see, if you have time.

I suspect it would be faster because no joins are required particulary no outer joins.

Perhaps the...

or if you are on sql 2005 you can use

select EmployeeName ,DOB

from Employees

EXCEPT

select EmployeeName ,E.DOB

from modulelog

Probably more efficient

Turns out it was because setup.exe was contained in the "" works fine if i navigate to the directory first.

Thanks,