We would need a lot more information to help you here, but it is probably not worth trying to solve in a forum. Take a look at this book,...

Ok, well the issue then is not permissions, but the queries and overall design of the database/procedures.

I'm not sure I understand... However, the issue is timeouts from users that use an application and the application user is this srclogin?

Well, I might have made an @$$ out of...

dan-572483 (7/10/2012)

---

Questions about Dev edition licensing:

1) Are licences assigned to the server or a particular person/developer? If we have a team doing DEV/QA work, can they all access it...

See the link in my signature by Jeff Moden if you need examples on how to post here.

We need more information. Please provide DDL and sample data along with expected results for that sample data.

mark.dba (7/10/2012)

---

I have successfully downgraded about 20 servers in our environment. I am working on doing the same to the clustered ones too.

I tested cluster downgrade on a test...

Maybe so in terms of features. However, it is...

It would help if you showed the script used in the job step.

I can tell you from experience that there is no downgrade path. Even though DEV has all of the features of Enterprise, it is considered a downgrade and does...

GSquared (7/10/2012)

---

SQLKnowItAll (7/9/2012)

---

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. I...

Hmm... So, because it worked on a set of 3 records you will accept it? Do you even know what that is doing? Do you...

Jeff Moden (7/9/2012)

---

In 2008 or less, I'd REALLY like to know how to create a view that does a running total without forming a Triangular Join. I don't believe...

ScottPletcher (7/9/2012)

---

SQLKnowItAll (7/9/2012)

---

ScottPletcher (7/9/2012)

---

SQLKnowItAll (7/9/2012)

---

What am I missing... How can...