Viewing 15 posts - 3,976 through 3,990 (of 5,685 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...
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...
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...
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.
February 17, 2011 at 10:39 am
Anna_SQL (2/17/2011)
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...
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...
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...
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...
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...
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....
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.
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....
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.
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...
February 16, 2011 at 4:34 pm
Viewing 15 posts - 3,976 through 3,990 (of 5,685 total)