hunchback (2/20/2014)

---

To add to Sean's response, see if you can get a system views map for whatever version you are using. There is a lot you can learn from there...

hunchback (2/20/2014)

---

Have you checked the catalog views sys.tables and sys.columns?

Here is an example without taking into consideration user types.

SELECT

t.name AS tn,

sc.*

FROM

sys.tables AS t

INNER JOIN

sys.columns AS sc

ON sc.object_id = t.object_id

INNER JOIN

sys.types...

hunchback (2/20/2014)

---

Have you checked the catalog views sys.tables and sys.columns?

Here is an example without taking into consideration user types.

SELECT

t.name AS tn,

sc.*

FROM

sys.tables AS t

INNER JOIN

sys.columns AS sc

ON sc.object_id = t.object_id

INNER JOIN

sys.types...

Sean Lange (2/20/2014)

---

Can you provide some insight as to what you...

Thanks for everything guys I actually finally got the update query to work. Thanks for all you help, I do appreciate everything

I understand that but I don't want to write 743 individual query's. That's...

Sean Lange (2/7/2014)

---

You also some parenthesis in your where clause that are very likely incorrect.

See if this might be more of what you are looking for.

Select P.PartID, P.mansPart, P.Cost As...

Lowell (1/24/2014)

---

my example trigger, while untested, would not error out if an automated process inserted multiple tickets in a single operation; but it would create a single email that said...

Dieselbf2 (1/24/2014)

---

Lowell (1/24/2014)

---

well, now i see two things;

first is a critical permissions issue:

the end user who inserts into this table must ALSO be a user in the msdb database, and...

Lowell (1/24/2014)

---

well, now i see two things;

first is a critical permissions issue:

the end user who inserts into this table must ALSO be a user in the msdb database, and must...

What do you mean by:

if that doesn't clear it, i've had to bounce the sql instance itself to get things moving through the queue again:

Please explain

Lowell (1/24/2014)

---

well, what you are seeing in the log is normal, i believe. if the service broker gets an email, it starts the database mail executable,and it's default lifetime is...

Lowell (1/24/2014)

---

since dbmail is already set up adn running, it might be something related tot eh recipient or relaying;

if you run this query, is the specific email you sent...

Sean Lange (1/23/2014)

---

Your sample data won't load. The last row for logins is invalid, not a huge deal I just skipped it.

However, the rows for [ProposalProfitSplitWorksheet] all fail the...

Sean Lange (1/22/2014)

---

Dieselbf2 (1/22/2014)

---

So now we have the tables. We still need a few rows of sample to do much here. If I understand correctly you want to make sure...