lacwill25 (12/1/2011)

---

Not able to connect to the Adventure Works database. Currently trying to connect to the appropriate AdventureWorks database via object explorer within Management Studio but haven't had much...

Evil Kraig F (12/1/2011)

---

p-nut (12/1/2011)

---

I'm not sure what you are doing, your pseudocode is not making sense to me except number 1. Please include DDL of both tables, sample...

I'm not sure what you are doing, your pseudocode is not making sense to me except number 1. Please include DDL of both tables, sample data, and actual...

oliver.morris (12/1/2011)

---

Thanks for the help, I can't help but think there must be a smart way to do this. I fear thatnif I go down the cursor route it is...

Sapen (12/1/2011)

---

I don't think you should have to restart the service after that. I still think there is a permissions issue. Something in your domain is not interpreting the user...

4x4krzy (12/1/2011)

---

Jared,

I have tried to run that fix in the dB, but it didn't work.

I also ran this

SELECT a.name AS 'Server Name'

, a.sid AS 'Server ID'

, b.name AS 'Database Name'

,...

I don't think you should have to restart the service after that. I still think there is a permissions issue. Something in your domain is not interpreting the...

I can't think of any other way than a loop or a cursor to search for the existence of each product id and then writing what it finds. So...

Have you tried simply right clicking on the user on that database and deleting them?

Jared

oliver.morris (12/1/2011)

---

It would be good to have:

note id product code

1 ...

4x4krzy (12/1/2011)

---

The dB in question.

If I run this in the dB in question the user shows up. I get the 3 result sets.

SELECT * FROM sys.sysusers;

EXEC sp_helpuser;

If I run...

You ran this on the database in question or on Master?

Jared

Are you saying you want a table with only 1 row per product code with 2 columns: productcode and list of noteids?

Jared

4x4krzy (12/1/2011)

---

Well I am trying to get the 1 user that has a domain account to show up so I can change the permissions on it. Yes we are using...

isuckatsql (12/1/2011)

---

I assume the goal is to keep each table as small as possible?

Based on the above assumption, i have some fields in a candidate profile table, job title(dates...