If you need to grant a specified permission to all stored prcedures you can execute the following script DECLARE @User sysname SET @User = '<USER>' SELECT 'GRANT EXECUTE ON ' + name + ' TO ' + @User FROM sysobjects WHERE
Read More...
Imagine you have file saved in a database. Then you have an aspx page that gets that page and sends it back to the user. If you just simply use Response.BinaryWrite you get the browser's download dialog box and the file's name will be the aspx
Read More...