Andreas.Wolter (10/10/2013)

---

hanrahan_tim (10/9/2013)

---

Hello,

...

My thought is to use an AD account like "authenticated users" and use this for logins so all company users get a login. I would then use specific...

From the messages, the SQL server Execution times when the temp table is loaded is where the time difference is.

On average the diff is:

For CPU time: 38%

For elapsed time:...

I did find this in the log.

Configuration option 'user connections' changed from 20 to 0. Run the RECONFIGURE statement to install.

But there is no log entry where it is originally...

That query returned:

user connections

value: 0

value in use: 0

Hi Lynn,

I checked the connections page and maximum number of concurrent connections is set to 0 for unlimited.

Lynn Pettis (4/24/2012)

---

In the Object Explorer, right click on the server, then click...

Chuck Hottle (12/15/2011)

---

I think that you're either going to have to use ownership chaining or grant select on the tables in the other database. If you could add the...

Elliott Whitlow (12/7/2011)

---

1. Integrated security is probably the best but in some cases where the web server or a middleware piece are not in the same or a trusted domain...

SQLRNNR (12/7/2011)

---

1. Yes, integrated is better. Many leave SQL Login enabled as a backup as well.

2. You could try creating a database user for your application without...