Monday, March 19, 2012

DMO Databases uptime

Hi friends...
I need to query using isqlw the SQLService uptime (Or using DMO), could
anyone help me?get the create date of the tempdb using a SQLDMO object set to that database
.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Tinchos" wrote:

> Hi friends...
> I need to query using isqlw the SQLService uptime (Or using DMO), could
> anyone help me?|||or...
select
[name]
,crdate
from
master..sysdatabases
where
[name] = 'tempdb'
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Tinchos" wrote:

> Hi friends...
> I need to query using isqlw the SQLService uptime (Or using DMO), could
> anyone help me?

No comments:

Post a Comment