Do you have access to the struct definition itself? If so, this can probably be scripted out.

aureolin (11/16/2007)

---

Y'all are certainly welcome to. And, as long as you're working in a nice, sterile environment, you'll have a lot of success. But, let's take...

You might private mail Jeremy. He has the charts and performance stats to back up what he is saying.

I respectfully disagree. Properly designed, constraints do not impact usability. In the case of dirty data, if the data is ambiguous, how do you establish relationships based on it? The...

A friend of mine, Jeremy Brown on here, ran into this in production a few months back. Here's what they did to fix the issue:

- Configure the SQL Server service...

A trigger fires on a SQL operation. Therefore, a trigger could be handling multiple rows, not just one. So you must take that into account.

When a trigger fires, two special...

The DMV sys.server_principals contains basic information on all logins. That should give you the information you need from a SQL Server perspective with respect to domain accounts. If you need...

And most financial...

Use a proxy account with only the rights necessary to complete the job. The schema doesn't really help you in this context.

Peter Schott (11/16/2007)

---

Steve Jones - Editor (11/16/2007) People don't respect security when it's a pain and it gets in their way. They don't see the risk of something happening as...

Can you say privilege escalation attack? And once I escalate to admin,...

Stephanie J Brown (11/16/2007)

---

As a for instance, the military bans camera phones on base, but at my company there is not a real need to do so (note, someone could...

Sir Slicendice (11/16/2007)

---

I'm sure that if worked at it I could have built a small bit of code to generate a gif with a set of high-density bar codes, which...

The database master key and all certificates, symmetric, and asymmetric keys do travel with the backup. However, usually you have to know the password to decrypt the database master key....

No, they keep out the curious and in the case of an attacker who is looking for easy prey, they keep those guys...