Viewing 15 posts - 5,401 through 5,415 (of 9,722 total)
chandan_jha18 (8/1/2011)
We are not adding any table to an existing one. Tables are different and the import will be creating new tables from scratch.
My bad. I thought you were merging...
August 1, 2011 at 11:54 am
chandan_jha18 (8/1/2011)
Is this the correct way and matches the answers in your mind while you replied here:-)
Yes. That is the correct way.
Something to be aware of, though. If two tables...
August 1, 2011 at 8:44 am
You have two options at this point. Call Microsoft (recommended) or create a work around.
The work around method is dirty and you will probably forget something (hence the reason I...
August 1, 2011 at 5:39 am
Have them put a sniffer on the network regarding those specific machines.
August 1, 2011 at 5:34 am
chandan_jha18 (7/29/2011)
chandan_jha18 (7/29/2011)
Brandie Tarvin (7/29/2011)
August 1, 2011 at 5:33 am
Thanks for posting the solution. It's always good to know what works and what doesn't.
August 1, 2011 at 5:30 am
bopeavy (7/29/2011)
Revenant (7/29/2011)
Ray K (7/29/2011)
--------------------------------------------------------------------------------
Daniel Bowlin (7/29/2011)
--------------------------------------------------------------------------------
Clouds
Computing
Power
Out of Space
Lost in Space
August 1, 2011 at 5:29 am
GilaMonster (7/31/2011)
Anyone willing to read over an article on recovery models and make sure I haven't made any grievous errors?
Send it my direction, Gail. I'll take a look at it.
August 1, 2011 at 5:28 am
antonio.safwat (7/29/2011)
July 29, 2011 at 11:48 am
chandan_jha18 (7/29/2011)
Brandie Tarvin (7/29/2011)
July 29, 2011 at 11:39 am
What is your data source? MySQL? SQL Server? DB2? Oracle?
What is your data destination? MySQL? SQL Server? DB2? Oracle?
EDIT: Are you querying MS Access? What is "nia"? A linked server...
July 29, 2011 at 10:29 am
Have you set the Delay Validation property of your connection manager to True?
July 29, 2011 at 7:52 am
I don't remember, honestly. Have you googled network card names? Do you have a local network admin you can speak to?
You might get better results with that method.
July 29, 2011 at 7:50 am
dekuwisdom (7/29/2011)
this is what i tried executingSELECT *
FROM nia.nia_records r
INNER JOIN nia.nia_districts d
ON LEFT(r.CenterNo,CHARINDEX('-',r.CenterNo,0)-1) = d.district_Code;
and i got this error message
Error Code: 1305. FUNCTION CHARINDEX does not exist
Have you tried...
July 29, 2011 at 7:42 am
The best way to do it is script the tables, indexes, etc. over to your destination server. Then use the Export Import Wizard to append the data to the existing...
July 29, 2011 at 7:37 am
Viewing 15 posts - 5,401 through 5,415 (of 9,722 total)