Viewing 15 posts - 3,976 through 3,990 (of 5,678 total)
CONSTRAINT [PK_SUN_Vendors] PRIMARY KEY CLUSTERED
(
[SUN_DB] ASC,
ASC)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
Here's the reason you're not able to insert dupes. So, you'll need to find any dupes...
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
February 17, 2011 at 10:55 am
That's strange then. When you login to the foreign box, using that user, and connect to the database that you're trying to pull data from... does it give you...
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
February 17, 2011 at 10:48 am
Can you post the ddl and some sample data that would provide us the background for what you're looking to generate:
qry_id_2combo hic_number
qry_1&2 123456789A
qry_1&2 987654321A
qry_1&3 456789123B
We're guessing as to what the...
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
February 17, 2011 at 10:44 am
You could disable the publications, perform those tasks, re-establish the snapshot, and then re-enable the publications.
Similar I guess to the drop/rebuild, but a little less painful.
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
February 17, 2011 at 10:39 am
Anna_SQL (2/17/2011)
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
February 17, 2011 at 10:37 am
Krasavita (2/17/2011)
Login failed for user 'SUN_Link_Srv'
Why is that? My linked server is regestered under this name 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
February 17, 2011 at 10:32 am
Krasavita, you're going to be a lot more explicit in your problem for specific assistance.
Basically you'll have to dedupe your data into table 2 from table 1 to get it...
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
February 17, 2011 at 10:26 am
That's odd.
"C_achieve" "DT_STR" "0" "0" "100" "1252" "0" "" "OLE DB Source"
That's a VARCHAR(100) in the stream. Well, you could tell it to just redirect failure rows, send the...
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
February 17, 2011 at 9:45 am
As OPC mentioned above, you'd still be using a trigger to feed Service Broker. All Service Broker would do is delay the update to the other table, and tighten...
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
February 17, 2011 at 9:32 am
thepotplants (2/16/2011)
Booking 19159 would become 4 rows.
'19159','6' 'Dec 29 2009 08:00','Dec 29 2009 23:59:59'
'19159','6' 'Dec 30...
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
February 16, 2011 at 10:32 pm
Jeff Moden (2/16/2011)
Fal (2/16/2011)
Brandie Tarvin (2/16/2011)
... But I'd avoid dark alleys, if I were you....
Well, there goes the joy in life.
But wait, you mentioned something about "tar and feathers"??
Steve.
Mmmmmm....
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
February 16, 2011 at 10:12 pm
adam spencer (2/16/2011)
Craig,Thank you very,very much for that explanation. That helped clear it up!
Adam
My pleasure, glad I could help.
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
February 16, 2011 at 10:08 pm
Ray Cacciatore (2/16/2011)
Yes, it is an ADP file that is connected to SQL 2005.So, I'm understanding that even when a SELECT executes, the record gets locked?
Yes, depending on isolation levels....
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
February 16, 2011 at 10:03 pm
Have two unique tasks and use a script component to evaluate the variable. Enable/disable tasks as necessary per pass in the script.
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
February 16, 2011 at 5:45 pm
and we haven't gotten to 8/2/2011 yet (I read it as 2010 for some reason) so yes, it's after an hour ago... LOL
Check out this script, it should show you...
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
February 16, 2011 at 4:34 pm
Viewing 15 posts - 3,976 through 3,990 (of 5,678 total)