can you try restoring all your databases from an ssis pkg and record the information you need into a table.

I have table

space used by this table is 100,000 MB . I...

guess I don't entirely understand why you would need to worry about the file list. I suppose if you wanted the ability to restore a single file from the...

guys.. any reply for this. Is this something not possible?

Kent

I am working on this script now ..

http://www.sqlservercentral.com/Forums/Topic648516-146-1.aspx#bm674855

Can you put some idea on this, actually i am trying to modify my script which is used for LiteSpeed so...

I am using this for table count in each db, is there a way i can do it on whole server for each dabase listing table count by server by...

i know sp_helpdb will give that info but i need only few db's and thier size in a single result set for a report.

Now i get this error...

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after the character string 'move"2004_12_REV" to "E:\SQL'.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near...

I tried this and get the follwing error:

Msg 105, Level 15, State 1, Line 1

Unclosed quotation mark after the character string 'move '.

Msg 102, Level 15, State 1, Line 1

Incorrect...

Manu

I didnt get how you want me to replace the restore script, I am looking something with similiar functioanlity and more over when i tried restore filelistonly i didnt come...

snapshot isolation ????

from the query you gave i got this result.

976

but still what is this??

I read the article form microsoft but i dont understand clearly and i am not sure if i need to apply that hotfix though i have SP2. I dont understand...

Sorru i posted in wrong place. I am running on SQL 2005 Enterprise.

I am able to pull all database file from each server by using this..

-- creates a table DatabaseFiles

IF OBJECT_ID('DatabaseFiles') IS NULL

BEGIN

SELECT TOP 0 *...