Remove default value from a table

Hi there.
I cannot figure this out, please help.
I have a table with an attribute with a default value. How do I erase this default value (with sql). I do not want to lose any data in my table.I didn't get that to work, it said I should use ALTER TABLE DROP CONSTRAINT. I have tried that before but without success.

But after a few minutes (almost an hour) I found a way to solve it:

ALTER TABLE voucher DROP CONSTRAINT DF__voucher__voucher__56D3D912;

The Constraint name I found by looking in the sysobjects table.

Thanks anyway!|||just do an alter table ... alter column ... and omit the default.

Remote Server issue...

Did you ever figure this out ? I have the same problem.
I think you have to delete all subscribers and then delete the remote
server. Then create a linked server and then add back the subscribers.
Becuase, the sp_serveroption for data access will not work with a
remote server
Brett wrote:

quote:

---

> *I am attmepting to setup up a linked server from my
> production server (sql1) to my reporting server (sql2).
> I have replication from sql1 to sql2.
> I noticed that there is already a remote server setup on
> sql1 for sql2. It will not allow me to setup a linked
> server for sql2. Plus, I am unable to run a distributed
> query... I get the error message that the remote server
> is not configured from data access.
> How do I setup a linked server from sql1 to sql2 so that
> I have data access?
> Please advise..
> Thank you,
> Brett
> I am using SQL Server 2000 for my production and
> reporting servers. *

---

dannr09
---
Posted via http://www.mcse.ms
---
View this thread: http://www.mcse.ms/message110773.htmlIf you're using SQL Replication, we setup Remote Servers as opposed to
Linked Servers already. What functionality are you trying to acheive?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.