50 users on SQL Express is almost certainly your problem. It can really only deal with about 5 at a time. It's got throttles in it that are...

And have the AD accounts been granted any rights that allow viewing database objects? Explicit grant. Or has the other account been denied such rights explicitly?

You're welcome.

Cool biz.

What you're almost certainly running into is "parameter sniffing". Gail (GilaMonster) has a blog post that explains that nicely. Go to http://sqlinthewild.co.za/ and take a look.

Is the AD group part of any server-level roles?

How many users at a time?

It's really interesting how many things he has wrong in that.

CirquedeSQLeil (11/4/2010)

---

Grant Fritchey (11/4/2010)

---

CirquedeSQLeil (11/4/2010)

---

Has anybody here contemplated changing their name (besides bob err ".") for the forums? I am curious if anybody much cares about the confusion that...

Why so procedural?

Why not just do the insert, and let the Where clause filter it all for you, instead of all those IF statements?

Can you pull partial data sets from the DB2 server easily?

Instead of one query with a string of "IN" values, open a cursor and select the values from the DB2...

That function is going to get really complex really fast if the data in the column has a complexity much higher than 2 numbers and one mathematical operator.

And what does it contain? The number of seconds they were online? Minutes and fractions thereof?

You're welcome.

Randy Doub (11/4/2010)

---

You might want to consider database mail as a way of sending faxes. You have a lot of flexibility, even passing a query to the senddbmail method. It...