Hello

Thanks for your answers!

maybe think so...!?

I will the result from:

@size_mdf = SET @sql_size_mdf = 'select SUM(size)*8/1024 from [master].sys.database_files where type = 0'

in this select row 6:

4 DECLARE

INSERT INTO [srsql1].[DatabaseReport].[dbo].[Database_File_Info]

EXEC sp_MSforeachdb @command1 =

'select name, physical_name, state_desc,

size*8/1024, max_size, growth*8/1024,

convert(datetime,(convert(int,(convert(float,getdat())))))

from ?.sys.database_files'

I will run this query on the server srsql1 which has a servergroup in registered...

Johan wrote:

: What happens if you execute that statement separately ?

: (is the error persistent ?)

When I run the query directly on the server, then I don't have the...

Hello Gail

I created the table.

When I start a new query about the registered servers, then I become this errors:

INSERT INTO DatabaseReport.dbo.Database_File_Info

EXEC sp_MSforeachdb @command1 = 'select name, physical_name, state_desc, size, max_size,...

Thats no problem!

This is the domain- and username (dom)\sadb. That isn't a DB.

srwebfactory(dom\sadb): An error occurred while executing batch. Error message is: This server returned a fewer number of result...

thanks for all ideas and answers!

@alzdba

I made a ServerGroup and a lot of server registrations:

ServerGroupI

- Srvdw

- Srvdw1

- Srvdentw

- ...

I can use a query over the group now, that's...

Hello

EXECUTE srvdentw.master.sys.sp_msforeachdb 'PRINT ''?'''

Msg 7411, Level 16, State 1, Line 1

Server 'srvdentw' is not configured for RPC.

Thanks miller

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "SQLNCLI10" for linked server "srvdentw" does not contain the table ""model"."sys"."database_files"". The table either does not exist or the...

This command doesn't run too:

EXEC sp_MSforeachdb @command1 = 'select * from srvdentw.?.sys.database_files'