Member Avatar for Hellodear

hello,

I have SQL server 2005 installed on my computer. How can i construct a database for my new website? From where can i start my process? I didn't find any loop inside. I have full of ASP pages.

Hope somebody would help me
AV

  • 2 Contributors
  • 1 Reply
  • 80 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by hollystyles
Member Avatar for hollystyles

Start -> run
type 'cmd' (without the quotes) press enter
at the prompt type 'osql -S(local) -E' (without the quotes) and press enter. (if you have SQL Express edition type 'osql -SComputername\SQLEXPRESS -E')

The -E switch is for a trusted connection using windows authentication, otherwise use -U<username> -P<password> to use Sql Server authentication. The switches are case sensitive.

1>create database myDB (press enter)
2>GO (press enter)
1>exit


You're done ! also if you look in start -> programs -> Microsoft Sql Server 2005 -> you may have Sql Server Management studio (not sure if this comes with SQlExpress) if you do you can create databases using that GUI.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.