Encryption is the only safe way to do this. Anyone who tells you otherwise is just trying to sneak past you, or doesn't know what they're talking about.

Even if...

Deny them the rights to create objects in master. That's simple enough, unless they've got sa rights (which they shouldn't).

scole-1025617 (11/13/2009)

---

acarlson-861483 (11/13/2009)

GOOD FOR YOU! I sincerely expect that your work SHOULD have improved over 5 years. As you develop in C# you will continue to improve with that...

Steve Jones - Editor (11/13/2009)

---

An interesting debate. From the overall tone, I think that lots of people use C# for personal reasons, or because they find work with it, not...

Florian Reischl (11/13/2009)

---

GSquared (11/13/2009)

---

void ValidateColumn(object sender, DataColumnChangeEventArgs e)

{if(e.Column.Equals(this.UnitPriceColumn))

{if(!Convert.IsDBNull(e.ProposedValue) &&

(decimal)e.ProposedValue < 0)

{throw new ArgumentException(

"UnitPrice cannot be less than zero", "UnitPrice");}}

else if (e.Column.Equals(this.UnitsInStockColumn) ||

e.Column.Equals(this.UnitsOnOrderColumn) ||

e.Column.Equals(this.ReorderLevelColumn))

{if (!Convert.IsDBNull(e.ProposedValue) &&

(short)e.ProposedValue < 0)

{throw new ArgumentException(string.Format(

"{0} cannot...

Dean:

Yes, the VB.NET you posted is harder to read. It also deliberately avoids general readability standards. Try this:

VB.NET:

Sub ValidateColumn(sender As Object, e As DataColumnChangeEventArgs)

If e.Column.Equals(Me.UnitPriceColumn) Then

If Not Convert.IsDBNull(e.ProposedValue)...

Have you tried querying sys.database_role_members?

The only way to eliminate a bookmark lookup without having the requested columns in an index, would be to force the query to use the clustered index instead of a...

The database is corrupted is what all that translates to in simpler terms.

You'll need to get a backup that wasn't created over I/O errors is most likely the best solution.

I've actually seen people advance the argument that VB is worse than C# because, "Look at all the bad code that's been written in VB!"

I've seen the argument that C#...

Virtualization can save money on an ongoing basis. As already mentioned, less maintenance and upgrade cost because of less hardware. Even more so, when done correctly, it can...

Well, somewhere there's code that's issuing the update command. Whether that's in a proc or in the front end, or the data access layer, or somewhere else, it has...

My prefered practice is to name parameters with their direction. @Date_in, or @Account_out, that kind of thing. Local variables don't get a suffix. Makes it really easy...

If it comes down to it, get a copy of Dev Edition for yourself. It's only about $50, and it's worth it to have.

In re-reading your post, I realized you're planning on an update instead of a deletion, so change that part of what I wrote.

The "repeat till @@rowcount=0" is because you could,...