Try setting up the receiver to RETAIN the messages so that you can see for sure if they are actually getting that far. If they do not show up...

Here'e another way to do this: here[/url]

Heh. Me too, I was going to ask for your secret. 🙁

herladygeekedness (5/25/2012)

---

oh good, it's not just me! I was unaware that industries would have templates for their DWs and would be surprised if they were shared as I know...

As okbangas said, SSIS is definitely one way to go, as is Service Broker + SQLCLR. If you find SQLCLR unreasonably constricting (I do) for this kind of task,...

Heh, glad I could help. That Binary/Hex string thing has been a bugaboo in SQL Server for a long time ...

Jeff Moden (5/24/2012)

---

michael vessey (5/24/2012)

---

be carefull - most...

dan-572483 (5/23/2012)

---

Have you tried the Visio Database Reverse Engineer feature? It creates a diagram and tries to show relationships- probably not all correct in your case, but it's a...

Is it my imagination or is Paul getting younger?

😀

GilaMonster (5/23/2012)

---

dwain.c (5/22/2012)

---

Stefan Krzywicki (5/22/2012)

---

Many should format it all at once,...

michael vessey (5/24/2012)

---

be carefull - most employment contracts...

Open the files up and take a look at them. Or post them here as attachments and we'll look at them. (smaller ones than this though)

jdillon 62969 (5/23/2012)

---

...

Logins for all instances are always groups, example adventureworks_dbo (has dbo permissions), adventureworks_readonly, etc, etc

I keep running into the issue of users getting permissions they shouldn't...

By "PDW" can we assume that you mean the Parallel Data Warehouse?

Try running the following commands:

winmgmt /clearadap

winmgmt /resyncperf

Then reboot and see if the problem goes away.