Viewing 15 posts - 1 through 15 (of 5,678 total)
A few questions.
The table in question in all these databases, is it the EXACT SAME schema? If not, you're going to have issues regardless.
Next, can you connect 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
January 26, 2015 at 12:38 pm
ramana3327 (12/15/2014)
Here my concern is if I gave public server role and dbo owner for some databases, they can't see job history or they can't create maintenance plans
Well, either you're...
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
December 15, 2014 at 2:36 pm
RETURN (
SELECT CASE
WHEN @optional_letter = ' ' AND EXISTS(SELECT 1 FROM dbo.Test WHERE letter = @letter AND...
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
December 11, 2014 at 4:31 pm
@Brandie: The Business Case for this (and others like it) are BOM lists to make sure you don't 'double tap' an item in the hierarchy. Doing it at...
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
December 11, 2014 at 3:52 pm
You do that by putting said database on a different server with different security.
SA can change anything, including their own security rights. You can explicitly deny, then can revoke...
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
December 11, 2014 at 2:16 pm
ZZartin (12/5/2014)
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
December 5, 2014 at 4:35 pm
ZZartin (12/5/2014)
Alexander Suprun (12/5/2014)
Eric M Russell (12/5/2014)
Jeff Moden (12/5/2014)
Ed Wagner (12/5/2014)
Eric M Russell (12/5/2014)
The input should be properly parsed and formatted prior to inserting the database table. Really, allowing users...
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
December 5, 2014 at 3:59 pm
Sounds like either users, or trolls, are trying to avoid a third party service that connects them.
You don't do this at the SQL level. The Regex is too weak...
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
December 5, 2014 at 2:30 pm
pharmkittie (12/4/2014)
Also, are there any drawbacks to putting all 9o0 in the same package?
Definately. It's called Production Failures. 😉
If one of those flat files fouls up, you don't have...
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
December 5, 2014 at 1:56 pm
Under most circumstances User Initiated Job events or SSIS package firings are bad ideas. The reasoning behind this is that it has very little collision detection. It's quite...
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
December 5, 2014 at 1:51 pm
I know it's not the direct answer to your question, but there's an implication here that concerns me.
You want people able to create tables (DDL_Admin), modify tables, etc... but not...
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
December 5, 2014 at 1:47 pm
Thanks Happycat. I'll take a look.
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
December 4, 2014 at 11:08 am
GilaMonster (12/4/2014)
Alex Jordan (12/3/2014)
I figured it out. Apparently I can order sub-queries as long as I provide a alias.
Nothing to do with the ORDER. Derived tables always need an alias.
Edit,...
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
December 4, 2014 at 11:07 am
No, you can order subqueries as long as you're looking for a TOP statement. My apologies, I read that as TOP 100%. My bad.
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
December 3, 2014 at 6:32 pm
That's more likely an issue with the data than with the code.
Shouldn't be getting an error from SSC for posting code, I do it constantly.
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
December 3, 2014 at 6:30 pm
Viewing 15 posts - 1 through 15 (of 5,678 total)