The same error I am getting.

TITLE: Database Properties

------------------------------

An error occurred while starting mirroring.

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Neither the partner nor the witness server instance...

Hi Gian,

The query worked for me. I have used sp_msforeachdb to get all database size. Below is the query.

drop table #temp1

create table #temp1

(name varchar(50),

database_size varchar(50),

Freespace varchar(50))

insert into #temp1(name,database_size,Freespace)

exec sp_msforeachdb

'use ?;SELECT...

Hi,

I tried using linked server and it is working on test.

But I am not allowed to create linked server on prod servers.

Any other ways??

I tried but it is giving below error as the sp_spaceused output is in two rows.

Msg 213, Level 16, State 7, Procedure sp_spaceused, Line 113

Column name or number of supplied...

Thanks

Its worked !

I have the same issue. Need to give exec permission on sys.Xp_prop_oledb_provider. Is it dangerous to grant permissions ???