when i tried to run the below query gets the warning message

Warning: Null value is eliminated by an aggregate or other SET operation.

SELECT

S.StatisticsStartTime,

S.EquipmentNumber_FK,

isnull(MAX(S.StatisticsEndTime),0),

isnull(MAX(E.EquipmentClass_FK),0),

isnull(MAX(E.RemoteMonitoringType_FK),0),

isnull(MAX(E.AnalyzerType_FK),0),

isnull(MAX(S.TotalStarts),0),

isnull(MAX(S.TotalRunTime),0),

isnull(MAX(S.DoorOperations),0),

isnull(MAX(S.Knx3NbrRelevellings),0),

isnull(MAX(S.CreateDate),0)

FROM KRM.dbo.ElevatorTotalStatistics S INNER JOIN KRM.dbo.Equipment...

There is a SP running and its very big to paste it here. But can anyone tell me why its coming and how we can overcome with this. It looks...

Thanks for your response. Now its resolved

Thanks Steve for the solution provided. It has worked as expected.

Thanks again

but when I tried to use the below query

IF ISNUMERIC('$123432345')=1

SET @profile = 'NUMBER'

ELSE

SET @profile = 'CHAR'

SELECT @profile

it is also returning number even though its having $...

Can anyone give the solutins for the mentioned 4 points in the previous

Regards,

Naveen

Thanks I got by changing the permissions. But I feel when we give it to users, they may not hav the full permisssions and in that case it will not...

When I am performed the below steps I found the error "Could not find index entry for RID 16b676fd5b010000 in index page (1:116) index id 0, database dbname.

1. changed the...

I exeucted DBCC CHECKDB (dbname, repair_rebuild) option but it is throwing the same error:

Server: Msg 926, Level 10, State 1, Line 1

Database 'Test1' cannot be opened. It has been marked...

When I executed the DBCC CHECKDB(DBNAME), getting the below error

Database 'Test1' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

Can you...

Now I have created a new database with same mdf and ldf file names. Then replaced those files with my old files. After that when I opened my Enterprise Manager...

I dont have the backup to restore it

Yes, that is the entire contents of the log file. So not clear where it is failing.

Can you tell me what are the possibilities.

Thanks in advance

Checked the report and logging icon and found log extended information is already selected. The error description which I sent is from that log file only.:-)

Can you please tell me where extended logging button is available in SQL Server2005.

When anaylsed further, I found another message:

Date27/05/2009 22:00:00

LogJob History (OnePoint - Check Integrity)

Step ID0

ServerC134PC001\PC001

Job NameOnePoint -...