Viewing 15 posts - 8,611 through 8,625 (of 9,725 total)
YOu can use a "Select Into" to maintain your identity in the new table, but it won't retain PK / Relationship stuff. Suresh is correct. The best way to handle...
October 30, 2008 at 3:08 am
Submitted & waiting for approval. @=)
Though if I see you again at SQL Saturday, I'll tell you in person. @=)
October 25, 2008 at 3:24 am
Jeff may disagree with me on this, but here's my take on interviews.
Know your stuff, but if you can't answer the question, be honest about it. Tell the interviewer that...
October 24, 2008 at 3:48 am
Did you actually install SQL on the new box as part of a cluster or a standalone server? This is one of the options upon install. If you didn't...
October 21, 2008 at 8:14 am
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
Viewing 15 posts - 8,611 through 8,625 (of 9,725 total)