In SQL Server I use a query like this to query the size and server version:
    select CAST(SUM(size) * 8. AS integer) as size, @@Version dbversion  
      from sys.master_files WITH(NOWAIT)
   where database_id = DB_ID()
group by database_id

What would the equivalent in ElevateDB be?

No ideas on this one?

Ideal Software Systems wrote:

In SQL Server I use a query like this to query the size and server version:
    select CAST(SUM(size) * 8. AS integer) as size, @@Version dbversion  
      from sys.master_files WITH(NOWAIT)
   where database_id = DB_ID()
group by database_id

What would the equivalent in ElevateDB be?

On 2/13/2015 2:48 PM, Ideal Software Systems wrote:
> No ideas on this one?
>
> Ideal Software Systems wrote:
>
> In SQL Server I use a query like this to query the size and server version:
>       select CAST(SUM(size) * 8. AS integer) as size, @@Version dbversion
>         from sys.master_files WITH(NOWAIT)
>      where database_id = DB_ID()
> group by database_id
>
> What would the equivalent in ElevateDB be?

I don't think you can get either of these today with EDB built-in
capabilities - you can extend EDB though to obtain them.

There is also a table version available that might serve your purpose
(not sure what you need to do with the db version).

Raul