Viewing 15 posts - 676 through 690 (of 5,678 total)
So, I don't feel that I'm doing one of our posters justice on a topic he's posted. I've gotten a very polite blow off. Not looking for a...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 3:55 pm
Ness (5/13/2013)
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 3:02 pm
Kerberos Double Hop error. Pain in the arse the first time you run into it because the keywords don't make sense, but that's what you've got.
Google up those...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 2:29 pm
If you can, RDC to the server and crack open the package in BIDS, see what it thinks the metadata changes are supposed to be. Could be something as...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 13, 2013 at 2:27 pm
drew.georgopulos (5/9/2013)
omg i feel like such a dunce...I apologize for bringing such a kluncker to the list and thank you profusely for catching it for me.
Don't sweat it. Most...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 6:57 pm
It's not required except for certain pieces at this time, such as ending the previous statement before starting a WITH component.
However, it does no harm and is 'proper' coding, even...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 6:41 pm
Miles, I used to do a similar process but using linked tables it avoided them keeping local data that needed to be merged later. Made my life so much...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 6:25 pm
Yeah, either modify that to be one of the logins from the other systems that are working, or check that user's permissions against the target system. My guess is...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 6:09 pm
j2cagle (5/9/2013)
Yes that helps...but I'm trying to resolve this without touching the VB code.
then we need to see the target proc and a sample call.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 4:55 pm
You have to RDC to the box, rt-click computer, manage, and check the services. Rt-click services and in properties for it you'll be able to see the login for...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 4:25 pm
Lynn Pettis (5/9/2013)
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
Because you have the table alias in the wrong place:
select t.cbclaim from [dev].[stage].[dbo].[claimsview]...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 3:38 pm
belowery (5/9/2013)
There has to be something on the UAT that is not set up correctly or it could be the issue with low space.
Does your UAT SQL Agent Login and/or...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 3:37 pm
I'm not sure why or how it would be doing that, but I just wanted to drop you a line. You'll probably get more effecient help going to a...
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 3:34 pm
drew.georgopulos (5/9/2013)
make this crash?select cbclaim from [dev].[stage].[dbo].[claimsview] with(noexpand) t
it works fine without the t?
thanks a lot
What's the exact error? Can you copy/paste it from SSMS please?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 3:32 pm
What user is running the IS Service on that box?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
May 9, 2013 at 2:25 pm
Viewing 15 posts - 676 through 690 (of 5,678 total)