Viewing 15 posts - 3,751 through 3,765 (of 6,401 total)
Ah, you need the RKTool kit found here http://www.microsoft.com/en-us/download/details.aspx?id=17657
September 20, 2012 at 8:21 am
Lynn Pettis (9/20/2012)
September 20, 2012 at 8:14 am
jcrawf02 (9/20/2012)
crookj (9/19/2012)
Aarrrrg. Ye scurvy Dogs! 😉
Morose (I've just been informed that not only was it Talk Like A Pirate Day yesterday, but if you dressed like a pirate,...
September 20, 2012 at 7:58 am
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.
September 20, 2012 at 7:56 am
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...
September 20, 2012 at 7:46 am
Is there any more information in the output window? The error is to vague to give you a solution.
September 20, 2012 at 7:21 am
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/ Chapter 4 - memory management
September 20, 2012 at 6:29 am
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...
September 20, 2012 at 6:15 am
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
September 20, 2012 at 6:00 am
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,...
September 20, 2012 at 5:52 am
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)...
September 20, 2012 at 4:48 am
yes my original solution will still work, my solution will return ID's 2,3,4,5 as duplicates.
September 20, 2012 at 4:00 am
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,...
September 20, 2012 at 3:08 am
Have you tried to use a data conversion task instead of just changing the column types?
September 20, 2012 at 2:13 am
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...
September 19, 2012 at 9:16 am
Viewing 15 posts - 3,751 through 3,765 (of 6,401 total)