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 - 2006-05-05 : 08:43:13
|
| Ken writes "Is there an easier way to refresh views in a database when you add a column to a replicated table or is refreshing the views not necessary? We currently have VB.Net programs that utilize may views / procs etc in our databases. When we add a field to replicated table (or a table in general that the view uses) it seems to break the VB.Net program every time. It was mentioned to me that all the corresponding views needed to be refreshed and manually at that. To me, this seems very time consuming since there can be up to 20 or so views being used depending on what replicated table had the added field. If you could give me an answer to this, that would be great. Thanks.Ken" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-05-05 : 09:27:18
|
| trydbcc freeproccachedbcc dropcleanbuffers==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-05 : 09:42:29
|
try sp_recompile after the changewe haven't encountered this on our reporting server and the replicated tables do get modified once in a whilebut this is something worth checking  --------------------keeping it simple... |
|
|
|
|
|
|
SQL views on replicated tables ?