Just so you know, this thread is more the 'watercooler' at this point instead of being an actual whine and moan thread of record length.

No, there aren't stupid questions....

What is the purpose of doing this?

I figured I would throw my 2 bit sense in here too. I do not think that the post are getting worst. What you have to remember is that, you...

This should do what your looking for:

declare @cnt int

SELECT @cnt = COUNT(*) FROM SDW.PHARMADM.PHARM_HRXS where POSTED > to_date('07/11/2011' ,'mm/dd/yyyy'))

select @cnt

A good place for you to start is finding what your rights are. Your problem lies in user schema sepration here is an article on it:

http://msdn.microsoft.com/en-us/library/ms190387.aspx

Write a stored procedure and make them call that rather than running ad-hoc queries.

--------------------------------------------------------------------------------

Gail Shaw

SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in...

No I actually want to capture it and alter then return the results before returning values!

Gail

I take it that would not allow me to do anything before it has taken place tho?

Dear All,

Iam facing the below login failed errors.

SQLServer 2008 - RTM - Enterprise Edition

Windows Server 2008 - 64 bit O/s

Message

Login failed for user 'sa'. Reason: Failed to open the explicitly...

amy,

Not sure about what your really asking, but if your just wanting to print the errors use print instead of select.

Sean

Sounds good but ths sounds as if it would effect the applcation? Maybe it example mght help.

So then not sure how you suggest this might work, maybe you could give a little more detail as to how this could work.

So even a view with instead of triggers won't work in this case to completely replace the original table in the eyes of the app? (I'm aware you probably can't...

If there are any other ideas fell free to reply. I have alreay done as Sean spoke about as far as where I stand with this type of situation with...

Sounds to me like management has mandated that you provide visibility to sensitive information that at the very least in incredibly unethical (which obviously you realize since you are trying...