Gary Varga (5/13/2016)

---

ZZartin (5/13/2016)

---

Gary Varga (5/13/2016)

---

Whenever dealing with permissions on a database or domain basis then it has always been easiest when using roles/groups. People move jobs but should not...

Gary Varga (5/13/2016)

---

Whenever dealing with permissions on a database or domain basis then it has always been easiest when using roles/groups. People move jobs but should not retain permissions from...

If you query the view directly on the oracle server does it return any rows?

Is your trigger that works running on the same server and same instance of SQL server?

Tava (5/11/2016)

---

Yeap, that's part of the process that should...

It's possible the vb script is throwing an error for whatever reason and hanging indefinitely, you can try changing the execute command to 'cscript \\SERVER\Folder\script.vbs ' and adding a +...

If you want to learn both find a small company that needs you to do both 😀

Keep in mind at the entry level there's a lot of over lap in...

Double

Well one option is to just store the values directly on your contact table instead of trying to normalize them.

Another would be to just return the values on the contact...

Chips

There's nothing inherently wrong with shrinking the database, it's not that it's unsafe and it has a very specific purpose that it achieves. The problem is when people don't...

Easy to confuse

SELECT REPLICATE( 0x65, 4);

with

SELECT REPLICATE( CHAR(65), 4);

At first glance 😀

One possibility would be to add a new int field to the table with a default value of 1. After adding that populate it with a ROW_NUMBER() over the...

Vegas

Plunder