Where are sp's and views stored? 1

[Bazza]

Hi Everybody,

I am physically organising a database server to tune it for high performance, i.e. separating the data, logs, indexes etc. on separate raid volumes.

Whilst I can define the location of most objects, I don't see anyway to do this for stored procedures and views. Are they located on the default filegroup and if so where ?

Thanks and regards

Bazza

 

[tlbroadbent]

They are stored in the syscomments table on each database. Terry

http://members.home.net/tlbroadbent/index.htm