Ian Scarlett (9/9/2009)

---

WITH VALUES only works when you are also adding the column at the same time. Just...

ps (9/9/2009)

---

as pointed out in previous posts, you need to ensure the log reader agent is continuously bringing the transactions to the distribution database. Unless the log reader agent brings...

ALTER TABLE dbo.myTable ADD CONSTRAINT DF_myTable_Q DEFAULT(0) FOR Quota WITH VALUES

So when you write 'select convert(binary(8), 3000000001)' what data type are you expecting the constant to be?

As someone who uses C#, you should know better than to reply on implicit...

Yes but it is transactional replication - not snapshot replication.

Have changes on the source (since the snapshot was applied) been successfully applied to the subscriber(s)?

Use replication monitor to check this,...

I must remember this thread next time someone tries to sell SQL code portability to me :laugh:

I can't help that mention that putting a function on a datetime column is...

So, records which need replicating are keeping the log active.

Is replication working and up to date from this database?

(I read back to post...

The question isn't clear. What is it you want to do?

This is a duplicate of http://www.sqlservercentral.com/Forums/Topic784712-146-1.aspx

Naresh,

I am confused: you talk of storing 4 byte unsigned integers and show an example using 8-byte big integers.

Are you planning to store the unsigmed integers in a SQL Server...

So, with that in mind, the following seems to emulate the ROWNUM pseudo-column:

-- Assumes AdventureWorks sample database is available

WITH ResultSet AS

...

PaulB (9/8/2009)

---

Just to make it clear, rownum does not exist in real world, it's a pseudo-column. Think of it as the sequence number of rows returned by a query no...

TheSQLGuru (9/8/2009)

---

Actually my rates are definitely too low. In the last few months I have had not one but TWO new clients tell me they were shocked at what...

It was running for five hours inside a single transaction? Really?! I guess you have your reasons, but that sounds quite scary.

Maybe you'll never know exactly what happened...

High five.