Posts

Showing posts from April, 2011

Database role access level issues in sql server.

Image
If you create one login named as 'kumar' and map the login to the user 'kumar' in the 'test' database. Let us see below scenario. 1.First i gave db_datareader role for that login 'kumar' ,then try to execute below queries.
Let us see what will happen.

To resolve above error ,what role needs to give for 'kumar' login?

Alert :Disk is full ,As a DBA,What will you do?

Image
1.Find out the free space in the drives by 
XP_FIXEDDRIVES