SQL DBA learning curve

hey everyone …

The new Windows Azure platform explained in detail by Anup .. THE SQLSailor

do check out

http://sqlsailor.com/2012/06/08/firstsqldatabase/

Find out permissions of currently logged in USER or your permissions

USE function fn_my_permissions in SQL Server 2005 or above .

Use AdventureWorks
Go
—————Return Callers permission on the current server
SELECT * FROM fn_my_permissions(NULL, ‘SERVER’);
Go

—————Return Callers permission on the current database
SELECT * FROM fn_my_permissions(NULL, ‘DATABASE’);
Go

————–Return Callers permission on the given object
SELECT * FROM fn_my_permissions(‘Sales.vIndividualCustomer’, ‘OBJECT’);
Go

for more info refer

http://msdn.microsoft.com/en-us/library/ms176097.aspx