i had a similar issue and only way i could do it was to drop the column being replicated from replication, do schema change then reapply it to replication. Not...

but, running a repair / rebuild will take roughly 10mins as opposed to an hour to restore from previous nights backup and all the transaction logs.....and what if the previous...

It may be that i'm running it on 2005 but i thought the script was built for sql 2005....?

The first issue is the fact that there are end statements without...

spScriptJobs does not seem to work. The proc produces the file but if you try to run the file produced there are a stack of syntax errors......anyone else with this...

do these files exist on the machine ur trying to run the function on:

RICHTEXT.SRG

RICHTX32.DEP

RICHTX32.oca

??

is the text you're passing in more than 4000 characters?

TECH NOTE 2: The CLR trigger routine relies on a field naming convention to extract the target table name because the "TableName" fields (i.e. DataTable.TableName in the code) of the...

the quickest fix is to install VB onto the server if possible, this will create the relevant keys required, hence why it worked on my machine but not the sql...

found this:

http://support.microsoft.com/kb/325492

You may receive this error message when you try to retrieve an OUTPUT parameter or return value that is less than 4001 characters to a Transact-SQL parameter of type...

OK, found the problem. I'm not sure if its due to our server not having VB installed or not but our server was missing a few files (compared to my...

Already registered it again (from the download link given) but still no luck. The only difference i can tell between what i've done on my machine and on the server...

Definitely must be a Win2003 permissions issue. I've just tried it on my machine (win2000) running sql 2005 express and it works fine.

Looking into it now and will report back...

well i've checked the registry and tried both RICHTEXT.RichtextCtrl and RICHTEXT.RichtextCtrl.1 but still getting NULL for the object.

The server is running on Win2003 and Sql2005, could it be a permissions...

i've thrown a bit of error handling in (after 1st sp_OASetProperty) and this is the output:

ObjectID: NULL - looks like this is the problem!

hr: 0x80042727

Source: ODSOLE Extended Procedure

Description: sp_OASetProperty usage:...

i've even tried something simple like:

select dbo.RTF2TXT('{123456}')

and still getting nulls.

@Lowell:

I'm not using fnParseRTF because it doesn't strip out every bit of rtf and i need to strip everything.