Forum Replies Created

Viewing 15 posts - 631 through 645 (of 789 total)

  • RE: Export database into Excel

    As I can see from your info that your DB is 1 GB maybe some table has over 65 000 records in one sheet and the Excel 2003 doesn't support...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Monitoring Changes in Your Database Using DDL Triggers

    Nice one ... I like it, is very simple!

    😉

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Script copy a table

    ...or you can use Import/Export Data wizards ... if you want to working by clicking!

    if you have any problem ...we are here!

    Dugi

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Script copy a table

    yes and very easy:

    SELECT * INTO DESTINATION_DATABASE.DBO.TABLE

    FROM SOURCE_DATABASE.DBO.TABLE;

    GO

    DESTINATION_DATABASE is your database where you want to put the table and you data of that table!

    SOURCE_DATABASE is your database where are the...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Incremental backup

    GilaMonster (9/29/2008)


    ananda.murugesan (9/29/2008)


    hi sqldba,

    pls tell me, what is the different between incremental backup and differential backup in sql server 200?

    SQL doesn't have an incremental backup. It has a full backup,...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Incremental backup

    Close this topic the first one is here

    http://www.sqlservercentral.com/Forums/Topic577625-146-1.aspx

    :w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Incremental backup

    ....hahaha SQL Server 200 never exist (little joke) anyway...

    there is the link with lot of information that you can find about backup and restore!

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

    Hope it helps you!

    Dugi

    :w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t::w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Problem with ranking

    O man, O man ...no comment!

    :w00t::w00t::w00t::w00t::w00t::w00t::w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: The FILESTREAM Data Type in SQL Server 2008

    samarjit2k1 (9/24/2008)


    Can the FILESTREAM data type be used in SQL Server 2005?

    No just in SQL 2008

    😛

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: unstallation

    Hmmm wrong section for asking ...you should post in this forum "SQL Server 2005 General Discussion" inside SSC!

    Backup your databases first then go and install service pack 2 of SQL...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: The FILESTREAM Data Type in SQL Server 2008

    Nice information about FILESTREAM!

    😎

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Error: [Microsoft][ODBC SQL Server Driver]][Tcp/IP]

    Are you working localy or in network with EM ...?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Problem with ranking

    Thnx Jeff I appreciate that deal ....also I found the solution with Tally table but it would be better if you post the alternative solutions with tally table!

    I started to...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Checking values row by row

    AHA...at the end the results I have the missing ID's ...now is correct !

    sorry I didn't check the end of the results couz I thought that they will publish as...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • RE: Checking values row by row

    ok there is my results you can see them in attach :

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

Viewing 15 posts - 631 through 645 (of 789 total)