Up

Book

I did not mean DENY everyone just the logins (or group) you wish.

Have you tried deny of alter on database?

Old

Thanks again. I gave it a try and it worked well. Once I deciphered what MS was saying about it in the KB article.

Thank you! I had wondered if that was possible, but since the log shipping was not directly related to the backup, I did not know if that would work.

How do you get from your data to your result? I see things not reported but why?

One way would be to convert your data to a table and use that as your criteria. As you found out, you cannot use a variable as the IN.

Another...

Potato

Wish I could remember what last year was like, I remember some nice days for '77 as I have a picture of me from a company picnic....

Here is code I use. It may not be pretty, but it does what I want by building output of code to run.

with cte as (

select Object_name(object_id) AS TableName

...

So what does the data look like (not just the schema) in tables ST and SC?

Sample table data would be of help

carlos cachulo-318532 (8/13/2014)

I have this tables SC and ST

ST has this fields

ref,design,stock

SC has this fields

ref,refb,design

i can join this tables with st.ref=sc.refb

I´ve came with this query

select sc.ref,sc.design,st.stock from st inner...