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 |
jggtz
Starting Member
32 Posts |
Posted - 2008-04-21 : 22:02:10
|
MS SQL Server 2005What happens if 2 or more users use the same View at the same time or while other user is using it, normally from Crystal Reports 10It rebuilds again? Or?Thanks |
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-21 : 22:36:50
|
Views aren't built - they are incorporated into the query plan.You will find there's no problem.==========================================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. |
|
|
jggtz
Starting Member
32 Posts |
Posted - 2008-04-21 : 23:10:42
|
Thanks!I think I got it!Views are only queries that execute when 'called' and use clients' resources |
|
|
|
|
|