Changing a Column datatype

Hello I am having a table
table1
col1 (bit)
and i want to changethe col1 type for smallint
col1 (smallint)
true will be = 1
and false = 0
how can i do it ??
thank youJust change it using Enterprise Manager. The existing values will be implicitly converted.|||i must change it from a script
but i found it

thank you|||Change it in Enterprise Manager, and then click the icon that scripts your change.

Change Settings on an EM SQL Group Member

Using EM, I have a server group which includes 6 entries. I want to change
the settings on one of the entries (I want it to require a login each time I
access a DB). I don't see a way to do this. I even thought that I would just
delete that entry and recreate it but I cannot find a way to do that either?
How can I accomplish this?
Wayne
Right-click the SQL Server, "Edit Server Registration".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
news:uBhIcptQFHA.248@.TK2MSFTNGP15.phx.gbl...
> Using EM, I have a server group which includes 6 entries. I want to change
> the settings on one of the entries (I want it to require a login each time I
> access a DB). I don't see a way to do this. I even thought that I would just
> delete that entry and recreate it but I cannot find a way to do that either?
> How can I accomplish this?
> Wayne
>
|||When I right click a server I see an hour glass cursor for about 15 seconds
and then - nothing?
Wayne
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23U1vkqyQFHA.2356@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> Right-click the SQL Server, "Edit Server Registration".
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
> news:uBhIcptQFHA.248@.TK2MSFTNGP15.phx.gbl...
change[vbcol=seagreen]
time I[vbcol=seagreen]
just[vbcol=seagreen]
either?
>
|||Strange, I've never seen this. No error message, like "cannot fins server", or "cannot log in"?
Perhaps some DLL conflict with EM? Could be worth (re) applying SQL Server service pack (unless you
find something specific about this in KB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Wayne Wengert" <wayneDONTWANTSPAM@.wengert.com> wrote in message
news:%23yDf%238zQFHA.1476@.TK2MSFTNGP09.phx.gbl...
> When I right click a server I see an hour glass cursor for about 15 seconds
> and then - nothing?
> Wayne
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:%23U1vkqyQFHA.2356@.TK2MSFTNGP14.phx.gbl...
> change
> time I
> just
> either?
>