Forum Replies Created

Viewing 15 posts - 5,386 through 5,400 (of 9,707 total)

  • RE: SQL timeouts and disconnects?

    Have them put a sniffer on the network regarding those specific machines.

  • RE: Export Import Wizard

    chandan_jha18 (7/29/2011)


    chandan_jha18 (7/29/2011)


    Brandie Tarvin (7/29/2011)


    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...

  • RE: XML help

    Thanks for posting the solution. It's always good to know what works and what doesn't.

  • RE: Today's Random Word!

    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

  • RE: Are the posted questions getting worse?

    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.

  • RE: new to BI/DWH

    antonio.safwat (7/29/2011)


    So i thought that studying for SQL Server BI certificate and BI concepts (OLAP & DDB & ETL) will help to get the required knowledge for an entry level...

  • RE: Export Import Wizard

    chandan_jha18 (7/29/2011)


    Brandie Tarvin (7/29/2011)


    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...

  • RE: How to join two tables using wildcards.

    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...

  • RE: Error loading multiple files from a folder

    Have you set the Delay Validation property of your connection manager to True?

  • RE: SQL server installation issue

    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.

  • RE: How to join two tables using wildcards.

    dekuwisdom (7/29/2011)


    this is what i tried executing

    SELECT *

    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...

  • RE: Export Import Wizard

    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...

  • RE: inconsistent data of table

    Did you name the table yourself? Can you fix it? Using special characters as the first "letter" of a table name is a really bad idea. In fact, SQL Server...

  • RE: new to BI/DWH

    You can't do BI without knowing the basics of SQL Server administration and development. You don't have to know everything, but knowing the basics is essential.

    I would start training with...

  • RE: Which book to study

    OP, can you please provide the link to the discussion you said you would start in the certification forums so others can respond there?

Viewing 15 posts - 5,386 through 5,400 (of 9,707 total)