Click here to Skip to main content
15,913,610 members
Home / Discussions / C#
   

C#

 
GeneralRe: richTextBox problem 2 Pin
_Q12_27-May-11 6:35
_Q12_27-May-11 6:35 
AnswerRe: richTextBox problem 2 Pin
Luc Pattyn27-May-11 6:39
sitebuilderLuc Pattyn27-May-11 6:39 
GeneralRe: richTextBox problem 2 Pin
Dan Mos27-May-11 9:28
Dan Mos27-May-11 9:28 
GeneralRe: richTextBox problem 2 Pin
_Erik_27-May-11 3:25
_Erik_27-May-11 3:25 
GeneralRe: richTextBox problem 2 Pin
_Q12_27-May-11 8:05
_Q12_27-May-11 8:05 
AnswerRe: richTextBox problem 2 Pin
BobJanova27-May-11 5:03
BobJanova27-May-11 5:03 
AnswerRe: richTextBox problem 2 Pin
_Q12_27-May-11 7:59
_Q12_27-May-11 7:59 
QuestionError running sp in C# Pin
MAW3026-May-11 16:31
MAW3026-May-11 16:31 
I found the following sp on this website, when I run it by right clicking on the procedure in the DB using the command "Execute Stored Procedure" it works fine. However, when I run the sp from C# I get the following error:

//err.Message = "Microsoft SQL Native Client:
//CONFIG statement cannot be used inside a user transaction.\\42000 = 574;
//Microsoft SQL Native Client: Configuration option 'show advanced options'
//changed from 0 to 1. Run the RECONFIGURE statement to install.\\01000 = 15457"



ALTER PROCEDURE [dbo].[sp_Database_ResetMemory]
AS

EXEC sp_configure 'show advanced options', 1;
RECONFIGURE WITH OVERRIDE;

EXEC sp_configure 'max server memory (MB)';

EXEC sp_configure 'max server memory (MB)', 512;
RECONFIGURE WITH OVERRIDE;

EXEC sp_configure 'max server memory (MB)';

WAITFOR DELAY '00:00:15';

EXEC sp_configure 'max server memory (MB)', 2147483647;
RECONFIGURE WITH OVERRIDE;

EXEC sp_configure 'max server memory (MB)';

EXEC sp_configure 'show advanced options', 0;
RECONFIGURE WITH OVERRIDE;

Can anyone tell me what the problem is.
Thanks in advance,
Michael
AnswerRe: Error running sp in C# PinPopular
Richard MacCutchan26-May-11 22:16
mveRichard MacCutchan26-May-11 22:16 
QuestionUserAppDataRegistry - disable ProductVersion component in key path Pin
bob1697226-May-11 15:41
bob1697226-May-11 15:41 
QuestionRegEx for Fist Charactr is Positive Pin
Kevin Marois26-May-11 11:31
professionalKevin Marois26-May-11 11:31 
AnswerRe: RegEx for Fist Charactr is Positive Pin
Luc Pattyn26-May-11 12:00
sitebuilderLuc Pattyn26-May-11 12:00 
GeneralRe: RegEx for Fist Charactr is Positive Pin
Manfred Rudolf Bihy26-May-11 12:26
professionalManfred Rudolf Bihy26-May-11 12:26 
GeneralRe: RegEx for Fist Charactr is Positive [modified] Pin
Luc Pattyn26-May-11 12:40
sitebuilderLuc Pattyn26-May-11 12:40 
GeneralRe: RegEx for Fist Charactr is Positive Pin
SledgeHammer0126-May-11 12:59
SledgeHammer0126-May-11 12:59 
AnswerRe: RegEx for Fist Charactr is Positive Pin
Luc Pattyn26-May-11 13:04
sitebuilderLuc Pattyn26-May-11 13:04 
GeneralRe: RegEx for Fist Charactr is Positive Pin
SledgeHammer0126-May-11 13:13
SledgeHammer0126-May-11 13:13 
GeneralRe: RegEx for Fist Charactr is Positive Pin
BobJanova26-May-11 23:31
BobJanova26-May-11 23:31 
AnswerRe: RegEx for Fist Charactr is Positive Pin
Manfred Rudolf Bihy26-May-11 12:22
professionalManfred Rudolf Bihy26-May-11 12:22 
GeneralRe: RegEx for Fist Charactr is Positive Pin
Luc Pattyn26-May-11 13:01
sitebuilderLuc Pattyn26-May-11 13:01 
GeneralRe: RegEx for Fist Charactr is Positive Pin
Manfred Rudolf Bihy26-May-11 13:25
professionalManfred Rudolf Bihy26-May-11 13:25 
AnswerRe: RegEx for Fist Charactr is Positive Pin
BobJanova26-May-11 23:33
BobJanova26-May-11 23:33 
QuestionExecuting Javascript Pin
mjackson1126-May-11 10:00
mjackson1126-May-11 10:00 
AnswerRe: Executing Javascript Pin
BobJanova26-May-11 23:38
BobJanova26-May-11 23:38 
QuestionHow to combine 3 different list objects into a single list object? Pin
Goalie3526-May-11 5:48
Goalie3526-May-11 5: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.