Error occurs when tried to view table design in Enterprise Manager

Dear All,
I have a problem
When I tried to view the table design throught Enterprise Manager's "Design
Table" function
If prompted
Table "XXXXX" could not be loaded
ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
What's happen?
Thanks~~Have both the server instance and your client tools been patched with at
least SP3a? Are you connected to Enterprise Manager on the same machine as
the database, or are you accessing it from a remote machine? Is your server
registration set up using windows auth or sql auth? Have you considered
managing objects using Query Analyzer?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Utada P.W. SIU" <wing0508@.hotmail.com> wrote in message
news:OHNwtHV7EHA.3120@.TK2MSFTNGP12.phx.gbl...
> Dear All,
> I have a problem
> When I tried to view the table design throught Enterprise Manager's
"Design
> Table" function
> If prompted
> Table "XXXXX" could not be loaded
> ODBC error: [Microsoft][ODBC SQL Server Driver]Communication link failure
> What's happen?
> Thanks~~
>|||My client pc haven't patch sp3a yet
however, when I using that sql server's Enterprise Manager to view the table
design, it prompt the same error to me...
Any idea'
Thanks~|||> Any idea'
Yes, install SP3a?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Installed...but still cannot view table design....
oh!!! how come!!!
it is very hard to create table by using sql statement...change table field
type by sql statement
add/delete/update field info by sql statement...
oh!!!|||> it is very hard to create table by using sql statement...change table
field
> type by sql statement
Have you looked at CREATE TABLE and ALTER TABLE in Books Online?
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Of course
I mean that it is too trouble to using code to create table or alter table
structure,...
hehe~