when you ran the ddl scripts on the publisher did they get created in the correct Schema?

That's the one thing I can think of.

~Craig

SQL Server rounded down to 100...

I have a C# program that uses SMO to script out objects into individual files.

I call that program with a batch file and then use SVN to commit...

I have one question about the WRITETEXT.. I've never used that - but would that require me to copy all data except for the NTEXT field to the dest table...

2 words:

Slow Disk.

disk i/o is almost always the bottleneck in a database.

Your system could use a little more RAM, too. that would help. Reducing demand is...

I don't have a solid answer for you, but I do know that your ntext data is stored off-row and SQL server uses a pointer to find it. those...

CT should have an identity, right?

otherwise we'd have to make up a number and insert it.

If I understand your example you'd join P1, P2, and P3 in the from clause...

Are you using Microsoft clustering or a third party like Veritas (VCS) ?

~BOT

Lynn wins!

here's the synthesis that skips the scalar function.

--

--

SELECT

p.number,

cast((SELECT '' + cast(case when p.number & POWER(2,v.number) = 0 then '0' else '1' end as char(1))

...

Jonathan,

Brilliant! Thanks.

I like the power and bitmask method of conversion.

That beats the modulus and division method (I think).

I should have specified that I wanted to use a tally table...

Correct, Lynn.

I'm looking to have an integer input column and varchar output like below

150 -> 10010110

255 -> 11111111

Surrogate keys are still the devil.

The problems they prevent pale in comparison to the problems they cause.

That being said, this is far and away the best solution if you...

If I understand your question you want to know how to join a table on 2 columns?

let's do an example:

table1

column a

column b

table2

column a

column c

delete table1

from table1 t1 inner join...

unless I'm missing something, you do not need to use an iteration to delete your target rows.

simply use a join in the FROM clause in your delete statement.

there are good...

Try the DAC first.

http://msdn.microsoft.com/en-us/library/ms189595%28SQL.90%29.aspx

~sqlbot