Local Log in for Enterprise manager

[cpitc]

I have a laptop with SQL Enterprisr manager loaded. My log ins only relate to my work place. Is there a way where I can open it open locally so i can make my own databses and perhaps load the Northwind databse.

Please advise anyone, Thanks

 

[gmmastros]

If you want Northwind so that you can learn how to use SQL, I would suggest a different approach.

I would recommend that you load a newer version of SQL instead. Enterprise Manager shipped with SQL2000 (a 10 year old database). Microsoft has distributed 2 version upgrades since then. There is SQL2005 and SQL2008. Both of the newer version offer free database engines (with very modest restrictions). I would encourage you to do a google search on "SQL Express 2008 Download". You will want to download and install the database engine AND the management studio. These are separate downloads, so make sure you get both.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[cpitc]

Its actually 2005 I need and it is so I can prepare a training course wiithout network connection. I assume it will be the same SQL Express 2005 Database engine and then Management Studio. Do you know any good links?

I will take a browse anyway

 

[gmmastros]

Start here:

http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLBill]

This is probably the best link:

http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[cpitc]

Hi

Thanks for your replies, Got both downlaoded and set up now.

 

[cpitc]

Hi

Following on from this, I have now examined more closely the express edition of 2005 I have noticed it does not have Management options. So I can not for example show Scheduled Tasks.

Do you know of any free download for the SQL 2005 Management Studio that will incliude all tools? if so could you supply the link please.

Thanks

 

[gmmastros]

It's the SQL agent service that allow for scheduled tasks. The agent was included in MSDE 2000, but Microsoft decided to remove it from sqlexpress (both 2005 & 2008). It's a shame too because it's a really handy thing to have around.

There is a developer edition of SQL Server that does include the agent, but it's not free. Last time I checked, it was about $50.

I have about 150 customers that are using SQL Express. What I do is to create a .bat file that contains a call to SQLCMD. I then use the windows task scheduler to call the batch file instead of using SQL Agent. It tales a little longer to set up, but it works just as well.

It's something to consider.

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom