It's not the data in the column, it's the validation of the input when it's entered. If you use a proc, and a call to SQL Server that explicitly lists...

Is the user named guest? Or are they in the context of guest in a user database, and perhaps have lost permissions?

That's very interesting. It seems like a flaw in the security model, but that does make sense insofar as what was happening.

I wonder if there is some hack/attach that someone...

Thanks for the update.

Is there any way you can open a case with Quest and post back the results here? Might help some other people.

Jeff Moden (12/7/2011)

---

Revenant (12/6/2011)

---

Jeff Moden (12/6/2011)

---

To be honest, I didn't enter... didn't even try to answer a single question. They wanted a "tweet" from outer space and I refuse...

Koen Verbeeck (12/7/2011)

---

Dev (12/7/2011)

---

The only valid countries are USA (except a few states), Canada (except Quebec), UK (except North Ireland) and Australia. (maybe one or two others too)...

Tony Palmeri (12/6/2011)

---

I dispute the notion that *all* laws (and all decisions) are arbitrary. Many perfectly good and just laws are made objectively by reference to a moral principle,...

We have debated about allowing submissions for items, but never implemented it. There is some worry that we would end up with many suggestions, many of which would not be...

Tony Palmeri (12/6/2011)

---

sqlnyc (12/6/2011)

---

Everyone has a right to complain, whenever and about whatever they want - that's the very essence of free speech. Your opinion is welcomed here, as are...

I, too, wonder why TCP/IP doesn't work. There are lots of companies that use this setup, running Express, connecting with TCP/IP and syncing at the office.

You ought to be able...

Are you sure the outgoing port is correct and your credentials are right? The various mail hosting companies can be strict about sending mail.

If you have experience with SQL Server, I think it makes sense. If not, I'd spend a year or so working with the product, gaining experience, and then using the...

Each candidate could submit a video, and they have a tweet and a short excerpt of why you should vote for them at the dbainspace.com site. You can click and...

Create your separate accounts in AD, then choose them in the setup screen. You need to create the accounts ahead of time.

If you need nulls or 0s in there, then you would add that logic, and replace the values in the SELECT with a NULL based on conditions.

You haven't spelled out...