Thursday, January 31, 2008

List of SQL Server database users and permissions

Today I was doing some research as to how to list the database users and the permissions they have and came across this article which is very useful.

http://www.mssqltips.com/tip.asp?tip=1071

1 comment:

Martin English said...

Just what I was looking for ...

thanks, Priya

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...