Click here to Skip to main content
15,850,547 members

Comments by Jashobanta (Top 17 by date)

Jashobanta 18-Dec-13 16:40pm View    
check my answer..
Jashobanta 18-Dec-13 16:25pm View    
What is the error you are getting?
Jashobanta 18-Dec-13 16:20pm View    
sorry.. did not notice that question has been asked by someone else..my mistake Maciej, these basic suggestions are not for you. You can ignore em.. you can suggest any corrections though..
Jashobanta 18-Dec-13 16:14pm View    
I have not reposted, I have mentioned 2 different approaches to do the same. One is using entity framework which will be created based on your requirements and class structures..
But I can feel that you want to create numerous tables on button clicks.. which though I don't know why someone would do.. in this case, second approach will work fine, assuming that you know how to call a parameterized stored proc from ado.net.. and if it solves the issue, do mark it as solution..
Jashobanta 18-Dec-13 16:08pm View    
I don't think Grant or Deny can be used to allow an user for executing DML commands, not for DDL commands..
you can deny an user to do a select on a table or insert on a table but you cannot allow an user to create a table if the user is not listed in either sysadmin or dbcreator group..