Bind message to a constraint check

I'm doing a migration form Sybase to Microsoft Sql Server 2005. On my sybase
datbase, I have some check constrainst. Thos contraints are linked (sybase
procedure sp_bindmsg) with specific messages in case that those constraint
are not followed.
Idon't know and don't find something equivalent on Sql Server.
Thanks for your help!You cannot bind a user defined message to system errors (like of you want to add a row to a
referencing table if a value doesn't exists in the referenced table).
Consider requesting the feature to sqlwish@.microsoft.com.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"valerie uzan" <valerieu@.srl.co.il> wrote in message
news:ed0ffe6febd048e98407c892029b9413@.ureader.com...
> I'm doing a migration form Sybase to Microsoft Sql Server 2005. On my sybase
> datbase, I have some check constrainst. Thos contraints are linked (sybase
> procedure sp_bindmsg) with specific messages in case that those constraint
> are not followed.
> Idon't know and don't find something equivalent on Sql Server.
> Thanks for your help!

Bind message to a constraint check

I'm doing a migration form Sybase to Microsoft Sql Server 2005. On my sybase
datbase, I have some check constrainst. Thos contraints are linked (sybase
procedure sp_bindmsg) with specific messages in case that those constraint
are not followed.
Idon't know and don't find something equivalent on Sql Server.
Thanks for your help!
You cannot bind a user defined message to system errors (like of you want to add a row to a
referencing table if a value doesn't exists in the referenced table).
Consider requesting the feature to sqlwish@.microsoft.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"valerie uzan" <valerieu@.srl.co.il> wrote in message
news:ed0ffe6febd048e98407c892029b9413@.ureader.com. ..
> I'm doing a migration form Sybase to Microsoft Sql Server 2005. On my sybase
> datbase, I have some check constrainst. Thos contraints are linked (sybase
> procedure sp_bindmsg) with specific messages in case that those constraint
> are not followed.
> Idon't know and don't find something equivalent on Sql Server.
> Thanks for your help!

Bind message to a constraint check

I'm doing a migration form Sybase to Microsoft Sql Server 2005. On my sybase
datbase, I have some check constrainst. Thos contraints are linked (sybase
procedure sp_bindmsg) with specific messages in case that those constraint
are not followed.
Idon't know and don't find something equivalent on Sql Server.
Thanks for your help!You cannot bind a user defined message to system errors (like of you want to
add a row to a
referencing table if a value doesn't exists in the referenced table).
Consider requesting the feature to sqlwish@.microsoft.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"valerie uzan" <valerieu@.srl.co.il> wrote in message
news:ed0ffe6febd048e98407c892029b9413@.ur
eader.com...
> I'm doing a migration form Sybase to Microsoft Sql Server 2005. On my syba
se
> datbase, I have some check constrainst. Thos contraints are linked (sybase
> procedure sp_bindmsg) with specific messages in case that those constraint
> are not followed.
> Idon't know and don't find something equivalent on Sql Server.
> Thanks for your help!sql

Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
Steve
Does Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>

Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
SteveDoes Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>

Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
Steve
Does Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>

Bidirectionnal replication between SQL 2000 and Sybase ASE

Hello,
For political reasons, I need to havec datas stored both on a SQL Server
2000 and a Sybase ASE v12.
If data changes in SQL, it must be replicated to the Sybase server, and if
data changes in Sybase, it must be propagated to the SQL Server.
Do you know how can I reach my goal in a simple manner ?
Thanks,
SteveDoes Sybase replicate to heterogeneous data sources (like SQL Server) using
stored procs? If so:
The best way to do this is to add a column to the tables you are replicating
called ServerName, or something like this. Then assign this column a default
of @.@.servername (I believe this option is available in Sybase).
Then modify update and delete the procs to do their work if the value of
servename being passed in the proc variable is not equal to the value in the
underlying column.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Steve B." <steve_beauge@.com.msn.Swap.dotcom.and.msn> wrote in message
news:41fa438e$0$2068$626a14ce@.news.free.fr...
> Hello,
> For political reasons, I need to havec datas stored both on a SQL Server
> 2000 and a Sybase ASE v12.
> If data changes in SQL, it must be replicated to the Sybase server, and if
> data changes in Sybase, it must be propagated to the SQL Server.
> Do you know how can I reach my goal in a simple manner ?
> Thanks,
> Steve
>