Sean Lange (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Sean Lange (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

I think I know (now) which one you were talking about. I gave...

I would make two changes.

One, I would make is from using master..sysdatabases to sys.databases.

Second, I would use the sys.server_principal and sys.database_principal tables to identify the orphaned logins. I wrote...

Grumpy DBA (2/12/2016)

---

We will be transitioning to "mountain time". Wake up, breakfast, try to get first chair, snowboard/ski until hungry, grab a quick bite, snowboard/ski until the lifts close,...

Sean Lange (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

I think I know (now) which one you were talking about. I gave them my shot in...

Brandie Tarvin (2/12/2016)

---

Honestly, if knowing how SQL Server works is...

Also, you may need to use the ODBC logging to determine what is going on. I had to do this many years ago at a previous employer where I...

Is your server using a case sensitive or case insensitive collation?

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

I think I know (now) which one you were talking about. I gave them my shot in the dark but I...

Ed Wagner (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

I think I know (now) which one you were talking about. I gave them my shot in the dark but I have a feeling we...

Ed Wagner (2/12/2016)

---

Sean Lange (2/12/2016)

---

Luis Cazares (2/12/2016)

---

http://www.sqlservercentral.com/Forums/Topic1760779-2799-1.aspx

I was going to comment on that thread,...

You could use a wild card search on the definition column of sys.sql_module.

I think I know (now) which one you were talking about. I gave them my shot in the dark but I have a feeling we won't know if it...

Phil Parkin (2/12/2016)

---

Hugo Kornelis (2/12/2016)

---

Lynn Pettis (2/12/2016)

---

It's them. They asked the same question (or extremely close to it) four...

mw112009 (2/12/2016)

---

Lynn: Let me make this simple.

I don't have a need to understand how SQL SERVER works. That is not a part of my job. Something like this, Microsoft should...

Okay, since you insist on us taking a shot in the dark, here is mine:

'

-- Using your sample data posted above

declare @pointfrom int = 2,

...