In my working environment I’ve asked to write a script to find security information which should return Server Logins, Database Logins and object level permissions. I’ve written that and I’m sharing this to you since this could be helpful to you.

Microsoft SQL Server Reporting Services enables organizations to transform valuable enterprise data into shared information for insightful, timely decisions at a lower total cost of ownership. In this article Im going to install SQL Server 2005 Reporting Services on Windows 2003 machine. Lets discuss about installation of reporting services.

We had a requirement where the user had to do a search on Overview/description field which had nvarchar (max) data type. Full text search can be used for searching against the LOB data types like nvarchar (max), text and BLOB data types like varbinary (max) and image data type. Please note that in image and text data type will be deprecated in the future and hence avoid using them.

This script gives a detailed information about permission for users in a database. This output lists Object name, Schema name, user name and permission. This is compatible only to SQL 2005.

This script gives a out script that can be used to script out the existing user permissions in a database.This is compatible only to SQL 2005.