alternative option means ????...

you can test it with actual execution plan . that will give you exact picture what/where/why any object...

you can also directly test the stored proc at mgmt studio with the passed parameters...

sandeep.vemulas (11/21/2012)

---

hi,

its returning first select statement values.

means if u changed the positions of select statements then also its displays

select stmt values means which one first the values r...

this would be the first assured and positive impression that data...

below is the two sql i seperate .

ALTER procedure [dbo].[usp_Fixtures_BowlingAverages_Client]

( @Fixture_SeasonKey int,@Fixture_TeamKey int,@Fixture_FixtureType int)

as

begin

Select (cast(Max(D.Bowling_Wickets)as varchar)+'-'+cast(Min(D.Bowling_Runs)as varchar)) as Bestbowling

From InningsBowlingDetails D

JOIN (Select D.Bowling_MemberKey, Max(D.Bowling_Wickets) as Wickets...

your question depicts that...

anthony.green (11/20/2012)

---

Bhuvnesh (11/20/2012)

---

tonyarp05 61903 (11/20/2012)

---

We are developing one tool(Backend : SQL server), that tool should be search the string from entire database.

But i have some codes,which takes min 30 to...

tonyarp05 61903 (11/20/2012)

---

We are developing one tool(Backend : SQL server), that tool should be search the string from entire database.

But i have some codes,which takes min 30 to 45mins.

Even i...

can you post here, your databases configurations (their size ) ? additionally also check if there are any open transactions or not ? tempdb handles alot of stuff...

So whats your requirement then ..Sorry i havent able to retrieve anyting from your miles- long script 😛 . you only need to post the stpred proc (which is...

Please explain 🙂

see " user must change password on next login" in attachement

I guess you have chose the option of

thats why it is asking for change password on every time. see this http://technet.microsoft.com/en-us/library/ms144284.aspx

are you using database mail ?