select * from sys.messages will give you the error text as well as severity, etc.:

message_id

language_id

severity

is_event_logged

text

isn't this the problem?: @tradeid ahs a single quote, which would stop theprocess, and then all the other varables need doublesingle quotes, like @vcDeptName = ''IF-PM'',

exec sp_executesql N'sp_UpdateProcessedTrades',...

yeah i agree; it's just my knee jerk reaction was "but it's in a TRANSACTION", like that makes up for everything.

if you start a transaction, insert, and then rollback due to a business decision, your identity will increment, but no error is thrown. a missing identity value does not necessarily...

you can use the function USER_ID() and USER_NAME() inside your trigger, and there is a bunch of system functions like APP_NAME and others that might be helpful for auditing/logging. look...

show us the query you have done so far, so we can offer suggestions with your homework; you won't learn if someone just gives you the answer.

can you show us the sql you are currently using?

Update dbo.WipJobAllMat

Set dbo.WipJobAllMat.Bin = dbo.InvWarehouse.DefaultBin

FROM dbo.InvWarehouse

INNER JOIN dbo.WipMaster ON dbo.WipJobAllMat.Job = dbo.WipMaster.Job

Where dbo.InvWarehouse.StockCode = dbo.WipJobAllMat.StockCode

and dbo.WipJobAllMat.Job = dbo.WipMaster.Job

and dbo.WipMaster.Complete <> 'Y'

and dbo.WipMaster.JobClassification = '90'or dbo.WipMaster.JobClassification = '96'

i provided an example when using the convert function; take a look at books on line...

most people suggest using a datestamp like 200709261727 instead of the format you were suggesting;

for...

longtime known issue.

logins on a server are stored in the master database. access to the login is stored in the actual database (select permissions only, db_datareader for example) are inside...

if you don't explicitly say tablename.columnname, the engine does it's best to resolve the columns automatically, since there IS a state column in one of the two tables involved int...

watching this topic, to see if it's possible.

personally I always make CSV or HTML files and change their extension to .XLS, so I never automate Excel, and I've always just...

ok think the business rule thru completely;

if a technician does his three tests in one day, he's qualified for a 10% raise(note you said raise and not a bonus, which...

yeah hire me too and i'll be a testing maniac! getting my pay to go up 10% per day of testing would be awesome.

zim (9/25/2007)

Posted - 09/25/2007 : 04:13:20 Show Profile Email Poster Edit Topic Reply with Quote

i want to write a database trigger to increment the salary...