you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
- 1 Answers
- 1137 Views
- I also Faced
- E-Mail Answers
Answer / Eshoo Jain
You can recompile the affected stored procedures after dropping and recreating the table. In SQL Server, you can use the RECOMPILE option for SP_REcompile or ALTER PROCEDURE statement.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a trigger and its types?
Explain the working of sql privileges?
Is it important for a database administrator to understand the operating system and file access?
what types of replication are supported in sql server? : Sql server database administration
What is local temp table?
After removing a table from database, what other related objects have to be dropped explicitly?
What are the indexes in sql server?
What are the main control-of-flow T-SQL constructs?
Can group by be used without aggregate functions?
Name few of the dcl commands in sql?
How do you drop an index?
Explain triggers in sql?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
