Ah, you need the RKTool kit found here http://www.microsoft.com/en-us/download/details.aspx?id=17657

Lynn Pettis (9/20/2012)

---

Just an aside, you can also setup RoboCopy to act as a service and automatically move the files to another location when the backup has completed. I...

jcrawf02 (9/20/2012)

---

Morose (I've just been informed that not only was it Talk Like A Pirate Day yesterday, but if you dressed like a pirate,...

You can't mark a topic as resolved on here.

Another option would be to enable xp_cmdshell and run the DOS command directly in the job step.

Number of options really

Write a bat file which uses Robocopy / XCopy (or another DOS copy command) to do the copies, add that in as an extra step in the...

Is there any more information in the output window? The error is to vague to give you a solution.

http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4 - memory management

Check the executionlog view in the reportserver database and check the processing and rendering time, if these are huge and tie in with the delay in the subscription starting and...

Sort on the unformatted date instead of the formatted date, something like the below

SELECT

CONVERT(VARCHAR,DateColumn,103) AS FormattedDate,

DateColumn AS Non-FormattedDate

FROM

SomeTable

ORDER BY

DateColumn DESC

DECLARE @Table TABLE (Client_id int, id int, value int)

INSERT INTO @Table VALUES

(10, 1, 1),

(20, 1, 1),

(30, 1, 1),

(40, 1, 2),

(10, 2, 1),

(20, 2, 2),

(30, 2, 3),

(40, 2, 3),

(10, 3, 2),

(20,...

If the source is Non-Unicode and the destination is Unicode it is best to stick a data conversion task in to convert the data from Non-Uni to Uni (or vice-versa)...

yes my original solution will still work, my solution will return ID's 2,3,4,5 as duplicates.

Hi, welcome to SSC, if you would take a moment to read the second link in my signature block on posting questions it would help you get an answer quicker,...

Have you tried to use a data conversion task instead of just changing the column types?

What is the reasoning behind exporting the data to csv then importing it again?

Essentially the method is the same as the export just reversed, so you would have a connection...