How about using the intersect operator ?

DECLARE @a int = 123,

@b-2 int = 123 ,

...

Lowell (8/12/2011)

---

Just in case you were still going to ignore the advice Grant gave you...listen to Grant.

One of the things I love about SQLServerCentral is that when you ask a...

Just replace the IN clause with NOT IN clause.

Check whether the TCP\IP protocol is enabled.

See whether this helps

http://support.microsoft.com/kb/975752/en-us?sd=rss&spid=13165

Cannot think of a scenario where Resource database gets corrupted except when you are installing a service pack which errors out and corrupts the database

The best thing you can do...

Thanks.

But I was thinking of a scenario where there are 10 users and all these 10 users have different set of permissions where in by no 2 users have the...

Grant Fritchey (8/4/2011)

---

No difference at all. You run a server side trace output to a file, then you open the output file using Profiler. That's it. You can then open...

Unfortunately none of the posts on ssc were helpful.

One that helped was this

http://blogs.ameriteach.com/chris-randall/2009/12/11/sql-server-2008-forgot-to-add-an-administrator-account.html

But somehow it works only...

GilaMonster (8/2/2011)

---

No. Please no. Worst thing possible.

Unless by some miraculous chance the database was cleanly shut it will not reattach. You should...

Try detaching and then attaching the database.

Try the steps posted here

http://www.sqlservice.se/allmant/dont-panic-the-log-for-database-name_here-is-not-available/

Note sure how exactly your table structure & sample data looks like.Based on your description I have guessed the structure and expected output.

Declare @t table(Activities varchar(10),Labor varchar(10),Fabrication varchar(10),Transport varchar(10),Distribution varchar(10))

insert...

Max memory settings controls only the max size of buffer pool(paged memory).

So in short the memory of 234752KB comes from 28 GB max setting.

What does this return ? It will tell you why the log file is not shrinking .

select log_reuse_wait_desc

from sys.databases

where database_id = db_id()

Read this :-

http://www.mssqlcity.com/Articles/Adm/manage_users_permissions.htm