forsqlserver (4/9/2012)

---

I have a transactional replication.Now apps team wants 1 column need to be added in one published table.

So How should I Stop/Start the replication.

Should I stop the sql server...

It has some reason that log file grows to that size.

If I were you, I would like to know why the log file grows that big, and then take action...

if you can get rid of cursor, it would be better. (Seems the logic is not complicated in the cursor.)

Looks like you used "Be made using the login's current security context".

For that, you need to create a SPN on AD.

The SQL service on your local PC does not...

Do not need the table variable.

Just use two output parameters. And, you are done.;-)

sqlzealot-81 (3/29/2012)

---

It would fetch all the values who has either of 0,1 or NULL. Why do you want to achieve here. Why cant you have the ColumnB = the value...

Question 11 .No of Employees Joined in each year, output of this query should be “Year”, “No Of Employees Joined”

select year(dateadd(M,-3,JoinDate)),COUNT(*) as [No of Employees Joined],eid

...

Question 7. What is the Average Salary of employees in “Arts” Department?

select AVG(salarypermonth) from

...

NO. For express edition, only replication comes with it.

The management studio is not with it. You have to install separately. :ermm:

Try this:

SELECTLAST_NAME,

FIRST_NAME,

[ADDRESS] = (SELECT STUFF((SELECT ' ' + ADDRESS_LINES

FROM yourTable

WHERE ID = a.ID

ORDER BY POS

FOR XML PATH('')

...

I am thinking DNS issue....

I don't recommend to use this

Paul Randal has an article for Replication as HA:

http://www.sqlskills.com/BLOGS/PAUL/category/Replication.aspx

SP3 = 10.0.5500