ALZDBA,

That's one heck of a script. Can you give me an idea of what it is doing? When I run it from Query Editor it shows the sql startup parameters...

>> Can you ask the users what exactly they mean by 'locking'?

From the user's perspective their application appears to stop functioning until we use sp_who2 to find the user...

My installation tab does not have a "client installs" option. The closest I find is "New SQl Server stand-alone installation or add features to an existing installation".

I think it wants...

I found the sql_tools.msi under \x86\Setup. When I tried to install it I got the error:

0:Watson 1:1807 2:StreamSupportFiles

3.getBootStrapDirectory 4:3

5 e:\sql10_main\t_sql\setup\darwin\sqlcastub\catarget.cpp

6:100 7: sqlcastub.dll 8: sqlrun.msi

and utlimately this message appeared:

"A valid...

>>>

What I really want is an "Almost Commodity SW Specialty Tool" which would put it in the $200-$400 range.

>>>

Agreed.

Barkingdog.

By

>>>>

But we've been doing our physical design work more and more without the ER tool and simply plugging it right into code from day one

>>>>

do you mean you are...

>>> why can't you just script the database .....

I'm not sure how to do this. We are creating all the tables in VISIO (VEA) but find that its "forward engineering"...

Grant,

You wrote

>>>

..we are relying on tools like Visual Studio Team System Database Edition.

>>>

I didn't think that VSTS, yet, offered any database design tools at all. (Am I wrong?)

Barkingdog

The JOIN solution is also good. Thanks.

Inetresting soluton. I am familiar with the SELECT..EXCEPT SELECT .. approach but I didnt't realize it could be used for more than a single column at a...

Good answer.

Thanks,

Bilkingdog

Good URL. I will recast my original "question" using some of the ideas in your article.

Barkingdog

The first column, not shown, could well be an identity column. So the first row could have ID = 1, the next row 2, etc....

Bill

Thanks for the good answer.

Of course if a new stored proc is added to a database (I'm not the only DBA type around) then users in the existing role won't...

Thanks for the interesting responses.

Also, I don't think the "Enable the Lock Pages in Memory Option" is relevant to my situation. From

http://technet.microsoft.com/en-us/library/ms190730.aspx

I found this quote:

"Locking pages in memory is...