Thanks, I am going to see what I can find.

Yes, this is in all of them.

I would be interested in changing the data type.

We have a code we use to tell if it is a PDF or Excel. but after looking we have no excel files only pdf's.

It is sql server 2008 r2

I'll see if I can explain this better. The field in the table is an Image data type. The path of the pdf or excel is stored in this field....

I am modifying a job someone else created.

I changed the following lines.

WHEN CH.CoID IN (SELECT KeyValue FROM dbo.fnValuesText(@InCo)) THEN 1

WHEN CH.CoID IN (SELECT KeyValue FROM dbo.fnValuesText(@OutCo)) THEN 0

to

WHEN CH.CoID IN...

That works perfectly. I don't know why I didn't think of that.

Thanks!!

I got it. I meant to come back on here sooner and post my solution. It was so simple it makes me feel dumb. All I had to do was...

I think it is OK the way I set it up. It looks like they can do more than what they can. I have them setup as db_owner in the...

I'll try that. Thanks!

I guess I need to do some more research on this.

I created a login in the instance with the public role (I think that role is my problem) then...

I have them in the role right now as db_owner. But they have access to the security in that database and also in the Master, Tempdb, and distribution database. I...

I'll check that out. Thanks.

I'm not sure I can do that. If I understand this correctly if I turn it on it is for all databases. We have multiple databases and I don't need...