Running MSSQL 2000, I get

[font="Courier New"]Server: Msg 208, Level 16, State 1, Line 2

Invalid object name 'sys.dm_db_index_usage_stats'.

Server: Msg 208, Level 16, State 1, Line 2

Invalid object name 'sys.sysobjects'.

Server: Msg 208,...

With a few changes, it runs on SQL2000: (table names go into the WHERE clause on line 35, eg 'tIndividuals') - Merci, Jean-Pierre - RM

--Jean-Pierre Lebrasseur

--date 04-12-2009

--this script give you...

I am intrigued by this thread, having worked with Access front-ends for some time. Would you mind posting the stored procedure code?

Rob

Favorite interface: the Taelon's computer which responded to hand gestures and summoned a holographic console (Gene Roddenberry's Earth - The Final Conflict)

Rob Maurer

I ran the original code and got this error (v2000)

Server: Msg 2812, Level 16, State 62, Line 7

Could not find stored procedure 'msdb.dbo.sysmail_help_profile_sp'.

Server: Msg 2812, Level 16, State 62, Line...

Do you mean that you want to round it to the nearest *tenth* instead of the nearest *ten-thousandth*?

I like this approach: In the stored procedure, DECLARE a temp table and fill it by SELECTING the first set of records (A), then UNION that recordset to a second...

Sorry I'm slow. What's BI?

I use this to accomplish a similar goal:

ALTER FUNCTION dbo.CurrentUser ()

RETURNS VARCHAR (50)

BEGIN

DECLARE @sys_usr char(80), @name char(50),

@pos int, @length int

SET @sys_usr = SYSTEM_USER

set @length = len(@sys_usr)

set @pos =...