Forums

Forums

Ask questions, share information and learn about SQL Server 2005 with others. There are many developers, architects and testers already working with SQL Server; join with them to share and learn. There are also SQL Server 2008 forums available.

SQL Server Forums

  • Getting Started with SQL Server

    New to SQL Server? Beginners just getting started - here's the place for help with simple questions. For installation or setup questions, refer to the Setup Forum.

  • .NET Framework Inside SQL Server
    Need help with writing CLR code targeting SQL Server 2005? This forum is a great place to have your questions answered and hear about others’ experiences.
  • Database Mirroring

    General questions relating to the Database Mirroring feature, including client failover.

  • SQL Server Analysis Services
    Discussions relating to MDX and other Analysis Services or OLAP questions.
  • SQL Server Compact Edition

    SQL Server Compact and Mobile Edition technical discussions.

  • SQL Server Data Access
    Native data access to SQL Server using SQL Native Client, OLEDB, ODBC or SOAP/HTTP. For .NET related questions, see the Data Access forum in the .NET group.
  • SQL Server Data Mining
    All questions and discussions related to data-mining in SQL Server.
  • SQL Server Database Engine

    Any questions or discussions relating to the SQL Server Database Engine, performance, features, Full-text Search, linked servers, etc.

  • SQL Server Disaster Recovery and Availability

    Any questions or discussions around using backup/restore, DBCC, recovering from hardware issues, planning disaster recovery or high-availability strategies. (MSDN forum)

  • SQL Server Documentation
    Books Online and all other documentation-related discussions.

Recent SQL Server Forum Posts

For a flavor of what you can expect to find in the forums, we're showing posts from a samping of the various forums below.

This Forum Has Moved! Visit the New Forums Platform Today!
Microsoft has created a new forums platform (MSDN, TechNet, Expression, and Microsoft) with increased performance, stability, and an improved user experience. The forum you previously accessed has been moved to this new platform. To help you with this move, weÆve created a Sandbox forum, where you... more

    SQL Server 2008 Reporting Services Custom Form Authentication Sample not working
      I am trying to get custom authentication to work,because the default is simply not applicable to our environment,and have tried two ways, but am stopped by errors out of my control: 1. I got the Anonymous authentication in James Wu's blog to work, and have been trying to use that as a starting poi... more

      help needed for the issue related to concurrency and deadlock
      hi. in our banking application required highly data concurrency and data security We executed following two commands ROW VERSIONING-BASED ISOLATION LEVEL 1) ALTER DATABASE ACUTE SET READ_COMMITTED_SNAPSHOT ON;2) ALTER DATABASE ACUTE SET ALLOW_SNAPSHOT_ISOLATION ON;but still we face the deadlock... more

        Trouble with programatically setting output column property for lookup
        Hi!   The code snippet below fails on the last line where I try to hook the "bleh" column to a column returned from the lookup. Error:   Message="Exception from HRESULT: 0xC0202021"  Source="Microsoft.SqlServer.DTSPipelineWrap"  ErrorCode=-1071636447   Any ideas?     MetaLu = importer.ComponentMeta... more

          SQL Server 2008 bug with outer join and index
          Hello! We found a problem when migrating from SQL Server 2005 to SQL Server 2008. SQL-statements like   SELECT ., ., . FROM JOIN ON . = . LEFT JOIN ON . = . WHERE (. = 2 AND . = 'some_text' OR . = 2 AND . = 'some_text')   give d... more

            Query help needed
            I have this query and when i am tyring to run it, says Must declare the variable '@prm_location_id'.   Can you help .. its a query in a proc.. and the proc when executed says the same thing   Can you correct it ?     select        h.order_no,      h.taker,      h.date_created as order_date,      i.... more

              ABC Classification - SET and Calculated member using TopPercent
                I have 3 Dimensions DA, DB, DC, a measure called QTY and a time frame that includes multiple years.   I like to create an ABC classification that allows me to tag all combinations of DA.DB (so the Qty for DA in DB) as within top 80%, top 15% or top 5%. Also Qty should only be summed up over the l... more

                This Forum Has Moved! Visit the New Forums Platform Today!
                Microsoft has created a new forums platform (MSDN, TechNet, Expression, and Microsoft) with increased performance, stability, and an improved user experience. The forum you previously accessed has been moved to this new platform. To help you with this move, weÆve created a Sandbox forum, where you... more
                  Page view tracker