- keep in mind you should refresh your object browser frequently (afaik it doens't auto refresh)

- after start of sqlserver each db is being recovered.

So sqlserver opens the db...

very good one too .... even rocks the foundations of any RDBMS :w00t:

always nice to share a laugh:-)

1) keep your copy of the original files on a safe zone (if you haven't, start with a full backup of your current database )

2) you managed to actually attach...

The goal was to figure out if a login is member of n-windows groups.

e.g. this will show all auth paths for the given windows login (not a group)

-- how does...

Keep in mind that if a use belongs to multiple groups, the default database setting cannot be used !

Check the access paths and memberships:

Use yourdb

go

-- how does this login get...

Nice and fast solutions.

Here's a similar thread ....

http://www.sqlservercentral.com/Forums/Topic699260-1291-1.aspx

My guess is K Cline is spot on.

Run your original select query and see if it produces result rows.

If not, find out why. K Cline explained what to do.

just my 2ct

In case of splitting the columns of one table to n tables with a (unique) subset of the columns of the original table:

- keep in mind to split...

you declared SLsubDept with the column

[groupId] [int] NOT NULL

This means you must provide a value for this column when inserting new rows.

Nice rework Gail.

Thanks again for sharing.

Best is to post your question in a new thread.

Check the default schema for this user in the restored database.

the connection pool is client side.

afaik by default the connection pool size is 100 connections.

You can monitor it using windows perfmon.

At sqlserver level you can get an overview of pooled...

Paul White (3/17/2010)

But then the constraint will be marked as untrusted, and will not be considered by...

You could just generate a script to do it for you !

I would advise to incorporate a transaction scope per FK-constraint so you can drop it and add the new...