Hi team , i have a table in my db . What i want is , a list for the user to manually select what coloumns are to be shown, As the user submits that list selection page , only the selected coloumns are to be shown

SQL Server Administration
1

Hi team , i have a table in my db . What i want is , a list for the user to manually select what coloumns are to be shown, As the user submits that list selection page , only the selected coloumns are to be shown .

2

That is something that you are either going to have to present to the user by a front end interface that gives them drop down choices and a search button, look on line for 3rd party software if you don't want to let them use Management Studio. Or Let them use Management Studio to run a query (putting them all in a ReadOnlyUsers group and only giving them read access) and show them how.

Nancy