I think you pulled the SP1 from the end of the string which belongs to the OS version.

You are running 2008...

Rob Schripsema (4/8/2011)

---

So, somebody asks us a question, we give them the right answer, then we find out we're wrong because they really meant to ask us a different question.

Sounds...

That is an interesting solution, but we don't have specification for how the situation should be handled, maybe they want it...

First, thank you very much for providing the DDL and DML to help us help you. The only thing you could have done better was to provide an example of...

Argh! How does something this simple and wrong make it through. Did nobody actually run the code prior to posting the question? :w00t:

Steve, oh Steve, Cleanup on isle 42.

You could try attaching copies of the master DB on Server B, but it is very unlikely to work.

You can rebuild the master database, but you would loose anything you...

You could probably write a TRIGGER that checked how many sessions a user currently had, and ROLLBACK the current conection if they were over your limit.

Actually if all you want is the count of unique users, don't return them and spin through them that just wastes network bandwidth, etc.. Use a COUNT query instead:

SELECT

...

First, did you really upgrade without testing first? :crying:

We ran into problems with jobs, especially...

I think it is intersting that we have recently had a rash, at least 3, people reporting large tempdb usage after upgrading to 2008 R2 from 2005...

If updating the statistics doesn't help you might look at installing one of the newer CUs for 2008 R2, I know that we had to go to at least CU4...

As much as you...

I assume what you are trying to get at is that the "data...

Steve,

The way I saw...

thamatrix1436 (4/7/2011)

---

Thanks for the attempt UMG Developer. Still coming back with the same error. Getting some of the records back, but the majority are falling out of the result set...