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....

Problem is need to check other table stats and will update it. not in RESULT table stats.

as per query that well parameterized and again index seek 50 %.. please explain...

I modified Query as per your suggestion and fetching result 00 seconds..But NC clustred index seek 50% and .. what could be issues?, Need to change index column? and all...

thanks for reply... I got the result 00:00:00 seconds after update stats in NC Clustred Index in RESULT Table..

yes, we are using windows 2008 operating system...

SQL Service account running under windows local users.. But domain users are added into SQL logins for connection between database and application...so in...

thank you Mr. Johan,