yes correct as Gail told enterprise edition took online recovery while restart the server..

Standard Edition few months back i noticed that recovery on offline mode on Transaction log file 35...

Resolved that isssues due login permission CONTROL and ALTER with master database

Revoke ALTER and CONTROL permission in Master database.. after that SQL Services started successfully..

Thanks

No more problem addressed even query working fine with 00:00:02 seconds and DISTINCT cost 72%..

Thank you..

Hi, ChrisM@Work.. wow what a understand that update query logic..Absloute correct...

Hi, Eric M Russell.. SSMS - actual execution plan suggested to create one Non clustred index, that was created... (index...

ok.. I will update you once getting from Dev.Team for the all details..

thanks

ananda

Thanks

same error

exec sp_temp @count

Msg 137, Level 15, State 2, Line 1

Must declare the scalar variable "@count".

exec sp_temp @count

--Msg 102, Level 15, State 1, Procedure sp_temp, Line 2

--Incorrect syntax near '='.

also tried as below code

alter proc sp_temp

@count INT OUTPUT

as

begin

declare @Result varchar(5)

select @count = COUNT(*) from...

Thank you for valuable reply..

In this situation, what will happend Logshipping in standby database..

still continuous apply the log or wait that query execution completion then next log will be applied...

Hi,

The problem is not yet resolved for Permanent solutions. today also facing same error...why backup SSIS package gets courrpted?

thanks

ananda

Executed as user: ExpSQLAgtSvc. Microsoft (R) SQL Server Execute Package Utility Version...

Hi balasaukri,

How many array controller have in your physical box? for the tempdb location, what is your RAID configuration? is it RAID 5 +1? it means RAID 5(striping with mirroring)...

ok.. could you confirm the above wait_stats_s values normal or not? on OLTP database.

Hi Chris,

Index created,

CREATE NONCLUSTERED INDEX [IX_VIEW_IP21] ON [dbo].[RESULT]

(

[SAMPLE_NUMBER] ASC,

[STATUS] ASC,

[ANALYSIS] ASC

)

INCLUDE ( [UNITS],

[NAME],

[NUMERIC_ENTRY]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF,...

Hi ChrisM

RESULT Table having 3 NC index and 1 clustred index available already..

if created another one more NC index as you suggested, it will be overlapping on existing one.. pl...

thanks Gail & Chris

Query still there is no problem and working fine....