I don't know if I wasn't clear before but, the problem is only connection not if I typed the Server name in myself or if the Server which I am...

The name of the Server is the Default Server, so I did not have to type in anything.

SQLKnowItAll (7/19/2012)

---

Is SQL Server Browser running? How exactly are you trying to connect (what are you typing in for server name)? Is it a default or named instance? Do...

There are some varchar(max) datatype columns and also some text datatypes but one of the table has over two hundred columns.

Thank you!

its very large around 2500000 from all tables.

Thank you for your reply!

While the Database was set to Full Recovery, I run the following script

INSERT INTO NewTable

(

column1,

column2

)

SELECT

column1,

column2

FROM

table1 app

INNER JOIN table2 aps...

The Updates will Occur on both...

Steve Jones - SSC Editor (5/3/2012)

---

You'll have to explain more. What do you mean by updateable with filters?

I assume filters mean that you are producing a publication that joins data...

Thank you for your reply,

I was more interested in which type of replication is best to use when the Replicated data is mainly updatable data where filtering is used...

Thank you for your reply!

No, I mean how do I write the expression inorder to...

Thank you All for all of your comments and opinions, it is much appreciated!

Thank you for all your advice!

I used COLLATE DATABASE_DEFAULT and it worked:

Table1.Column1 COLLATE DATABASE_DEFAULT = Table2.Column1 COLLATE DATABASE_DEFAULT

Thank you everyone for you advice!

Brandie Tarvin (4/12/2012)

---

Why does the replacement user need similar privledges? You're just shooting yourself in the foot.

Remember, least permissions needed to do the job (figuratively and literally) should be the...

Thank you for your reply!

This is part of the stored procedure:

........................

...................

CREATE TABLE Data

(

Total_TY decimal(10,2), --this is where is gives the error

Total_LY decimal(10,2),

variance decimal(10,2)

)

INSERT INTO #Data

SELECT

CASE WHEN ISNULL(ISNULL(Total_TY,0)/ISNULL(Total_LY,1), 0) =...

Brandie Tarvin (4/12/2012)

---

What Gail said on the above. Except, if I recall correctly, does the job run under the credentials of the person running it (if it's run manually?), or...