Data files from Database Object

The database object contains a member 'get_LogFiles' that returns a nice collection of the database's logfiles. I can't seem to find the comparable member to return the collection of datafiles. If someone can point me in the right direction, I would be most grateful

That's because log files do not reside in filegroups.

Check out the filegroup property, this contains a collection of data files.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com

sql

Data Collector (Collection Sets)

I read the BOL, besides the "Disk Usage" collection set, are there other collection sets to be added? What are the various collections sets that we can add. Can we add performance collection sets? The sproc for adding collections sets

sp_syscollector_create_collection_set

didn't seem to indicate what we types of collections which could be added, unless that was the @.logging_level.

Thanks

The next SQL Server 2008 technology preview provides additional collection sets (System Data Collection Sets) as well as additional collector types. These new collection sets and collector types will expand your options for creating custom collections sets.

dan

|||

To expand a bit on the answer above:

In the current CTP you can create collection sets that use T-SQL collector type. To do that you need to create a collection set using sp_syscollector_create_collection_set and then add items to it using sp_collector_create_collection_item. If you look at BOL topics for those SPs you should see examples of how to do that. If you run into any issues, please reply to this thread.

Regards,

Maciek Sarnowicz

Data Collector (Collection Sets)

I read the BOL, besides the "Disk Usage" collection set, are there other collection sets to be added? What are the various collections sets that we can add. Can we add performance collection sets? The sproc for adding collections sets

sp_syscollector_create_collection_set

didn't seem to indicate what we types of collections which could be added, unless that was the @.logging_level.

Thanks

The next SQL Server 2008 technology preview provides additional collection sets (System Data Collection Sets) as well as additional collector types. These new collection sets and collector types will expand your options for creating custom collections sets.

dan

|||

To expand a bit on the answer above:

In the current CTP you can create collection sets that use T-SQL collector type. To do that you need to create a collection set using sp_syscollector_create_collection_set and then add items to it using sp_collector_create_collection_item. If you look at BOL topics for those SPs you should see examples of how to do that. If you run into any issues, please reply to this thread.

Regards,

Maciek Sarnowicz

Data Collector (Collection Sets)

I read the BOL, besides the "Disk Usage" collection set, are there other collection sets to be added? What are the various collections sets that we can add. Can we add performance collection sets? The sproc for adding collections sets

sp_syscollector_create_collection_set

didn't seem to indicate what we types of collections which could be added, unless that was the @.logging_level.

Thanks

The next SQL Server 2008 technology preview provides additional collection sets (System Data Collection Sets) as well as additional collector types. These new collection sets and collector types will expand your options for creating custom collections sets.

dan

|||

To expand a bit on the answer above:

In the current CTP you can create collection sets that use T-SQL collector type. To do that you need to create a collection set using sp_syscollector_create_collection_set and then add items to it using sp_collector_create_collection_item. If you look at BOL topics for those SPs you should see examples of how to do that. If you run into any issues, please reply to this thread.

Regards,

Maciek Sarnowicz