Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-18 : 09:54:11
|
| Rafiq writes "Hi,Any body know any disadvantages about Dynamic Sql? if you have any ideas about it,please try to share with me.Thanks" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-03-18 : 10:06:15
|
| You have to grant permissions to the tables (which raises security concerns). Execution plans are recompiled at runtime (which impacts performance). And it is more difficult to maintain/modify (which creates headaches for developers and dbas). |
 |
|
|
|
|
|
Dynamic Sql