In this post, we are going to learn how to find out if the table is used in a Stored Procedure. we have multiple ways to do that. This System Stored Procedure will return you list of table/views used by the Stored procedure/View. You can pass the view name or Stored Procedure as p...
The task can execute a SQL command in two basic ways: by executing inline SQL statements or by executing stored procedures. The resulting action can also result in the need to perform one of two options: accepting return values in parameters or a result set. You can get an idea of how t...
2. The user who debugs the stored procedure should be a member of SQL Server's fixed Server role, SysAdmin. As a DBA, I may need to grant this privilege to the user who is in need of debugging a stored procedure. When I do that, I should trust the user so that he/she will not...
If your application is still in development then the best way is (as @Brad suggested) is static...
Note: You can not update the body of a stored procedure object after creation. To update the logic stored in an object, you must delete it and create it again with the same object name.Create a SQL Stored Procedure A stored procedure object can have multiple parameters and use any ...
Being paranoid, you want to know every possible occurrence of where your code or column name is being used in the database. Thankfully there is a utility in SQL Developer that can help you answer this question. That feature is Find Database Object ...
Hi, I am using stored procedure in programming. i have created on sp. i Want to see text of that sp. Is there any Query to find the text of a sp. Thanks in advance Regards MaheshNavigate: Previous Message• Next Message Options: Reply• Quote Subject Written By Posted ...
The bulk of the RAM used by SQL Server is used for page caching. Queries use very little RAM. What exactly are you trying it find out? Friday, September 22, 2017 3:41 PM ✅Answered That depends on what you mean with "consuming memory". You can query the plan cache to wrestle out...
quite large and it is not always easy to view the contents with the Log File Viewer. In a previous tip “Simple way to find errors in SQL Server error log” you discussed a method of searching the error log. Are there any other ways to search and find errors in the error log files...
Solved: Hi , I have stored procedure which pulls the data from table (@table_name - parameter) and insert the records into another table. I want to