Cheers Guys

Thanks for your help

David's Query works perfectly

SELECT count(distinct(performed_by_user_id)) as 'No of distinct Users',

CONVERT(varchar(11),event_date) as 'Date'

FROM tablename

WHERE condition

GROUP BY CONVERT(varchar(11),event_date),CONVERT(varchar(10),event_date,120)

ORDER BY CONVERT(varchar(10),event_date,120)

i had tried that already but the problem i have problems as in message below

Column name 'tablename.event_date' is invalid in the ORDER BY clause because it is not contained in...

Could the folling be something to do with it ?

FROM BOL

Quoted identifiers are used by default in SQL Server 2000, that is, they are set to ON. This is different...

The Procedure is being run against a sql 7 Database. The only thing different is that is that its now being run using SQL 2000 Analyzer.

CREATE PROC DBO.Copydb

@TARGET_DB VARCHAR (100) = 'SDS093.COPYTEST',

@SOURCE_DB VARCHAR (100) = 'SDS_DBServer.DBNAMEOUT' ,

@PROJECT2COPYVARCHAR (100) = "'-'" ,

@PROJECT_LISTVARCHAR (255) = "'-'" ,

@LANGUAGE_LISTVARCHAR (255) = "'-'"

AS

DECLARE @TSQLSTMT VARCHAR (3000)

--...

The process above is implemented on all production servers. Even though all documentation says that full log dumps are being carried out every 15 mins.

From what i can see full...

Am i missing something here ?

Sorry i forgot to include a Question mark.

For SQL Server 2000 Enterprise Edition, is the following the full list of Service packs + Hotfixes etc ??

You should be able to just unclick the identity property in Enterprise manager and click save.

I Would generally unload to a temp table drop table, create altered table and reload...

Is there a trade off, if you are using monitoring software, because of the monitoring tool using resources ?

Has anyone used Hfnetchk ?

This problem came about WIN2K settings were too tight. is there any doc etc that detail how to lock down NT without causing problems to SQL ?

September 25, 2001 at 9:08 am

#418449