Format result of sp_helpdb

Hello.

How to format field "create" (Jan 12 2005) in sp_helpdb
procedure to sth like yyyy-mm-dd (2005-01-12) in SQL?

bye...

--
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +----------+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+[BuKoX] (bukoxSPAMEROM_MOWIMY_NIE@.tlen.pl) writes:
> How to format field "create" (Jan 12 2005) in sp_helpdb
> procedure to sth like yyyy-mm-dd (2005-01-12) in SQL?

You would have to write your own version of sp_helpdb to that end. While
the source code is in master, I don't think it's worth the effort for
such a little change.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp