Skip to main content
Valutazione: 

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


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.

SQL Server Katmai Setup and Upgrade

SQL Server Katmai Setup and Upgrade
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 ... altro

SQL Server Reporting Services

SQL Server Reporting Services
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 point... altro

Getting started with SQL Server

Getting started with SQL Server
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... altro

SQL Server Integration Services

SQL Server Integration Services
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... altro

SQL Server Database Engine

SQL Server Database Engine
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... altro

Transact-SQL

Transact-SQL
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.... altro

SQL Server Analysis Services

SQL Server Analysis Services
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 las... altro

SQL Server Setup and Upgrade

SQL Server Setup and Upgrade
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 ... altro

Community Resources

Microsoft sta conducendo un sondaggio in linea per comprendere l'opinione degli utenti in merito al sito Web di. Se si sceglie di partecipare, quando si lascia il sito Web di verrà visualizzato il sondaggio in linea.

Si desidera partecipare?