Article: SQL Server 2005 Express Technical Preview

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Site Related Forums

Article Discussion

Article: SQL Server 2005 Express Technical Preview

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-06-30 : 07:25:56

Microsoft announced the SQL Server 2005 Express Edition technical preview at Tech*Ed Europe. Express Edition is the renamed and much improved MSDE. Key features include the elimination of the query governer and support for databases up to 4GB in size. It's limited to 1 CPU and 1GB of RAM. They also have a feature called XCopy deployment. This seems to be the ability to copy a database into a certain directory and have SQL Server automatically recognize it and make it available for use. AND you can download it today.

Article Link.

sanjnep
Posting Yak Master

191 Posts

Posted - 2004-06-30 : 14:49:39

I think XCopy deployment is the great feature of SQL Server 2005.

Sanjeevshrestha

safigi
Starting Member

15 Posts

Posted - 2004-07-01 : 04:02:38

There is no query analyzer but you can use Toad for example....

byrmol
Shed Building SQL Farmer

1591 Posts

Posted - 2004-07-05 : 07:48:19

This looks great... Well done dropping the governer, increasing DB size, DTS runtime and easier delpoyment.. that will please a lot of people.

But the specs are a bit heavy..

Can someone confirm that Reporting Services will be part of the Express edition?

DavidM

"Always pre-heat the oven"

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-07-05 : 07:57:51

quote:
Can someone confirm that Reporting Services will be part of the Express edition.

Hey David, nice to see you around. How's that little one doing?

It appears MS intends to extend it to the reporting services controls offered in VS 2005. They mention it in the marketing spiel:

http://www.microsoft.com/sql/express/

EDIT: Hmmm.. Mixed signals from MS?? The following article indicates Reporting Services will not be offered to Express editions.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

No clarification here. :(

X002548
Not Just a Number

15586 Posts

Posted - 2004-07-06 : 16:06:32

Anyone install it yet?

Last thing I need to do is hose my desktop....but why no QA still?

Brett

8-)

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2004-07-06 : 17:57:08

I installed it with no problems.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 2004-07-07 : 04:02:27

check out http://blogs.msdn.com/sqlexpress for ongoing information.

-Euan

quote:
Originally posted by derrickleggett

I installed it with no problems.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

nmg196
Yak Posting Veteran

70 Posts

Posted - 2004-07-09 : 06:50:47

I could no longer rename tables after installing SQL Express (and had a few other issues) but this was solved after reregistering the SQLDMO dll in the BINN folder.

westmich
Starting Member

35 Posts

Posted - 2004-07-13 : 17:09:36

Is Full-Text Indexing available?

Westmich
Smart Web Solutions for Smart Clients
http://www.mindscapecreative.com

westmich
Starting Member

35 Posts

Posted - 2004-07-13 : 17:09:41

Is Full-Text Indexing available?

Westmich
Smart Web Solutions for Smart Clients
http://www.mindscapecreative.com

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 2004-07-19 : 22:41:07

No Full Text is not supported.

-Euan

demonbane
Starting Member

10 Posts

Posted - 2004-07-26 : 11:20:07

Does amyone know if sql server 2005 (Yukon) will have built-in backup compression. I know that SQL 2000 does not and that you have to use thrid party software to accomplish this. If some has heard of anything regarding this please let me know or direct me to where I can find this information.
Thanks
Jerry

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-07-26 : 14:49:27

As far as I know backup compression isn't part of SQL Server 2005.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

mohdowais
Sheikh of Yak Knowledge

1456 Posts

Posted - 2004-07-27 : 03:18:08

>> As far as I know backup compression isn't part of SQL Server 2005.

I'm not surprised. They'd probably get sued for unfair competition, and driving popular products such as SQLLiteSpeed out of business. Can't afford another Real crisis

TorreyKite
Starting Member

40 Posts

Posted - 2004-08-02 : 13:20:43

Hey guys,
I saw that the features page refered to it's support of ADO.NET 2.0
would it still support ADO 2.7 ? or anything else available to VB 6.0?
Thanks,
TK

TorreyKite
Starting Member

40 Posts

Posted - 2004-08-02 : 13:22:36

Hey guys,
I saw that the features page refered to it's support of ADO.NET 2.0
would it still support ADO 2.7 ? or anything else available to VB 6.0?
Thanks,
TK

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-10-20 : 18:18:29

Tired of waiting for XM....
Tired of having to use command line or one of the express IDEs to tinker...

Check out this pretty cool, light-weight GUI:

http://www.tegels.org/qara/

It even lets you create assemblies if you care to tinker with CLR integration.
Not a bad compliment to the free SQL 2005 engine.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources