Archive

Archive for August 2, 2012

Great post on SQL azure by Anup .. SQLSailor

August 2, 2012 Leave a comment

hey everyone …

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

do check out

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

Advertisements
Categories: INDEXES

SQL Server 2008 tutorial — Mail setup

August 2, 2012 Leave a comment

Categories: INDEXES

Find out permissions of currently logged in USER or your permissions

August 2, 2012 Leave a comment

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

 

Categories: INDEXES