You might check out what permissions have been given to the 'public' user group.  I've seen databases where public was given everything (usually test/development databases) and it was very difficult...

I'd give you the opposite advice.  Do everything you can with stored procs.

Performance is usually better

It keeps the data management in the database where, in my opinion, it belongs

Impact analysis...

This looks a little strange:

AND     JBS_BEFORE_QUANTITY > 0

AND     JBS_BEFORE_QUANTITY < 1

What's the data type for this column?  If it's integer, that might explain the 'no rows returned' problem.

Just to be a little contrarian...

Text and image data types can be performance concerns and you need to make sure your hardware is up to the task and your physical...

It will release the lock when the transaction is committed.  If you have an update that spans a large number of rows, the server maintains the locks on all of...

Just off the top of my head:

Make sure the server is set to accept the type of login you're using (SQL Server, Windows authentication, or mixed mode)

Make sure the user...

I'm guessing that @to is defined as char(xx), so it will always be xx long.  Define it as varchar(xx) and the variable will hold only what you stuff in.

It doesn't appear that the cursor ever stops, so you're running off the end of the result set.

Try

WHILE @@FETCH_STATUS = 0

instead of the 0=0 condition.

0 indicates a successful fetch,...

Absolutely spot on.  Though I do thnk Peter Davison desrves honorable mention for Doctor Who.

I might add:

Whatever new management paradigm is proposed by the latest business guru will have worked...

How about ...

declare @y int

set @y = 3

select substring(convert(varchar(3), @y + 100),2,2)

It's not a builtin, but it doesn't look too painful.

No.  Why would that need to be the case?  I'm working with a vendor who is service-enabling our banking transaction system.  We haven't decided on the service granularity yet, but...

I don't have any good news, I'm afraid, but you might want to check

http://support.microsoft.com/default.aspx?scid=kb;en-us;828337

to see if this looks like your problem.

Give this a try:

http://msdn.microsoft.com/data/mdac/default.aspx

It should let you download the latest data access components.  If you need the database tools, you might try downloading the trial version of SQL Server...

If the log is set to auto-grow, the percentage will drop at the point where the log expansion has occurred.  That's a guess, not a certainty, since I'm not on...