Well there you have it, from the man himself!

I have been looking at swapping out my backup process to start using your database backup process Ola, but as with anything...

While tightening up a client's instance I wanted the backup task to have this ability as well...and wondered why the option was omitted. I looked into it for a little...

Yes, they installed without issue. Note that 64-bit connectivity worked fine.

Did you find any errors in the error...

GilaMonster (9/11/2011)

---

Looking at the error, it appears to be something to do with the statistics (which checkDB doesn't check). Can't tell more than that, CSS can debug system asserts cause...

Track-back therad may be helpful:

http://www.sqlservercentral.com/Forums/Topic1173055-1526-1.aspx

This article from MVP Dan Guzman may be helpful. I refer people to it often for questions like this. It is a generic approach to using schemas for object organization...

Thanks Gail.

CHECKDB ran clean on the 7th. I may run it again tonight just to see.

These databases are on their way to a 2008R2 instance in the coming weeks so...

Hassle2 (9/9/2011)

---

Hello,

I am experiencing a strange problem. We have a database that had been migrated from 2000 or 2005 to 2008 about a year ago.

User A is a member...

stevehindle12345 (9/9/2011)

---

Ah, so this only remaps SQL Logins. Is there a script available for Windows logins or if a Windows login is deleted and recreated before a restore would you...

stevehindle12345 (9/9/2011)

---

More wondering really.

I agree, my understanding is the SID is brought down from AD upon creation within SQL so if it's in the same domain and the account...

Thank you for all your responses. We tried the backward cmopat tools, and check the client protocol order. We also tried forcing the protocol to test tcp, named pipes and...

YSLGuru (9/8/2011)

---

opc.three (9/8/2011)

---

In my opinion you have the best case scenario in terms of being able to associate every DB session with a specific person. In my experience most applications...

dbo is a database-level principal. To my knowledge it will not track "upwards" to the Server Login to gain the caller bulk insert permission.

In my opinion you have the best case scenario in terms of being able to associate every DB session with a specific person. In my experience most applications do not...

Another option is to have a DDL trigger fire on the CREATE_LOGIN event to alter the login immediately after it is created.

This has some valuable insight into what event data...