Alter Table Alter Column

I need to Alter the multiple column of an Existing table
ALter TABLE Address
Alter Coumn Address1 varchar(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
Address2 varchar(250)COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
Address3 varchar(250)COLLATE SQL_Latin1_General_CP1_CI_AS NULL
But this gives me an error
please advice me on this
thanks
samayYou have to have a separate ALTER TABLE statement for each ALTER COLUMN I'm
afraid.
--
David Portas
SQL Server MVP
--

Allow SQL Only to be used on IP Address 127.0.0.1

Hello,
I have a webserver with SQL and only want it accessable via the 127.0.0.1 IP
address. How do I do this.
Thanks,
Jack
You could use a firewall:
http://www.kerio.com/kpf_home.html
blocking all connections incoming from addresses different from 127.0.0.1
Henri
"jack" <jack@.mrolinux.com> a crit dans le message de
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>
>
|||"Henri" <hmfireball@.hotmail.com> wrote in message
news:OtdQ$daUEHA.3016@.tk2msftngp13.phx.gbl...
> You could use a firewall:
> http://www.kerio.com/kpf_home.html
> blocking all connections incoming from addresses different from 127.0.0.1
> Henri
You don't need a third party product to do this.
Just go to network connections, and the properties of the ip interface and
set up ip filtering on that ip address.
David
|||Open the SQL Server Network Utility on the webserver
(Start>Run>svrnetcn.exe) , highlight the enabled protocols and click the
disable button. Now the server will only accept local connections. You need
to specify the server as servername or (local) or . rather than the IP
address but the effect is that only local connections are allowed.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jack" <jack@.mrolinux.com> wrote in message
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>

Allow SQL Only to be used on IP Address 127.0.0.1

Hello,
I have a webserver with SQL and only want it accessable via the 127.0.0.1 IP
address. How do I do this.
Thanks,
JackYou could use a firewall:
http://www.kerio.com/kpf_home.html
blocking all connections incoming from addresses different from 127.0.0.1
Henri
"jack" <jack@.mrolinux.com> a écrit dans le message de
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>
>|||"Henri" <hmfireball@.hotmail.com> wrote in message
news:OtdQ$daUEHA.3016@.tk2msftngp13.phx.gbl...
> You could use a firewall:
> http://www.kerio.com/kpf_home.html
> blocking all connections incoming from addresses different from 127.0.0.1
> Henri
You don't need a third party product to do this.
Just go to network connections, and the properties of the ip interface and
set up ip filtering on that ip address.
David|||Open the SQL Server Network Utility on the webserver
(Start>Run>svrnetcn.exe) , highlight the enabled protocols and click the
disable button. Now the server will only accept local connections. You need
to specify the server as servername or (local) or . rather than the IP
address but the effect is that only local connections are allowed.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jack" <jack@.mrolinux.com> wrote in message
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>

Allow SQL Only to be used on IP Address 127.0.0.1

Hello,
I have a webserver with SQL and only want it accessable via the 127.0.0.1 IP
address. How do I do this.
Thanks,
JackYou could use a firewall:
http://www.kerio.com/kpf_home.html
blocking all connections incoming from addresses different from 127.0.0.1
Henri
"jack" <jack@.mrolinux.com> a crit dans le message de
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>
>|||"Henri" <hmfireball@.hotmail.com> wrote in message
news:OtdQ$daUEHA.3016@.tk2msftngp13.phx.gbl...
> You could use a firewall:
> http://www.kerio.com/kpf_home.html
> blocking all connections incoming from addresses different from 127.0.0.1
> Henri
You don't need a third party product to do this.
Just go to network connections, and the properties of the ip interface and
set up ip filtering on that ip address.
David|||Open the SQL Server Network Utility on the webserver
(Start>Run>svrnetcn.exe) , highlight the enabled protocols and click the
disable button. Now the server will only accept local connections. You need
to specify the server as servername or (local) or . rather than the IP
address but the effect is that only local connections are allowed.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jack" <jack@.mrolinux.com> wrote in message
news:%2379%23H%23ZUEHA.644@.tk2msftngp13.phx.gbl...
> Hello,
> I have a webserver with SQL and only want it accessable via the 127.0.0.1
IP
> address. How do I do this.
> Thanks,
> Jack
>