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...

create a central database and then get each SQL server to insert data into the central database

otherwise as Gail mentioned, get a 3rd party product which already has done this...

One way, and others may add their own but the way I would do it is to set a poll up on sys.dm_os_performance_counters for the TempDB space used metric (Free...

Look at the STOPAT clause of the restore command.

So restore the full backup with NORECOVERY, then restore the log with STOPAT and RECOVERY

RESTORE DATABASE ...... FROM DISK = '...............' WITH...