Thanks for the reply, I assume that its only SQL x86 that suffers from this limitation ?

thats a good point actually, i was just wondering whether there is a quicker way to do this programatically.

Good point

Just then when you have loads of commas, the time & efford that it will take to write dynamic SQL, one could actually manually install it on all the...

Thats very right.

What I have found is that if functions are not created in the right order, they can break replication. As articles are sent down to subscribers in the wrong order,...

Thanks for the reply.

The plan is as follows, run a script that will order all objects according to dependency orderings, based on this in the form of a cursor. Run...

I meant objects created out of order, the problem is more apparent when you deploy large sets of scripts and one procedure fails because it was created first before the...

Thanks for the reply, what I have is just a database which the collation settings requires changing, because the table functions needs to be recompiled in order to reflect the...

Thanks Guys,

Still dont understand the table variable approach, the cursor approach would just involve loading the select query into a cursor variable right ?

Steve Jones - Editor (7/28/2009)

---

From BOL http://msdn.microsoft.com/en-us/library/ms151797.aspx

--Which objects in the database are published?

select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published

from sys.tables where is_published = 1 or is_merge_published =...

Thanks.

Do you...

Chandu (7/28/2009)

---

Did you disable replication or removed...

its a sql 2k database, so no sys schema

Thanks for the info

below is the script I'm using

declare @fromCollation sysname,

@toCollation sysname

set @fromCollation = 'SQL_Latin1_General_CP1_CS_AS'

set...

Thanks for the reply, I cannot see any begin tran in the code above, or is it not needed.

Secondly, is there a workaround for transaction handling if the table does...