Monday, February 10, 2014

SQL Server : Create New Role for Execute Stored procedures Only





SQL Server : Create New Role for Execute Stored procedures Only
------------
/* Create a new role for executing stored
   procedures */
CREATE ROLE StoredExecutor

/* Grant stored procedure execute rights
   to the role */
GRANT EXECUTE TO StoredExecutor   -- OR  ->  GRANT EXECUTE ON SCHEMA::schema_name TO StoredExecutor

/* Add a user to the StoredExecutor role */
EXEC sp_addrolemember 'StoredExecutor', 'UserName'

================

naadyev@gmail.com

Sunday, February 2, 2014

FIX: SharePoint Designer The Server Could Not Complete Your Request

FIX: SharePoint Designer  The Server Could Not Complete Your Request

1- Open IIS  (Run -> inetmgr)
2- Select "SharePoint Web Services" and then click on "Authentication".
3- Enable "Anonymous Authentication"







naadydev@gmail.com