Do you mean delete data from the column? You don't mean the end-users of the app have DDL privileges?

Assuming you want to protect the column... Only allow the users access...

Unfortunately, that can be a serious problem. I know we've passed up on bringing in consultants because their English was so bad that we couldn't understand them.

The key question would be, is he using slang or technical jargon? If he says that something is "cool" then he's using slang to imply that it's good or acceptable...

Writing twice is writing twice. I've found the OUTPUT clause to be a bit more flexible in some ways than a trigger and it has the added value of being...

Open the configuration manager. Click on "SQL Server 2005 Services" on the left side of the screen. You should see a list of services include "SQL Server" or "SQL Server...

Have you run Profiler to watch the code come across? You can at least see what procedure calls are being made with what parameters and then test those same calls...

Since 2008 hasn't been released yet, I wouldn't suggest making that migration now. But since it's supposed to be released in August (assuming they don't slip again), if you can...

It is possible for the RI checks to be performance hit, sure. But if you've set up your tables & indexes appropriately, they shouldn't be. Doing an RI read on...

It's my understanding that if you mark a database as read only, no locking occurs. So if you have a warehouse type of app where you won't be modifying the...

I'm not sure. I've never seen it go off without there being a collation value set either on the table or column or parameter. If you're getting collation errors on...

I'm not a hard-core programmer, so forgive me if I say something more stupid than I usually do...

You'll get the number of units that should be displayed and you'll get...

You can go into the Advanced Properties of a step and set up a number of retry attempts and a retry interval. That ought to do what you need.

Check the code to see if it added the COLLATE key word after the parameter definition. That would cause the problem.

fshguo (5/23/2008)

---

I have upated the statistics, rebuild the indexes and apply Option Maxdop based on the recommendations, it looks like the situation has no change.

After I compared the execute...

Before I try to solve that, you might want to rethink the approach. If you fill out the rows for the user, even though there's no data, you either go...