Recent content by TLGsoft

Just install last version of MDAC TLGsoft "If it works, don't fix it"

In ODBC, set your connection to TCP/IP. TLGsoft "If it works, don't fix it"

BTW, even Personal Edition have replication... TLGsoft "If it works, don't fix it"

You said Decimal / Decimal. See SQLBill's post. Maybe this will help you: cast(0.01 as decimal) = 0 cast(0.01 as decimal(9,1)) = 0 cast(0.01 as decimal(9,2)) = 0.01 TLGsoft "If it works, don't fix it"

osjohnm, tell that to sp_mergesubscriptioncleanup. Always when I try to clean up my replication, it remains a lot of system tables, stored procs and views that you can't delete because they are system owned. So, I delete them directly from sysobjects, and it works.

Run this in QA: SELECT @@version if buildno is 780 then you have SP3 5xx then you have SP2 lower then you have SP1

forget about sysobjects, Jymm is right. It's a Foreign Key problem and you can edit that in table properties

use DaysBetween() from DATEUTILS unit

do a PRINT @mystr to see what are you trying to execute

sysobjects table contains the reference

First set the &quot;Allow modifications directly ...&quot; option in SQLServer properties. update sysobjects set UID = a.IDNumber from (select UID as IDNumber from sysusers where [name]='dbo') as a where UID <> a.IDNumber

use SP_EXECUTESQL()

ExtractFileName()

The problem was NULL. SQL does scalling automatically. He just could say MyRealValue = 0. Even MyStringValue = 0 (not '0')

Syntax is: MyValue IS NULL, not MyValue <> NULL