select @van_id + replace(convert(varchar(11), @nextdel, 113), ' ' ,'') datekey from replicationLock

The above line is returning data to the client, which is causing the error

Do

SELECT @count = COUNT(@van_id + replace(convert(varchar(11),...

1 time transfer or continuous transfer?

1 time, use import export data wizard, SSIS, BCP etc

continuous I would look at replication

Ed Wagner (2/18/2013)

---

Personally, I like collecting this type of data all in one place. It allows me to run reports on a single table instead of having to hit...

Yes a SQL Agent alert for that

http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

query the logshipping tables in msdb

Duplicate post, replies here please http://www.sqlservercentral.com/Forums/Topic1421182-2799-1.aspx

also from that could also be

account password expired

account now disabled in AD

account been deleted...

You might be best asking that in a dedicated FoxPro forum not a Microsoft SQL Server forum.

Someone who knows FoxPro may stumble across the post and help, but I am...

Then something isnt right in the config.

Attach a screen shot

Ensure DB is set to full recovery.

Click enable this primary check box,

Click backup settings

Give it a network path

Give it a local path

Give it the right time frame and schedules etc

Click...

someone or something stopped them - automatic process, fatal error, c2 auditing caused shutdown

server rebooted, service not set to automatic

Use the executionlog view in the SSRS database.

Failing that ask your mail admins to see if any bottle necks are occuring on the mail servers which could lead to slow...

Run the upgrade advisor, see if it shows any depreciated features or things which work in 2005 which dont work in 2012 like old style joins etc.

Then you really should...

Yes please provide the email address you have used to register with Prometric so we can send it over to Microsofts Exam Fraud board and have your certifications removed and...

You have 2 routes, inplace or side by side.

Safest is side by side.

2 ways of side by side,

1. a new box with a new install of sql, restore the...