Click here to Skip to main content
15,916,835 members
Home / Discussions / Database
   

Database

 
AnswerRe: date time problem Pin
Wendelius18-Feb-09 20:26
mentorWendelius18-Feb-09 20:26 
GeneralRe: date time problem Pin
anujbanka178418-Feb-09 21:12
anujbanka178418-Feb-09 21:12 
GeneralRe: date time problem Pin
Wendelius19-Feb-09 5:52
mentorWendelius19-Feb-09 5:52 
Questionsql query parser Pin
me_aaryan18-Feb-09 18:52
me_aaryan18-Feb-09 18:52 
AnswerRe: sql query parser Pin
Wendelius18-Feb-09 20:18
mentorWendelius18-Feb-09 20:18 
AnswerRe: sql query parser Pin
Ashfield18-Feb-09 20:19
Ashfield18-Feb-09 20:19 
Question[Message Deleted] Pin
Tina P18-Feb-09 15:50
Tina P18-Feb-09 15:50 
AnswerRe: Question in regards to SQL server 2005 Installation and setup Pin
Wendelius18-Feb-09 17:59
mentorWendelius18-Feb-09 17:59 
Hi,

Tina P wrote:
SQL server 2005 express edition (120) day trial


If you installed Express Edition, it's actually not a trial and won't expire after 120 days. It's free to use.

Tina P wrote:
its not showing me the database that comes with the SQL server basis install (such as Northwind and Punlishers etc)


First thing is that os the database runniong. Check your services (SQLExpress...) to make sure it's started. After that, you have to create a connection:
- open server explorer
- select Data Connections , right click and select Add connection...
- in the dialog define the server name for example in format machinename\instancename. You can check the instance name from your Windows services (the instance name is in parenthesis).
After that you should have a connection.

Then another thing is that there are no sample databases shipped along the server anymore. You can download and instal AdventureWorks (which is a newer sample database) from: http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=18407[^]

Hope this helps,

Mika

The need to optimize rises from a bad design.My articles[^]

QuestionDynamically adding a file to a connection manager in an SSIS package executed by Sql Stored porcedure Pin
mecca118-Feb-09 10:59
mecca118-Feb-09 10:59 
QuestionSSIS: SQL2005 to AS400 Pin
dan!sh 18-Feb-09 6:33
professional dan!sh 18-Feb-09 6:33 
AnswerRe: SSIS: SQL2005 to AS400 Pin
Giorgi Dalakishvili18-Feb-09 7:09
mentorGiorgi Dalakishvili18-Feb-09 7:09 
AnswerRe: SSIS: SQL2005 to AS400 Pin
Wendelius18-Feb-09 7:10
mentorWendelius18-Feb-09 7:10 
QuestionNotification services Pin
hadad18-Feb-09 4:23
hadad18-Feb-09 4:23 
AnswerRe: Notification services Pin
Wendelius18-Feb-09 6:03
mentorWendelius18-Feb-09 6:03 
GeneralRe: Notification services Pin
Giorgi Dalakishvili18-Feb-09 6:26
mentorGiorgi Dalakishvili18-Feb-09 6:26 
GeneralRe: Notification services Pin
Wendelius18-Feb-09 7:03
mentorWendelius18-Feb-09 7:03 
QuestionTrack DB changes Pin
J-Cop18-Feb-09 3:23
J-Cop18-Feb-09 3:23 
AnswerRe: Track DB changes Pin
Wendelius18-Feb-09 6:16
mentorWendelius18-Feb-09 6:16 
GeneralRe: Track DB changes [modified] Pin
J-Cop18-Feb-09 21:21
J-Cop18-Feb-09 21:21 
GeneralRe: Track DB changes Pin
Wendelius18-Feb-09 23:03
mentorWendelius18-Feb-09 23:03 
AnswerRe: Track DB changes Pin
David Mujica18-Feb-09 6:26
David Mujica18-Feb-09 6:26 
QuestionFOR XML EXPLICIT driving me nuts! Pin
J4amieC18-Feb-09 1:47
J4amieC18-Feb-09 1:47 
AnswerRe: FOR XML EXPLICIT driving me nuts! Pin
Wendelius18-Feb-09 5:56
mentorWendelius18-Feb-09 5:56 
QuestionSimultaneous access to SQL server... Pin
ashok_rgm18-Feb-09 0:07
ashok_rgm18-Feb-09 0:07 
AnswerRe: Simultaneous access to SQL server... Pin
Ashfield18-Feb-09 1:29
Ashfield18-Feb-09 1:29 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.