Viewing 15 posts - 31 through 45 (of 89 total)
Thanks, all. Turns out it was a result of applying sp3 which reset the DCOM permissions for the SQL Agent account. I set the remote access, launch and activation permissions...
February 17, 2012 at 7:22 am
The script from jnuqui should give you what you need...
January 10, 2012 at 5:12 am
The issue is that NORECOVERY leaves the database waiting for more backups. Using WITH STANDBY leaves the database in a read-only state, but ready to restore additional backups. It creates...
October 7, 2011 at 5:51 am
We do a similar process:ftp backup from host, decompres, restore in-house. There is a SSIS package which controls the process and we have stored procedures to do the restores...
October 6, 2011 at 5:14 am
July 8, 2011 at 10:04 am
Then try
Print coalesce( 'A' + ' ' + ' ' + 'B', 'A', 'B', '')
You need to use values that html will convert to CR/LF. Not sure what they are...
March 30, 2011 at 12:32 pm
CR & LF will not show in Query Analyzer (I've had to do some fancy footwork to remove CR & LF from my data), but if you print it...
March 30, 2011 at 4:56 am
I went against my better judgement and answered 2 - since I also read
http://en.wikipedia.org/wiki/Nested_RAID_levels
Oh well - Nice to know I'm not the only one - though next...
March 4, 2011 at 5:03 am
Question definitely is wrong. As others have stated - to get the "correct response" it would need to be (-1, -1)
June 28, 2010 at 4:58 am
I'm looking to setup a similar process and found this script that might be helpful for you
http://www.simple-talk.com/sql/ssis/quick-tip-performing-an-ftp-rename-in-a-ssis-script-task/
April 7, 2010 at 11:24 am
We used to get these when multiple i/o intense jobs were running at the same time. In my case, I was able to reschedule the sql job to avoid the...
March 31, 2010 at 4:45 am
I tried it on 3 different servers, and interestingly enough, my SQL 2000 returned 0,1. But with the information available, I agree that 1,1 would be the correct answer.
January 29, 2010 at 5:01 am
:alien:
from Overview of Windows Server 2003 R2 Datacenter x64 Edition
...
Multiprocessor Support - Up to 32
however - from Windows Server 2003 Datacenter Edition with SP1 for Itanium-based Systems
...
Multiprocessor Support - Up...
November 13, 2009 at 4:44 am
I've actually used the @return = xp_sendmail... in a sproc which reports errors, so it does work. However, I think the problem you're running into is that xp_sendmail is reporting...
September 25, 2009 at 9:16 am
I'm confused....
Microsoft SQL Server 2008: Standard
Facilitate server upgrades with stable and more predictable query performance. Ensure business continuity with enhanced Database Mirroring including automatic page repair and ...
April 8, 2009 at 5:02 am
Viewing 15 posts - 31 through 45 (of 89 total)