Viewing 15 posts - 8,611 through 8,625 (of 9,720 total)
Have you checked the firewalls? Have you tried changing ports on your connection to the ports allowed for SQL Server?
October 21, 2008 at 8:10 am
I assume the packages are stored in MSDB on your server - have you run a checkdb on MSDB? The error looks like it is indicating a problem getting...
October 20, 2008 at 7:47 am
Interestingly enough, it doesn't get granular on column permissions. Or rather, it does, but it doesn't properly reflect them.
I have a SQL Login which has been granted Select permissions on...
October 16, 2008 at 11:45 am
Jack, you're a genius! And yes, as soon as I'm done fiddling and fixing to my satisfaction, I'll definitely post it to the library. @=)
Thanks!
October 16, 2008 at 6:37 am
BTW, here's the header on the SSRS XML Extract:
<?xml version="1.0"?>
<Report xmlns="AHSRPT908Reinsure"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="AHSRPT908Reinsure http://reportserver?%
2fAHSRPT908Reinsure&rs%3aFormat=XML&rc%
3aSchema=True" Name="AHSRPT908Reinsure">
And I've hit hard carriage returns on the end of each line so it...
October 14, 2008 at 6:34 am
We can't see the contents of your file. Attach it to your thread as a text file please.
October 14, 2008 at 5:46 am
I'm not quite sure I understand the question.
Are you saying you want to save SQL Database backups to a different location? Or that you want to pull non-SQL Database...
October 13, 2008 at 5:43 am
Oh, yes. I've been on the interviewer side of the table myself. It makes me appreciate that I was smart enough to build myself a SOHO and actually work things...
October 10, 2008 at 5:31 am
Maybe for you it is, but some of us didn't have paid professional IT experience when coming into this field and others have to work for employers who require the...
October 9, 2008 at 4:12 am
Far away from the point??? What do you mean?
October 9, 2008 at 4:07 am
Yeah, that sounds sooo familiar. Glad I'm not the only one with that problem. @=)
The main database I oversee was so not meant for the use people are putting it...
October 2, 2008 at 3:43 am
Just curious... How is performance (read/write) on those insane indexes of yours, Jeff?
October 1, 2008 at 5:21 am
You can shrink manually, but it's not recommended. And if you're having to shrink the log files often, you don't have enough disk space and/or you have really terrible queries...
September 30, 2008 at 7:35 am
Look in BOL for "OpenXML" (use the Index feature). This will give you a lot more information than just a post.
SQL Server requires you to prep a "memory space"...
September 30, 2008 at 7:13 am
Viewing 15 posts - 8,611 through 8,625 (of 9,720 total)