No announcements
Found 1414943 threads
-
0 Votesdelete a stored procedure while executing
So it is possible to delete an SP by other user while someone else is executing it..Answered | 14 Replies | 3642 Views | Created by prasadbuddhika - Tuesday, August 21, 2012 11:13 AM | Last reply by SQLZealots - Wednesday, August 22, 2012 8:56 AM
-
0 Votes
Problem while execution of stored procedure
I am connecting to management studio using the newuser and executing the stored procedure.Answered | 9 Replies | 3388 Views | Created by satish11 - Thursday, May 3, 2012 5:56 AM | Last reply by satish11 - Thursday, May 3, 2012 2:27 PM -
1 Votes
Geeting TIMEOUT while executing a Stored Procedure.
Options -> Query Execution -> Execution time-out.Answered | 3 Replies | 7856 Views | Created by Satish Reddy G - Wednesday, October 29, 2014 5:59 AM | Last reply by Uri Dimant - Wednesday, October 29, 2014 8:54 AM -
1 Votes
Stored procedure executed in stored procedure
Hi IqPerf, You can also use OpenQuery to select data from a Stored Procedure.Answered | 4 Replies | 5427 Views | Created by lgPerf - Wednesday, April 27, 2011 2:12 PM | Last reply by Naomi N - Wednesday, April 27, 2011 3:04 PM -
0 Votes
dynamic execution of a stored procedure
Hi Darwin101, Please refer to the following ...Answered | 1 Replies | 3761 Views | Created by Darwin101 - Monday, October 3, 2011 3:09 PM | Last reply by Eileen Zhao - Tuesday, October 4, 2011 8:46 AM -
0 Votes
Stored procedure execution Timeout
Problem is that when we run stored procedure after some time it TimeOut.Answered | 3 Replies | 6433 Views | Created by DBA_LEARNER - Tuesday, March 19, 2013 8:52 PM | Last reply by Kalman Toth - Thursday, March 21, 2013 4:23 PM -
1 Votes
Execute Stored Procedures Asynchronously
I use this slow stored procedure in combination with the Entity Framework 4.0 - objects are created through views - updates, inserts and deletes ...Answered | 4 Replies | 12619 Views | Created by Marc Loeb - Saturday, November 12, 2011 7:55 PM | Last reply by Marc Loeb - Tuesday, November 15, 2011 2:16 PM -
2 Votes
how to write and execute a stored procedure to insert,update,select and delete records
Hi, Check the below link for how to call stored procedure in ...Answered | 4 Replies | 3744 Views | Created by im_asa - Thursday, October 25, 2012 7:14 AM | Last reply by Syed Shakeer Hussain - Thursday, October 25, 2012 9:16 AM -
1 Votes
Execute a stored procedure in other stored procedure
In addition to Paul's, to receive the values returned from the nested called stored procedure, besides the output parameter, there're two more alternative.Answered | 2 Replies | 982 Views | Created by asamaleti - Wednesday, January 20, 2016 9:50 PM | Last reply by Eric__Zhang - Thursday, January 21, 2016 1:37 AM -
0 Votes
Executing the Stored procedure
I have a stored procedure that is using try catch block.Answered | 5 Replies | 5282 Views | Created by anki2010 - Friday, April 8, 2011 1:00 AM | Last reply by Paresh Prajapati - Friday, April 8, 2011 12:10 PM -
0 Votes
Executing a SQL stored procedure
>>Can anyone advise what code to use for executing a stored procedure and not returning a dataset.Answered | 4 Replies | 925 Views | Created by system243trd - Saturday, April 9, 2016 7:03 AM | Last reply by David_JunFeng - Monday, April 11, 2016 2:36 AM -
0 Votes
Probleme Executing a stored procedure ....
Hi Bruno Here's a whole PHP file that should work for you, after you change the PDO connection string and the parameter to your stored procedure.Answered | 4 Replies | 10506 Views | Created by Bruno_Boccara - Thursday, July 12, 2012 2:26 PM | Last reply by Christian Tanamal - Saturday, August 3, 2013 10:06 AM -
0 Votes
HOW TO EXECUTE A STORED PROCEDURE
One way you can see how the stored-proc is executing is through the PROFILER.Answered | 4 Replies | 5430 Views | Created by justin_rock - Tuesday, November 30, 2010 2:51 PM | Last reply by Manoj Pandey (manub22) - Tuesday, December 7, 2010 10:58 AM -
0 Votes
Control Store Procedure Execution
there's no direct way to impose this restriction as far as I know apart from implementing a control table based approach where log each instance of execution of procedure for each ...Answered | 1 Replies | 840 Views | Created by Priya Bange - Tuesday, August 7, 2018 1:29 PM | Last reply by Visakh16 - Tuesday, August 7, 2018 1:39 PM -
0 Votes
slow execution of stored procedure
Hi Pranavgaidhani, You could use execution plan to analyze the T-SQL command.Answered | 2 Replies | 2149 Views | Created by Pranavgaidhani - Friday, April 12, 2013 9:58 AM | Last reply by Maggie Luo - Tuesday, April 16, 2013 10:11 AM -
2 Votes
Count stored procedure executions
If the stored procedure executes something several times inside the stored procedure, for example, with some kind of a loop, then you ...Answered | 2 Replies | 2988 Views | Created by Matt11380 - Monday, February 28, 2011 9:40 PM | Last reply by Noam B - Tuesday, March 1, 2011 7:46 AM -
0 Votes
Stored procedure execution plans
Hi Sean, Query compilation typically doesn't take too long unless your stored procedures are quite complicated - but I wouldn't expect more than a couple of ...Answered | 3 Replies | 7394 Views | Created by Sean Connolly - Monday, April 12, 2010 6:43 AM | Last reply by Plamen Ratchev - Monday, April 12, 2010 2:26 PM -
0 Votes
EXECUTE AS clause with stored procedures
I would be curious to know what you think about EXECUTE AS.Answered | 6 Replies | 7795 Views | Created by Cipherlad - Thursday, August 6, 2009 4:36 PM | Last reply by LeeFAR - Monday, August 10, 2009 2:29 PM -
1 Votes
execute stored procedure as a dataset
Hi, For use a stored procedure in dataset follow these steps as: In the dataset : Select Stored ...Answered | 2 Replies | 3609 Views | Created by tsql_new - Monday, December 10, 2012 5:46 PM | Last reply by Avanish Tomar - Tuesday, December 11, 2012 6:54 AM -
0 Votes
Executing Multiple Stored Procedure
forum=transactsql ), SQL Server will perform serial execution by default.Answered | 2 Replies | 990 Views | Created by lilutchay - Tuesday, February 12, 2019 5:43 PM | Last reply by Tom Cooper - Tuesday, February 12, 2019 8:15 PM - Items 1 to 20 of 1414943 Next ›
No announcements
