Click here to Skip to main content
15,887,746 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Data Binding Without DataSource Components Pin
Jesse Squire27-Mar-08 8:56
Jesse Squire27-Mar-08 8:56 
GeneralRe: Data Binding Without DataSource Components Pin
Brady Kelly27-Mar-08 9:19
Brady Kelly27-Mar-08 9:19 
GeneralRe: Data Binding Without DataSource Components Pin
Jesse Squire27-Mar-08 9:26
Jesse Squire27-Mar-08 9:26 
GeneralProblems with CascadingDropDown Pin
Malayil alex27-Mar-08 5:01
Malayil alex27-Mar-08 5:01 
Questionhow to Find client ID in Asp.net? Pin
ILLUSIONARY LIFE27-Mar-08 3:58
ILLUSIONARY LIFE27-Mar-08 3:58 
AnswerRe: how to Find client ID in Asp.net? Pin
Jesse Squire27-Mar-08 4:44
Jesse Squire27-Mar-08 4:44 
Generalproblem with stored procedue Pin
eyeseetee27-Mar-08 3:30
eyeseetee27-Mar-08 3:30 
GeneralRe: problem with stored procedue Pin
Jesse Squire27-Mar-08 3:32
Jesse Squire27-Mar-08 3:32 
That is certainly one possibility. There is an easy way to test that theory. Run the first stored procedure, and then use one of the SQL Server tools to verify that the table exists. If not, then verify that any open transactions have been committed.

Your user will need either the ddladmin or dbo security roles to create a table. One thing that I'd advise is considering an alternative approach. Granting either of these roles to the database user from a website has a detrimental effect on the security of the database. If there is no way to accomplish what you need to do without creating a table, you may wish to consider having the stored procedure impersonate another user with elevated permissions for just that action.

Hope that helps to get you started. Smile | :)

  --Jesse
"... the internet's just a big porn library with some useful articles stuck in." - Rob Rodi

GeneralRe: problem with stored procedue Pin
eyeseetee27-Mar-08 3:48
eyeseetee27-Mar-08 3:48 
GeneralRe: problem with stored procedue ALSO Pin
eyeseetee27-Mar-08 3:50
eyeseetee27-Mar-08 3:50 
GeneralRe: problem with stored procedue ALSO Pin
Jesse Squire27-Mar-08 3:55
Jesse Squire27-Mar-08 3:55 
GeneralRe: problem with stored procedue Pin
Jesse Squire27-Mar-08 3:53
Jesse Squire27-Mar-08 3:53 
GeneralRe: problem with stored procedue Pin
eyeseetee27-Mar-08 4:07
eyeseetee27-Mar-08 4:07 
GeneralRe: problem with stored procedue Pin
Jesse Squire27-Mar-08 4:35
Jesse Squire27-Mar-08 4:35 
GeneralRe: problem with stored procedue Pin
eyeseetee27-Mar-08 4:48
eyeseetee27-Mar-08 4:48 
Questionregarding iframe with word document in a webpage Pin
saikiran27-Mar-08 3:21
saikiran27-Mar-08 3:21 
GeneralRe: regarding iframe with word document in a webpage Pin
Jesse Squire27-Mar-08 3:30
Jesse Squire27-Mar-08 3:30 
GeneralRe: regarding iframe with word document in a webpage Pin
saikiran27-Mar-08 3:45
saikiran27-Mar-08 3:45 
GeneralRe: regarding iframe with word document in a webpage Pin
Jesse Squire27-Mar-08 3:50
Jesse Squire27-Mar-08 3:50 
General[Message Deleted] Pin
saikiran27-Mar-08 4:10
saikiran27-Mar-08 4:10 
GeneralRe: regarding iframe with word document in a webpage Pin
Jesse Squire27-Mar-08 4:38
Jesse Squire27-Mar-08 4:38 
QuestionChaning the DLL Name while Publishing the Website Pin
danasegaranea27-Mar-08 3:17
danasegaranea27-Mar-08 3:17 
GeneralRe: Chaning the DLL Name while Publishing the Website Pin
Declan Bright27-Mar-08 4:28
Declan Bright27-Mar-08 4:28 
Questionhow to use cultural Info class for ... Pin
koolprasad200327-Mar-08 2:33
professionalkoolprasad200327-Mar-08 2:33 
AnswerRe: how to use cultural Info class for ... Pin
Jesse Squire27-Mar-08 2:48
Jesse Squire27-Mar-08 2:48 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.