Seems like a bad code from a developer or a bad state on the server.

Do you have any other info?

DBCC CLEANTABLE is your friend. Run it first then Apply your script.

Although the article shows a simple technique there are many things that were omitted.

This is NOT a way to handle such things if there are strict requirements from security standpoint.

1....

Right, a missing "catch" in an assembly is a...

Although SQLCLR has great power I think it is very important to tell the reader that it also brings MANY undesirable things in.

- Bad Exception handling is just one of...

I would try with normal temporary tables first instead of table variables.

Edward Boyle (2/4/2009)

---

I have a somewhat different business application summarized below.

A table with columns Interval and Value. These represent an activity that occurs at each minute of a 24...

If you are a

Then you

kind of turn the server on.

kind of make sure the light stays on.

kind of shout if the light goes off.

...

NotManyPoints (2/4/2009)

---

Ok right, so we are staying here then.

So I'm interested, for the first 6 years (can you give a rough time frame) so we can put that into context...

Really ?

Keep all those buffers...

Jeff Moden (2/3/2009)

---

charlesz (2/2/2009)

---

Second, NVarchar(MAX) and Varchar(MAX) can only hold up to 65535 bytes ( The number posted by Gail Shaw was wrong).

Our product DB-WAN Accel communicates with SQL Server...

riga1966 (2/3/2009)

---

Figured out myself.

It should be:

SELECT

IG_SRC_SYS_KEY = CASE

WHEN LEFT(ci.IG_CD,1) = 'D' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID = 'DDA')

WHEN LEFT(ci.IG_CD,1) = 'G' THEN (SELECT SRC_SYS_KEY FROM SOURCE_SYSTEM_REF WHERE SRC_SYS_ID...

By the way, Are you a dba?

Oh And I have seen *MANY* people using simply db_datareader and db_datawriter.

You could take those permissions away and then the "entire" DB is inaccessible 🙁

Tom.Thomson (2/3/2009)

---

noeld (2/3/2009)

---

Actually I have had the need for this feature for a long time.

Suppose you need to prevent changes on ONE table while you are doing some maintenance...