Prev: Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB95
Next: dfrgifc.exe & dfrgntfs.exe starting for some reason
From: Hiwj on 19 Jan 2010 04:27
I am using SQL Express 2005, which has been working fine (when I connect to
it using Management Studio Express 2005).

I have upgraded the Management Studio to 2008, but I now cannot reorder
colums in my tables. If I connect to the same database using MSE2005, then I
can reorder them.

Has this feature been removed from MSE2008?
From: Uri Dimant on 19 Jan 2010 05:45
How do you re-order them? I tried to drag and dropin table design window the
columns and it worked just fine?

If you do SELECT <columns> does the order matter for you?

"Hiwj" <Hiwj(a)discussions.microsoft.com> wrote in message
news:B0058667-194A-49F8-AC32-9CD797B7921E(a)microsoft.com...
>I am using SQL Express 2005, which has been working fine (when I connect to
> it using Management Studio Express 2005).
>
> I have upgraded the Management Studio to 2008, but I now cannot reorder
> colums in my tables. If I connect to the same database using MSE2005, then
> I
> can reorder them.
>
> Has this feature been removed from MSE2008?


From: Tibor Karaszi on 19 Jan 2010 10:53
There are issues and questionable behaviors in the design table
functionality, how it generates the underlying script for doing such
structural changes. this is why the behavior is disabled by default. You can
enable the functionality (Tools, Options - then look around). Also, check
connect.microsoft.com and search for the issues so you won't get bitten.
Note that you can always type the SQL commands yourself - which is the
safest way!

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"Hiwj" <Hiwj(a)discussions.microsoft.com> wrote in message
news:B0058667-194A-49F8-AC32-9CD797B7921E(a)microsoft.com...
> I am using SQL Express 2005, which has been working fine (when I connect
> to
> it using Management Studio Express 2005).
>
> I have upgraded the Management Studio to 2008, but I now cannot reorder
> colums in my tables. If I connect to the same database using MSE2005, then
> I
> can reorder them.
>
> Has this feature been removed from MSE2008?

 | 
Pages: 1
Prev: Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB95
Next: dfrgifc.exe & dfrgntfs.exe starting for some reason