Markus (1/23/2014)

---

well... if you don't have a unique index on any of the tables you cannot setup replication... also... not sure if you can replicate from SQL2008 to 2000.... probably...

Replication is data driven so unless you have some auditing you wont have much in the default trace but you may find something.

Is replication still enabled but the publications gone?...

I'm not sure I follow all of this but I'll do my best.

joackim.breien (1/23/2014)

---

the problem is when the replication is done i want to apply some permissions to the new...

You are safer adding it via TSQL. You need to run sp_addarticle and sp_addsubscription. Then you need to run the snapshot agent.

Sp_addarticle adds the table to the publication. At this...

That's the easiest way. If you were to stop the log reader it would have the same effect but...

GilaMonster (1/17/2014)

---

If the split involves moving rows from one partition to another, it's not...

You don't have to recreate the functions/schemes from scratch to change empty partitions. You can merge all of the empty partitions and use split to reassign them to the...

happycat59 (1/16/2014)

---

ALTER TABLE ... ADD COLUMN is a meta data change to a table only. It does not change what is currently stored in the table. SQL Server...

Not necessarily. You can add the...

Slightly different take on this by me.

CREATE TABLE #TEMP(Category NVARCHAR(100),Item NVARCHAR(100),Value NVARCHAR(100));

INSERT INTO #TEMP values('Small','PilotA1','AjJCC');

INSERT INTO #TEMP values('Large','PilotA1','ACC');

INSERT INTO #TEMP values('Small','PilotA2','BKC');

SELECT *

FROM

(

SELECT Item, Value, Category

FROM #TEMP

) AS s

PIVOT

(

MAX(Value) FOR...

If you are restoring the db from production, using KEEP_REPLICATION will fail as the distributor and subscribers will...

bleumer (1/8/2014)

---

Attempting to start a replication relation, however, when initializing, it gives me the following error:

2014-01-08 09:23:02.225 The schema script 'FillMercaTempTab_56.sch' could not be propagated to the subscriber.

2014-01-08 09:23:02.234 Category:NULL

Source:...

Sounds like lack of permissions. Are you using a SQL Login as sysadmin on both machines or NT user? If the SID's for the SQL Login don't match...

You can export the execution plan from the buffer cache using this dmv. You can find many examples of the queries if you google this dmv.

http://technet.microsoft.com/en-us/library/ms189747.aspx

Export the execution plan of...

My question would be why do you need to export so much data? It would make more sense to display or use it directly in a database.

2.2 million rows...