Brandie Tarvin (12/4/2014)

---

Eric M Russell (12/4/2014)

---

I get the impression this is not commonly known, but a SQL Server authenticated user account, even a minimal user with nothing but default public...

Could you possibly have a .bat file that runs somewhere that runs the CHECKDB statement?

A Maintenance plan wouldn't use the PHYSICAL_ONLY option. That is some humans doing.

You guys must live in a perfect world of applications. We have well over 100 purchased apps and virtually none of them use Windows Auth. The user interface...

Jeff Moden (11/22/2014)

---

Markus (11/21/2014)

---

I just tired to have a squirrel user and one small dept. app. user test out the expire users password and it basically kills them as it...

I just tired to have a squirrel user and one small dept. app. user test out the expire users password and it basically kills them as it won't prompt them...

I know you said you were doing this in the early morning with little activity. Just keep in mind that if a massive update, insert, or delete is running...

Markus (11/21/2014)

--------------------------------------------------------------------------------

Our main system was just upgraded from SQL2000 to 2008R2 in May. There was no way to have the user change their password in SQL2000 and/or make it conform...

Just remembered. Our network password sync software system. Next phase is putting the hook into it into SQL Server. So when a persons network password changes if...

Our main system was just upgraded from SQL2000 to 2008R2 in May. There was no way to have the user change their password in SQL2000 and/or make it conform...

The query tool that our developers use do not allow for the use of Windows accounts to query, only SQL Server authenticated IDs.

I guess I fail to see the...

But... this is in case of a disaster... so... how am I supposed to get all of the 50+ jobs from my live prod SQL Server if we have a...

I agree.. that is very strange. Once you fail over SQL Server to the newly upgraded Node the upgrade stuff runs in about 2-3 minutes and you are good...

Pick a very small database and run the Integrity check in Mgt Studio with and without the No info mgs and you will see what they mean. If you...

Jeff Moden (11/14/2014)

---

Part of the reason why this problem is so difficult to nail down is because, in my humble opinion, people don't look in the right spot. Instead,...

My advice to you would be don't skimp on memory. It is cheap and it is the best thing you can do to get good performance out of SQL...