You're welcome, HTH 🙂

Rich Yarger (8/2/2011)

---

I just recently upgraded a database from SQL 2000 (80) to SQL Server 2008 R2 with a process that I created in T-SQL. It was well worth...

paul.knibbs (8/2/2011)

---

Having done an upgrade from 2000 to 2005 with a similar procedure, I can say that leaving the database in compatibility mode for an older version does NOT ensure...

You're welcome, HTH 🙂

It sticks. Transaction isolation level persists at the session level.

Here is a quick PoC to demonstrate how it works:

-- set to traditional default before we get started

SET TRANSACTION ISOLATION LEVEL...

Nope, you can flip the mode back and forth:

ALTER DATABASE [insert db name here] SET MULTI_USER ;

More info...see example J:

ALTER DATABASE

PS You provide quality advice here so I'm asking for an opinion, even if it's just an abstracted thought on the topic based on your overall knowledge and experience. I...

Thanks for the reply. A migration from 2005 to 2008R2 is planned but it was proposed that all DBs stay in 90 mode to expedite the actual upgrade, i.e. leaving...

To clarify, does the job ever report success or failure or will it simply show as running indefinitely until you manually stop the job?

Here is some very good (and free) online material:

Windows PowerShell Overview and Tutorials

From the xp_logininfo documentation here http://technet.microsoft.com/en-us/library/ms190369.aspx

If account_name and members are specified, a list of the next-level members of the group is returned. If account_name is a local group, the listing...

ALZDBA (8/1/2011)

---

apparently you are living in a world where users have a fixed UI date time representation.

( so far for "personal" computer )

Alter these queries so you don't need the...

Jeff Moden (8/1/2011)

---

I believe you used the wrong column in your examples for this problem. If we're still talking about the original problem, then SomeDate in JBMTest is the...

Jeff Moden (7/30/2011)

---

Heh... understood. Someday, we'll have to sit down, have a beer or two together, and I'll try to explain it all. It won't change your mind...

I'll throw in another potential reason why a persisted indexed computed column would be good for this.

Let's take your test table Jeff and see what the user's current query will...