I created a really small database in MSSQL Server 2005 in order to get the SQL it requires to create it on the fly, but I haven't been able to do so. Basically, I want the script that creates the database exactly as I created it using SQL Server Management Studio (I don't care about the data since the database is empty, I only want the schema). I know there is a way to do it, but I don't remember how.
Any help really appreciated.
Thanks!