GilaMonster (4/5/2016)

---

You cannot truncate a table that is referenced by a foreign key. It doesn't matter whether the constraint is enabled or not. If a table is referenced by a...

It depends on a number of issues. CPU, memory, Network bandwidth, etc.

Ideally it performs better on a separate server than the database server.

If you are doing simple bulk inserters how...

Thanks Grant for the info!

poste removed.

Manic Star (3/24/2016)

---

We moved most of our SSIS packages over to our BI server mainly because we are running on AG's now and it makes managing the jobs a bit...

I agree that power shell would be easier.

I have done it using DTS and SSIS using the file system object.

Search for the latest date file and rename, restore, archive and...

This post is old. 🙂

I got replies that addressed this issue.

Thanks.

Disregard I will figure it out.

Thanks.

Because I was stuck and I wanted to start over.

I cleaned up everything and recreated the DISTRIBUTER, PUBLISHER and SUBSCRIBER.

If I add the view as an article without the dependent object (table) it does not generate an error.

I was...

When creating the Publisher I execute the following command:

use [ReplicationTestDB]

exec sp_replicationdboption @dbname = N'ReplicationTestDB', @optname = N'publish', @value = N'true'

I get the following error:

Could not connect to server 'ASSET2629\DISTRIBUTOR' because...

All of the Agents were running.

I tried Dropping and recreating the subscription but that did not work.

I'm starting over by recreating distribution.

I execute the following Command from the Publisher and...

Do you have permissions to Remote Desktop into the Server?

Then try connecting to SSMS.

The run sp_who3 and identify what is going on. http://sqlserverplanet.com/dba/a-better-sp_who2-using-dmvs-sp_who3

I saw the following thread that is related to my problem.

http://www.sqlservercentral.com/Forums/Topic342644-7-2.aspx

Hmmm.:unsure:

I'm stuck on the message 'The initial snapshot for publication 'testpub is not yet available'.