Thank you folks for valuable advices.

If you are updating statistics after index rebuilds, you are doing double the work. Rebuilding an index updates the statistics. No need for...

Perry Whittle (6/20/2012)

---

Perry - Thanks for your response.

I am...

I know "where 1 = 1" doesnt make sence but somehow I used it in thread. I was more concerned on the output being truncated then the bug in my...

michael vessey (5/24/2012)

---

michael vessey (5/24/2012)

---

sqlbee19 (5/23/2012)

---

michael vessey (5/23/2012)

---

the multiple rows returned in your select statement are corrupting the @cmd value - in theory the value returned should be correct (although...

mkalyana.murugan (5/23/2012)

---

Hi All,

In my server I have totally 100 databases on which 7 are core databases. Meaning all the 93 databases will fetch/refer the data from the 7 databases. The...

awesome Lowell.

It works. Thank you.

michael vessey (5/23/2012)

---

the multiple rows returned in your select statement are corrupting the @cmd value - in theory the value returned should be correct (although if you use any fields...

thanks

Thanks Anthony. The reason I am looking for log file because SQL doesnt put complete log in table as it will be truncated after its limit.

If I am understanding you, you do not want to allow the token for the Windows User logged into the desktop app to all the way to the daabase because...

Thanks for your responces.

Here are more details:

The app I am reffering to is VB 6 Desktop application. We have a middle tier server where we have all VB6 application binaries....

Yeah I agree.

The solution I am looking is for Application level access.

For example :

We have appliction X and we have 1000 end users to that application. When ever users use...

Gsquared - Thank you very much for guiding me on this.

The issue has been identified as Parameter sniffing.I solved it by changing procedures code in such a way that SQLserver...

Thanks Folks. I will go with creating a SQL and will ask everyone to use as owner of jobs.

Thank you. Will update the thread with my findings.