Hi,

I can assure you that the script wouldn't make any changes.

Can you post the latest script you have, so that I can take a look at whats going...

Hi Matt.

I glad that the script was useful. And Thanks for the suggestions.

The changes you suggested are published.

I am not sure if I understand the question entirely, but if you are trying to verify if the mentioned statements worked or not, try this:

Go to "cs_DotNetNuke\Security\Roles\Database Roles\db_dataeader",...

Very Nice!! it works on 2008 as well. Good to know.

Thanks for the info.

Try this query...

SELECT

t.[name] AS objectName,

mid.equality_columns,

mid.inequality_columns,

mid.included_columns

FROM

sys.dm_db_missing_index_details mid...

If your situation allows dirty reads, then use table hints. With the (nolock) table hint, no shared locks are issued and exclusive locks are ignored.

Also, you would want to see...

I am just glad that it is useful 🙂

I want to be able to run a script that I can trust to give me a comprehensive statement of the access that any user has to any database...

Can you post the script that you've got after removing the 2000 part out? I tried doing the same and it worked with out any problem.

try doing it like...

Thanks!! I guess I have to do that.

Once after the service restart, it took less than 1 second to respond to the query, which is what it should be.

SQL server could be out of memory when...

Cathy, thanks for working on it.

here is the updated script:

/**

Script: list all Usernames, Roles for all the databases.

Author: Shiva Challa (http://challa.info)

and the database Roles that the user belongs to...

ahaa!!

Dont know why I didnt think...

Here is the most updated script, With added code to use SysObjects in 2000 instead of sys.objects

/**

Script: list all Usernames, Roles for all the databases.

Author: Shiva Challa (http://challa.info)

and the database...

This is happening because there is no sys.objects...