A few questions.

The table in question in all these databases, is it the EXACT SAME schema? If not, you're going to have issues regardless.

Next, can you connect to a...

Well, either you're...

RETURN (

SELECT CASE

WHEN @optional_letter = ' ' AND EXISTS(SELECT 1 FROM dbo.Test WHERE letter = @letter AND...

@Brandie: The Business Case for this (and others like it) are BOM lists to make sure you don't 'double tap' an item in the hierarchy. Doing it at...

You do that by putting said database on a different server with different security.

SA can change anything, including their own security rights. You can explicitly deny, then can revoke...

ZZartin (12/5/2014)

---

The way he presented that website is that users see a field that says enter anything you feel is relevant to us, and now he's getting information that isn't...

ZZartin (12/5/2014)

---

Alexander Suprun (12/5/2014)

---

Eric M Russell (12/5/2014)

---

Jeff Moden (12/5/2014)

---

Ed Wagner (12/5/2014)

---

Eric M Russell (12/5/2014)

---

The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users...

Sounds like either users, or trolls, are trying to avoid a third party service that connects them.

You don't do this at the SQL level. The Regex is too weak...

Definately. It's called Production Failures. 😉

If one of those flat files fouls up, you don't have...

Under most circumstances User Initiated Job events or SSIS package firings are bad ideas. The reasoning behind this is that it has very little collision detection. It's quite...

I know it's not the direct answer to your question, but there's an implication here that concerns me.

You want people able to create tables (DDL_Admin), modify tables, etc... but not...

Thanks Happycat. I'll take a look.

GilaMonster (12/4/2014)

---

Nothing to do with the ORDER. Derived tables always need an alias.

Edit,...

No, you can order subqueries as long as you're looking for a TOP statement. My apologies, I read that as TOP 100%. My bad.

That's more likely an issue with the data than with the code.

Shouldn't be getting an error from SSC for posting code, I do it constantly.