Forum Replies Created

Viewing 15 posts - 31 through 45 (of 228 total)

  • RE: SQL Server 2005 In-Place Upgrade Versions

    Josh,

    I was researching the different methods of upgrading to SQL Server 2005. The question I ended up writing (poorly, much to my embarrassment) came from the "SQL Server 2005...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: SQL Server 2005 In-Place Upgrade Versions

    Derek,

    Thanks for the feedback. Great reminder about referencing the release notes.

    Regards,

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Reporting services FAQ

    Google Search: SQL Server Reporting Services FAQ

    ... resulted in ...

    Reporting Services: Frequently Asked Questions

    http://www.microsoft.com/sql/technologies/reporting/faq.mspx

    Enjoy!

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Which class to take

    Charlie,

    For the Certification process for SQL Server 2005, your first step to pass one exam to get you the MCTS: SQL Server 2005.

    --

    For Classroom training, you will need 2 courses:

    Course...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Importing from .xls Spreadsheet

    souLTower,

    Couple of questions:

    1) What kind of processing does 'app' do to the XLS data.

    2) How does 'app' connect to the database? I am assuming that you reference the XLS data...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Creating Link Server between MS SQL Server and ASE (Sybase)

    Abhishek,

    Please keep us posted if you do or do not find a solution. Hopefully you can get a working set of drivers so that you can access your data...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Equivalent of 'DECODE' in sql

    Kiran,

    You were very close to getting your code to run. The line "END CASE" should just be "END". I wrote a test case demonstration, based on...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: SQL Server 2005 In-Place Upgrade Versions

    Sorry about the confusing wording everyone. I will get future questions proofed more before submission.

    :blush:

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: HTML in SQL Mail

    davidw,

    I appreciate you posting the code for writing out an email in HTML; however, The beginning of the line of code

    AS NVARCHAR(MAX) ) +

    got interpreted as a "winkie face" emoticon!...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Linked Server to DB2 Mainframe

    Well then, my "magic" touch seems to have manifested again!

    Good to hear that you have the access you are expecting. It is also good to know that you have...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Linked Server to DB2 Mainframe

    jfauden

    Just to make sure ... Does the user specified in the linked server has access to SYSIBM?

    Check from the DB2 side... Can the user specified in the linked server access...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Email Reminder Software

    Norene,

    I am going to second Steve's recommendation of using Group Calendar's in Outlook. If you configure a shared Calendar for each Project you should be able to manage meetings,...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: SELECT Statement Question

    Roberta,

    Welcome to the SSC Community!

    As you can see from the deluge of responses, a lot of folk are more than willing to work with people like you that...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: SQL Express with Excel

    This Microsoft Knowledge Base Article will give an overview of your options for working with Excel and SQL Server.

    How to import data from Excel to SQL Server

    http://support.microsoft.com/kb/321686

    --

    You will need to...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

  • RE: Creating Link Server between MS SQL Server and ASE (Sybase)

    Your Linked Server configuration seems to be configured correctly.

    There is a similar error when using SQL Server to an Oracle datasource at:

    BUG: Out of Memory Error Message Occurs...

    "Key"
    MCITP: DBA, MCSE, MCTS: SQL 2005, OCP

Viewing 15 posts - 31 through 45 (of 228 total)