There's only the one instance running.

SELECT * FROM MyTable with an isolation level of READ UNCOMMITTED showed that the insert had worked while the update was hanging. Taking the...

Thanks for the fast response.

The cause turned out to be a primary key violation on the table that wasn't populating. The insert was was using a SELECT statement that...

Wrong metric ! It matters not how long you work but how much you produce - and of what quality. Tired people make mistakes. Increase your costs...

Particularly in a waterfall methoodology, developer time is not that significant; the big chunks are the business and systems analysis, testing and configuration ... and, if you already have a...

You say that the amount is being updated which implies that it is being passed from the application. Can you confirm that it is this sored procedure that is...

Algol, Fortran, 8086 assembler !

Developers, DBAs, architects, to say nothing of systems analysts, business analysts, testers (even users !) : We're all a team and we all need to work together. Silo's are...

The only fundamental rule is to write robust, performant, maintainable systems. The OO paradigm is one means to this end - it...

CREATE PROCEDURE dbo.Do_Update @TableName VarChar(128),

@Action TinyInt,

@key VarChar(255),

@data VarChar(2056),

@Validator Integer,

@UpdatedBy nVarChar(128),

@Result VarChar(255) OUTPUT

AS

SET NOCOUNT ON

DECLARE...

For trivial inserts and deletes, there can be an argument for avoiding stored procedures but, for anything more complex, there are clear performance gains. The biggest bottleneck is likely...

In a previous career, I undertook a lot of market research in the paper industry. The advent of the electronic office was going to really hit the demand for paper....

For the OS SP, go to Windows Update. That should detect and supply anything missing.

Not sure whether this is relevant :

http://support.microsoft.com/kb/899191

Anything + Null = Null so I suggest that you tace all the @rtf + instances and find which one is null. Just hack the code to write each...

Thanks Jeff, it had scrolled off the side of my monitor!

High level tools (like the data adapter) are great for productivity but its easy to end up with hidden issues....