I would suggest to select only tables from sysobjects where type = 'U' if you want to update statistics by table (why not using sp_updatestats? This operation is pretty improved...

Thanks for fixing this bug.

I didn't put this into a stored procedure, because it's already isolating the current database (DB_ID() part)

The incorrect syntax issue is indeed caused by the...

Hi,

Your first impression was, ok. However, this is the correct procedure:

ALTER PROCEDURE [dbo].[usp_GetBrentDraegerMdaData]

@Columnnames nvarchar(max),

@Tablenames...