XPost: microsoft.public.sqlserver.newusers
From: genew@ocis.net
On Sat, 27 Nov 2010 11:21:35 +0100, Erland Sommarskog
wrote:
>Gene Wirchenko (genew@ocis.net) writes:
>> I suppose some might be due to slightly different versions. I
>> think that there are at least two downloads of SQL Server 2008
>> Express. Could anyone elaborate on this?
>
>For SQL Express, there are usually streamlined downloads for service packs.
>That is, you can download and install SQL 2008 SP2 in one go. With other
>editions you need to apply the service pack separately.
You may recall the experience I had getting SQL Server Express
running on my system. I tried to install the SP, and it failed. I
decided that I was not playing that game again.
>It is possible that there are differences in how database diagrams work
>between service packs. Then again, it is not that likely. The diagrams is
>a fairly old feature, and I don't think Microsoft touches it very much
>at all.
I was thinking of SSE as a whole, not any particular feature.
>I would also like to raise a word of caution of using the graphical
>tools in SSMS to create and moreover to change table definitions. There
>are serious flaws in how SSMS implement the table changes, of which some
>are not so directly apparent, which makes it even more devious. The
>diagrams as such may helpful to visualise the database, if you don't
>have a real data-modelling tool around (and they tend to be expensive,
>why many haven't.) But for actually creating tables you are better off
>with CREATE and ALTER TABLE.
Thank you for that bit. Do you have any examples of these
errors? A URL would be fine.
The book I am studying does both.
Sincerely,
Gene Wirchenko
--- SoupGate-Win32 v1.05
* Origin: you cannot sedate... all the things you hate (1:229/2)
|
