the Troglodytic, procedural solution:

IF EXISTS (select workstation, date_entered from inventory

where part_number='ABC' and workstation >= 5)

...

By "for each user" I meant: stick this in a single batch file, with a call for each user.

This would simplify the permission issues Steve pointed out.

SQLCMD -S[server name] -E...

This works for me (albeit in SQL2005):

SQLCMD -S[server name] -E -r1 -d[db name] -i" \\[machine]\[drivespec]$\foldername\filename.sql"

Quick and dirty would be to do this for each user.

Are there any triggers on that table?

View Menu - Summary

or toggle on by F7

Read this:

http://www.sqlservercentral.com/articles/Books+Online/67607/

or: search this site for 'BNF'

or: Google 'BNF' or 'Backus Naur Form'

Understanding BNF is essential for good info from BOL

Try this:

--============================================================================

-- For multiple ops in a script, keep a running count of errors.

-- For any error count over 0, rollback all ops

BEGIN TRANSACTION T1

Declare @ErrorCountInt

SET @ErrorCount = 0

--

--OP#1 code...

Perhaps the client is a Professor?

select top 1 @i =

Convert(int,Replace([ref des],'Vnone',''))+1 AS VSC

FROM BOMOut_FPM_Fix1

WHERE BOMOut_FPM_Fix1.[ref des] Like 'vnone%'

And IsNumeric(Replace([ref des], 'Vnone', '')) = 1

ORDER BY convert(int,Replace([ref des],'Vnone','')) DESC

SSMS

-Object Explorer

--SQL Server Agent

---Jobs

---RightClik the Job

-----View History for the Logs

-----Properties to see/edit the Steps

hmmm...

:blink:

Try your local community colleges for cheap classes in:

- MS Access to see if you can think like a DBA or DB developer

- Intro to programming (VB, Java)...

I think Barry lays out most of what you need:

Structure: Develop a clear,concise, well planned naming convention for your sprocs

Discipline: Stick to it

SSMS-Management-Activity Monitor will dynamically show all processes with blocked/blocking status.

Delete/disable/munge it...see who hollers