SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: SQL Server 2005 Express Technical Preview
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 06/30/2004 :  07:25:56  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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

USA
191 Posts

Posted - 06/30/2004 :  14:49:39  Show Profile  Visit sanjnep's Homepage  Reply with Quote
I think XCopy deployment is the great feature of SQL Server 2005.



Sanjeevshrestha
Go to Top of Page

safigi
Starting Member

Hungary
15 Posts

Posted - 07/01/2004 :  04:02:38  Show Profile  Reply with Quote
There is no query analyzer but you can use Toad for example....
Go to Top of Page

byrmol
Shed Building SQL Farmer

Australia
1591 Posts

Posted - 07/05/2004 :  07:48:19  Show Profile  Reply with Quote
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"

Edited by - byrmol on 07/05/2004 08:07:14
Go to Top of Page

ehorn
Flowing Fount of Yak Knowledge

USA
1631 Posts

Posted - 07/05/2004 :  07:57:51  Show Profile  Reply with Quote
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. :(

Edited by - ehorn on 07/05/2004 08:02:32
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 07/06/2004 :  16:06:32  Show Profile  Reply with Quote
Anyone install it yet?

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



Brett

8-)
Go to Top of Page

derrickleggett
Pointy Haired Yak DBA

USA
4184 Posts

Posted - 07/06/2004 :  17:57:08  Show Profile  Visit derrickleggett's Homepage  Send derrickleggett an AOL message  Send derrickleggett a Yahoo! Message  Reply with Quote
I installed it with no problems.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 07/07/2004 :  04:02:27  Show Profile  Reply with Quote
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.

Go to Top of Page

nmg196
Yak Posting Veteran

United Kingdom
70 Posts

Posted - 07/09/2004 :  06:50:47  Show Profile  Visit nmg196's Homepage  Send nmg196 an ICQ Message  Reply with Quote
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.
Go to Top of Page

westmich
Starting Member

USA
35 Posts

Posted - 07/13/2004 :  17:09:36  Show Profile  Visit westmich's Homepage  Reply with Quote
Is Full-Text Indexing available?

Westmich
Smart Web Solutions for Smart Clients
http://www.mindscapecreative.com
Go to Top of Page

westmich
Starting Member

USA
35 Posts

Posted - 07/13/2004 :  17:09:41  Show Profile  Visit westmich's Homepage  Reply with Quote
Is Full-Text Indexing available?

Westmich
Smart Web Solutions for Smart Clients
http://www.mindscapecreative.com
Go to Top of Page

euan_garden
Microsoft SQL Server Product Team

34 Posts

Posted - 07/19/2004 :  22:41:07  Show Profile  Reply with Quote
No Full Text is not supported.

-Euan
Go to Top of Page

demonbane
Starting Member

USA
10 Posts

Posted - 07/26/2004 :  11:20:07  Show Profile  Visit demonbane's Homepage  Reply with Quote
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

Edited by - demonbane on 07/26/2004 11:20:25
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

USA
4138 Posts

Posted - 07/26/2004 :  14:49:27  Show Profile  Visit graz's Homepage  Reply with Quote
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.
Go to Top of Page

mohdowais
Sheikh of Yak Knowledge

United Arab Emirates
1456 Posts

Posted - 07/27/2004 :  03:18:08  Show Profile  Visit mohdowais's Homepage  Reply with Quote
>> 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

OS
Go to Top of Page

TorreyKite
Starting Member

USA
40 Posts

Posted - 08/02/2004 :  13:20:43  Show Profile  Reply with Quote
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
Go to Top of Page

TorreyKite
Starting Member

USA
40 Posts

Posted - 08/02/2004 :  13:22:36  Show Profile  Reply with Quote
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
Go to Top of Page

ehorn
Flowing Fount of Yak Knowledge

USA
1631 Posts

Posted - 10/20/2004 :  18:18:29  Show Profile  Reply with Quote
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.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000