• 0

I want to make a local SQL Server 2005...


Question

Hey

In SQL 2000, I could simply connect to a local host server (which I made in installation) and connect to a server on a local host. In SQL 2005, things are obviously different. Does someone know how to make a local server in SQL 2005 and make a database (or transfer a 2000 database) and simple work offline? This is for school so thats why it is offline.

8 answers to this question

Recommended Posts

  • 0
  On 12/05/2010 at 15:33, alfaaqua said:

In SQL 2000, I could simply connect to a local host server (which I made in installation) and connect to a server on a local host. In SQL 2005, things are obviously different.

How are things different? And WTF is the difference between connecting "to a local host server" and connecting "to a server on a local host"?? :wacko:
  • 0

http://www.connectio...sql-server-2005

Just use 'localhost' as the server name.

Use sp_detatch_db and sp_attach_db to install a copy of your db on the localhost, or restore a backup.

Restored or attached will be upgraded to SQL05 automatically.

  • 0
  On 13/05/2010 at 21:01, boogerjones said:

How are things different? And WTF is the difference between connecting "to a local host server" and connecting "to a server on a local host"?? :wacko:

Im not really sure how to start a SQL server service on my computer so it can itself become a SQL Server.

It is simply worded differently. I hope your period ends soon......... :unsure:

  Quote

http://www.connectio...sql-server-2005

Just use 'localhost' as the server name.

Use sp_detatch_db and sp_attach_db to install a copy of your db on the localhost, or restore a backup.

Restored or attached will be upgraded to SQL05 automatically.

Thanks :)

The lines on those pages though look like when I want to connect thru VB.

I simple want to be able to modify/create/delete databases with tables, columns etc then use commands on them such as select * from table and just have them display the result.

Hmm that bold part is not true as I rather just work with the database in SQL2000 mode.

  • 0
  On 17/05/2010 at 15:24, alfaaqua said:

The lines on those pages though look like when I want to connect thru VB.

I simple want to be able to modify/create/delete databases with tables, columns etc then use commands on them such as select * from table and just have them display the result.

Download the free SQL 2008 db and management tools. The SQL Management Studio will let you connect to a local or remote server and open a query window.

  • 0

A SQL server installed as the default instance allows you to connect using the host name or IP address, e.g. MyServer. When you install a fully fledged Sql Server (not express), it by default will instance as the default instance.

A named instance requires an additional identifier, e.g. MyServer\MySqlInstance. Sql Server Express by default installs as a named instance I believe.

  • 0
  On 18/05/2010 at 10:07, Antaris said:

A SQL server installed as the default instance allows you to connect using the host name or IP address, e.g. MyServer. When you install a fully fledged Sql Server (not express), it by default will instance as the default instance.

A named instance requires an additional identifier, e.g. MyServer\MySqlInstance. Sql Server Express by default installs as a named instance I believe.

Im using the Enterprise Edition.

Could someone please talk me thru to at least make a new "instance"? :)

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • WhatsApp document scanning gets closer to launch as more beta testers get access by Paul Hill Meta looks as though it’s getting closer to releasing WhatsApp’s native document scanner on Android because more people are now reporting they have access in the beta. This will give users a privacy-friendly way to snap photos of documents and automatically convert them to PDF ready for sharing. According to WABetaInfo, the feature comes with two modes: manual and automatic. The manual capture gives users more control over the process allowing them to adjust positioning and lighting to get the best quality scan. Automatic mode on the other hand automatically detects the edge of your document on its own and snaps the image without too much user input, making it faster and easier. Once the picture is taken, WhatsApp automatically converts it to a PDF file so that it can be shared and opened easily by the recipient. The file can be sent within private chats or group conversations. The entire scanning and conversion process takes place locally on your device, using Android’s built-in API for snapping documents. The document itself is also only stored locally until you decide to send it. Just like other WhatsApp messages, these scans are secured with end-to-end encryption when you send them to recipients. The only privacy risk is the user sending the PDF to the wrong person. The new feature was first noticed for Android a few weeks ago and with the latest beta it’s rolling out to more people. Once Meta has tested it across a wide array of devices, we will likely see it land for people on the stable version of WhatsApp. In recent weeks, we have also seen that Meta is testing new chat color themes in the beta releases. That feature doesn’t seem to have filtered down to the stable version yet, so be on the lookout for that too if that’s of interest to you.
    • Silly, illinformed comment but thanks for playing anyway. I mean, are you actually comparing a default browser on well over a billion devices with Firefox?
  • Recent Achievements

    • Collaborator
      Mighty Pen went up a rank
      Collaborator
    • Week One Done
      emptyother earned a badge
      Week One Done
    • Week One Done
      DarkWun earned a badge
      Week One Done
    • Very Popular
      valkyr09 earned a badge
      Very Popular
    • Week One Done
      suprememobiles earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      568
    2. 2
      +FloatingFatMan
      188
    3. 3
      ATLien_0
      177
    4. 4
      Skyfrog
      111
    5. 5
      Xenon
      110
  • Tell a friend

    Love Neowin? Tell a friend!