Viewing 15 posts - 6,046 through 6,060 (of 18,926 total)
No offense but have you checked :
That you are inserting in the correct table (server, db, schema...)
Checked the inner join to make sure they don't double the keys somehow??
Do...
May 17, 2011 at 6:24 am
The first thing I'd test it to access ANY table or object on that linked server. That will tell you if there's a problem with connection or db access....
May 17, 2011 at 5:48 am
Why are those the only 2 options?
Why can't we have fun getting done what needs to be done and go home after that? No need for long NOR hard.
May 17, 2011 at 5:46 am
I don't think you need to do anything. If the table exists in the db and the linked server gives you access to the db you should be all...
May 17, 2011 at 5:44 am
I'd just like to point out that you posted in a 2005 forum and you said you are using sql 2008 to upgrade to R2. (I'm pretty it makes...
May 17, 2011 at 5:38 am
Assuming you have the image datatype and that you have enough space in the db / drives, it should be as simple as insert into or update... like any other...
May 17, 2011 at 5:34 am
Please don't cross-post. It fragments replies and it just takes longer to solve the problem.
No more replies here plz. Post answers on this thread :
http://www.sqlservercentral.com/Forums/Topic1109987-5-1.aspx
May 17, 2011 at 5:33 am
Grant Fritchey (5/17/2011)
buferis12 (5/17/2011)
ahh thats bad 🙁 SO reverse engineering wouldn't help too? Btw, yeah there is things called stored procedures in that db.
There you go. You can't possibly know...
May 17, 2011 at 5:27 am
The way I'd personanlly do this is the send that parameter in the query that fills the dataset. So in theory you return only 50% of the data everytime.
Then...
May 17, 2011 at 5:25 am
It might be as stupid as a new db with an invalid character like ":" so that you can't output that name on the drive or you have "weird" characters...
May 17, 2011 at 5:23 am
At this point you basically have to do what you got to do to get the site working... from there on out maybe someone can reenter some data, most likely...
May 17, 2011 at 5:20 am
Digs (5/16/2011)
Thanks, I have a better idea, hire some one to help me, when and if my DB gets that large..:-)
You know where to find us me ! 🙂
May 16, 2011 at 2:54 pm
I don't have a server to test but you should be able to set the object id in a variable and use it there.
May 16, 2011 at 2:22 pm
4u.chethan (5/16/2011)
the server we merge into single one is stayed as instance in that?
We're having a lot of difficulties understanding your questions. Maybe it would be easier for you...
May 16, 2011 at 2:20 pm
Viewing 15 posts - 6,046 through 6,060 (of 18,926 total)