UPDATE [pitable].[dbo].[allpi]

SET val32= isnull(

(SELECT     *

FROM         OPENQUERY(pcnh, 'SELECT value as vh3   FROM picomp  WHERE time = date(''*'') AND tag = ''HQ0MP001MX''

')),0)

Indeed, it is like a fence. It prevents most from coming in, but soner or later, someone will jump over it.

Keep your DRP in mind when you choose a datasecurity...

in addition to the other replies.

You can also try to disencourage native db-access by using your own naming-conventions.

I have one db that has tables named A0001,.. with columns C0001,...

muts be a udf someone instaled for you.

I cannot find it on our (dev) sqlservers.

good hunting

welcome to the forum.

Maybe this can get you on track ...

http://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp

just my 2 ct.

I guess your LAST_PAY_DATE column is defined smalldatetime.

You want to fill it with '5005-01-01' . that is not alowed.

BOL says :

smalldatetime

A trigger is an in-transaction-procedure. (has to be performed in the same transaction as the object-action it is fired from)

This means that when your trigger fails, your whole transaction has...

That's what I like about this site and the QOD's.

Sometimes things are kept in mind because of an "Aha-Erlebnis"

Because your column is defined datetime ( Correct datatyping ! &nbsp it is best to order on the...

maybe this helps :  ( and the comments ! )

http://www.sqlservercentral.com/columnists/awarren/worstpracticesobjectsnotownedbydbo.asp

http://www.sqlservercentral.com/columnists/chedgate/worstpracticenotqualifyingobjectswiththeowner.asp

http://www.sqlservercentral.com/columnists/sjones/istheschemastillneeded.asp

IMO it is more important that we can see who or what disabled it. and that it is meanth to stay disabled.

I don't know if this is what you want.

Keep in mind this is using xp_cmdshell !! (you don't want to open it for...

I've just replied to your http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=152411 

Welcome to SQLServer's community.

If you have saved the DTS-package, then you can rightclick on it and there is an option "schedule job".

Just verify...

If you use the propre sp, things whill work fine.

This is because these procs also tell the running sqlagent to refresh its job-data.

I use it all the time when e.g....