Newbie Question

I just purchased Micosoft SQL Server 2005 because I have a database/coldfusion/flash project and the company is sending me .sql files. When I click on the file to run it, it opens the anaylizer and connects. Next I execute the code and it seems to work fine. If I look in the output window I can see that it created the proper tables, but I don't know where they are. How do I get to them and export them in .mdb format so I can alter them?Open up Enterprise Manager and look in the databases there for the objects created.
To export them to Access (mdb file), try linking to them through Access using ODBC connection.

newbe ? re:date format

Hi, I'm developing a page in asp.net using a sqldb and one of the values I'm sending to the database is a date/time value. I only want the table to show the date in short format, no time. Is there a way to restrict or convert the data in the table design mode?
Thanks
RaifSQL Server dates are stored as numeric values that interpreted as dates with time of day. Formatting of output should be handled by your user interface, not the database server.|||Thanks I sort suspected that as I started writing the post.
Thanks again|||Go with a smalldatetime in the sql table so that you are only using a (4). The go with a .ToString() and something like this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatetimeclasstostringtopic4.asp
Hope it helps.|||If you're doing straight SELECT from your ASP, you can use CONVERT(char(10), <your_date_field>, 101) on your date/time field.