A nice utility which would be even nicer if it could filter on object type/object name prefix or suffix. This would make it easier to handle databases with a large...

I'm using it to get a trace functionality similar to that of ASP.NET, but it uses OutputDebugString via an extended stored procedure to output information about the execution of nested...

The statement is as follows:

sp_helprotect 'udfUSR_PermissionListByEmployeeID'

The current permissions for this objects is one role having SELECT permission.

I did a workaround by directly querying the syspermissions table...

Yes, there must be some kind of SELECT against the sysobjects table which could take some time if there are many objects, but I guess it is pretty much used...

Hi!

What is the reason for choosing a UDF instead of SP to incapsulate the INSERT? I would go for a second SP which does the INSERT and possibly some other...

Some more investigations has revealed that the time for a group membership change to appear when using this function is between a couple of minutes up to almost ten minutes.

/Jonas

Sorry, I should have stated in my original question that I'm using a single account to access the SQL Server from a COM+ application, so the users I want to...

Hi!

Unfortunately IS_MEMBER does not work for me as I have to be able to specify a username different from current user and check membership for it.

Thanks anyway

Jonas

Ian's answer led my to check the data type, and I had it declared as a char(30). Obviously (!) it makes the LIKE compare to a 30 character length string,...

Great idea! That way I don't have to deal with the individual tables because db_denydatareader/writer takes care of that.

Thanks

Jonas

I want to restrict the access to all tables (and the rest of the objects possibly) in the database, leaving only a layer of stored procedures that can be executed....

Yes, I guess I can use sp_MSforeachtable for the user tables and then hardcoded statements for the system tables.

Thanks for your answer

Jonas

Hi and thanks for your answer.

How would I get a new transaction from within a stored procedure that won't get rolled back together with the original transaction?

I guess my...

So the recommendation is to leave the master database set to simple recovery model and only doing full backups on this? But for msdb, also set to simple, would it...