Make sure also that non of the users have been set up as super users (sysadmin, sysoperators) and role that would genericly be able to perform creating DTS packages. Also...

Again it was fun, I enjoy trying to find out exactly what SQL Server does.

Don't roll your eyes at me. I will tape them in place.

What happens if you run the query against the table itself outside of the trigger.

Doing instead from the table.

Also don't think they are but for the chance it might...

Thanks it was enjoyable to go to the level I did.

Change = "4629" to = '4629'

I believe the quotes may be causing an error.

If there is a main field you would want to know this on the something like this

SELECT fldIwannaC

FROM myTbl

GROUP BY fldIwannaC

HAVING COUNT(fldIwannaC) > 1

If you want to...

Haven't had a chance to test, but are you getting an error message? Could be something we've seen before. If not then MS is your best bet.

I agree with Steve, I have a site another developer did that would query the list of the current months birthdays eveytime some came to the page and I really...

Ok, first off this is an NT/2000 box I assume. So first try what Steve suggested and login as Agent on the box to see what happens. My other thought...

Actually don't delete it, just disable it so it will not run, that way if someone does complain it is no trouble to recover.

Basic and simple, waiting for a bit more meat. Ready for pt2.

Yes, that would be one way.

SELECT DATEADD(d,-DATEPART(dw,DATEADD(wk,20,'1/1/' + CAST(YEAR(GETDATE()) AS CHAR(4)))) + 1,DATEADD(wk,20,'1/1/' + CAST(YEAR(GETDATE()) AS CHAR(4))))

However 20 gives you week 21 not 20. Whatever number you enter is week # (your number + 1)

...

Before anyone says otherwise I have always found OPENQUERY against an Oracle server is more stable acting that the whole LSNAME.DBNAME.DBOWNER.TABLENAME method.

This should work for the update but test.

UPDATE

prod_master

SET

product_weights =...

BASIC UNDERSTANDING OF THE PROBLEM:

OK here is what I discovered, in SQL 7 when a column is deleted the syscolumns table keeps the original ordinal position listed instead of adjusting...