I tried to re-install the Adventureworks Databases and a message came up and said they were already installed. I can't locate them.

When I open Sql Server Management studio and...

I don't see the adventureworks database when I connect to the instance. I will re-install the sample databases again and see what happens.

ok, I ran setup again and created an instance for sql 2005 but I don't see the adventureworks databases. Whats the problem?

I will try it and get back to you.

thanks

Aaron,

thanks for responing to my post. I see my error - I did not give sql 2005 a 'name instance'. Can this be fixed now...

Thanks all for the advice. Since I am new to this situation management is listening to me to purchase a backup server.

To Fix my own problem - I Went into the registry and deleted all instances of Sql: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer

Then I rebooted the Server,...

Thanks all. To clarify here is some sample data:

           COMPARISON WITH LAST YEAR

              -------------------------

         ACTUAL   ACTUAL

        August     August

          2005       2004

 Room sales    $300,000   $220,000

 Rooms Available  2,000      2,085

 =============

    COMPARISON WITH This YEAR's Budget

    ...

thanks. I also want to print to a file with just the name and crdate.

I am keeping up my sql server skills and learning 2003 server at home. I already have a copy of the Enterprise version of SQLSERVER 2000.

ok thanks. Another question - for a small home network (1- windows 2003 server, sql server 2000 installed on same server) for the licensing mode - is it better to...

thanks all for the suggestions

Grasshopper,  

 I am interested in purchasing Partition Commander to partition my hard drives on a Dell 1400SC with Windows 2003 Server. How did this product work for you?  Partition Magic for...

ok, thanks I will try it.

I am a newbie to T-SQL so please bear with me. I am trying to understand and get your query to work for me. I created a 'tablename' with (db,fileID,...