Duh!!!!

I guess having a good, nutricious lunch makes a difference. Thanks for pointing out the obvious.

-rp

Hello Shawn,

I guess someone else posted a similar query here a while back. User vidhya sagar provided a script to that essentially fetches all the user databases and sets them...

Hello Shawn,

Thank you for the reply. Your recommended approach is for moving them 1 at a time. I'm looking for a way to either read from a file or a...

Thanks again guys and Derrick. I'll pitch this report to the user and see how they like it.

-rp

Derrick,

The query worked exactly as you predicted. Thanks a whole lot!!

The only thing I need to workout now is the sorting for the columns. If I wanted the username, name...

Derrick,

Attached is a doc illustrating all the tables and columns.

Thanks for all the help!

Hello Craig,

I don't think so. I tried using uppercase and still got the same error.

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "aspnet_Users1.ApplicationId" could not be bound.

Thanks for replies Mike and Derrick.

Derrick, when I execute the new query, I'm getting the following error:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "aspnet_users1.ApplicationId" could not be...