views:

98

answers:

1

So I installed a trial of SQL Server 2008 enterprise edition while waiting for MSDN licenses to come through - I now want to uninstall the trial and replace it with a developer edition installation.

However, I'd like to first know how long I have left on the trial. Is there a way to do this programmatically with SQL? I looked at create_date in sys.databases, but these give dates that are in 2003 (which is, I guess, when master and model were originally created).

+1  A: 

See http://mangalpardeshi.blogspot.com/2009/05/expiration-date-of-sql-server.html

Edit: Just spotted you want to do this programatically. Guess you could start a profiler trace then open management studio to see how it gets this info!

Martin Smith
Yeah; been there. But yes - I want to know if I can do something like select license_expiry from sys.importantserverstuff.
Peter Mounce