Forum Replies Created

Viewing 15 posts - 271 through 285 (of 286 total)

  • RE: SSIS & Excel Manipulation

    anuragingle (2/12/2009)


    Hi, I need some help in developing a SSIS package.

    Basicly the package will have do the following things.

    1. Check if excel file with specific name exists at specified location.

    2....

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    Perry Whittle (2/4/2009)


    SQL_Quest (2/4/2009)

    Hi

    we currently have 9.1 and 9.2 side by side as we are migrating data. ArcGIS 9.2 is now a fully incorporated system and combines ArcIMS and ArcSDE...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    Mark (1/16/2009)


    Hi SQL_Quest,

    If only it were that simple... ESRI GIS software tends to be quite specialised and requires SQL to be configured in a certain way. Have you checked...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: Unable to shrink datafile

    RSingh (1/31/2009)


    Hi,

    We have a 500 GB database.

    We deleted 75% of old data and then rebuilt most of the indexes.

    As a result of all this we had enough free space in...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL Server 2005 association

    Hi,

    In SSMS, rt click server properties -> security -> server authentication -> sql server and windows authentication mode.

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: List of Logins

    Hi,

    this may help you : http://www.mssqltips.com/tip.asp?tip=1657

    \\K 🙂

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    joao.rolo.sa (1/27/2009)


    Check this Maybe will Help!

    http://www.scribd.com/doc/7289948/ArcSDE-Config-GD-SQLServer

    Cheers!

    Thanks .. I will look into it ..

    Thanks again 🙂

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    joao.rolo.sa (1/27/2009)


    Hello,

    Im Almost certain, that you need to use ArcSDE to make Sql / Oracle talk to ArcGIS Server.

    Meaning SDE is some cloud Between the DBMS and Sql Server

    Cheers

    Hi,

    Thanks for...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    Perry Whittle (1/26/2009)


    we're not using SQL 2008 but SQL2005. Have you checked the ESRI website for details of ArcGIS 9.2 and SQL2008

    hi Perry Whittle,

    can you explain for SQL 2005 how...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    Mark (1/16/2009)


    Hi SQL_Quest,

    If only it were that simple... ESRI GIS software tends to be quite specialised and requires SQL to be configured in a certain way. Have you checked...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    Hi,

    I will be using SQL 2008 enterprise edition. and presently we are using 9.2 version of ArcGIS.

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: SQL 2005 and GIS server

    Hi SSC-Enthusiastic

    I am told to install SQL enterprise edition and after that the SQL server and the ArcGIS server should talk to each other. So that means that SQL server...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: Difference between Log shipping and DB mirroring

    Hi,

    This will answer to all your questions :

    http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx

    scroll all the way down to know the difference between

    1. Database Mirroring and Log Shipping

    2. Database Mirroring and Transactional Replication

    3. Database Mirroring...

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: Database mail

    hi,

    Sql server surface configuration ---> surface area configuration for features --->select Database mail ---> enable database mail store procedures

    This will enable database mail.

    Enjoy u r Christmas Holidays 🙂

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • RE: How to correct an attached database that has NO log file

    Hi,

    This might help out

    http://msdn.microsoft.com/en-us/library/ms174385.aspx

    http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1702647&SiteID=1

    thnks

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

Viewing 15 posts - 271 through 285 (of 286 total)