You will need Enterprise edition for data driven subscriptions, and you need to have the correct permissions.

Brandie Tarvin (10/30/2015)

---

Anyone here with mad C# skills? I need some help with a VS 2012 C# project that I'm updating.

Nevermind. One of our developers finally responded to my request...

A thought I had may work. It may be more intrusive than you would like, however.

You have identified the indexes/tables that are affected by this, correct?

Whenever you...

You need to develop a data driven subscription.

This article should get you started.

https://msdn.microsoft.com/en-us/library/ms169673.aspx

Keep in mind that you are not going to edit the job, or the data in the underlying tables.

You will need to go into the correct report, and modify the...

It's going to do that. I honestly do not know the real answer, but this is my take. I have seen this behavior before.

Replication is not "smart"...

SELECT SUBSTRING('AB120315111111', 5, 4)

Is this to a local drive?

I would probably check with my hardware person to see what can be done to increase the transfer rate. If it's not,...

What does Query Analyzer provide that SQL Management Studio does not?

There are many third party tools available, Toad is one of the more popular ones.

And, I'm not sure...

sandeepraichura (10/26/2015)

---

I'm running SQL 2012 on a Win 2012 VM and the SQL server shuts down automatically after starting the SQL Server & SQL Server Agent Jobs.

Did anyone came across...

I suspect the XML. See if removing that column from the insert succeeds. if that's it, convert it to nvarchar(max), and then back to XML.

You can do...

Ed Wagner (10/27/2015)

---

Luis Cazares (10/27/2015)

---

Yeah, me either. I hope the next one is closer to Michigan....

drew.allen (10/23/2015)

---

You're trying to call a UDF DATEPART defined under the tblCall schema. Unless you've defined your own DATEPART function under this schema, I suspect what you want is...

I'm not asking you to hard-code the year.

I asking you to query the table and see if any records exist in the table that match the criteria. ...

Run this code and see if anything comes back:

SELECT DATEPART(yyyy,Call_Date) AS ArchiverYear

FROM tblCall

WHERE Call_Date <= '01/01/1900'

If not, there are no records in the table with a call date...