Tuesday, December 9, 2014

How can we stop pulling data from a table in SQL server ?

It looks funny when you think about it but its true.
One of the way  you can stop users to pull data from a table is not a Heap should be disable Cluster Index.

If you disable the Cluster Index as it has the data, You can't be accessible though you hold required permissions.

ALTER INDEX IndexName ON TableName DISABLE.

No comments:

Post a Comment