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.
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.
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.
Any questions or discussions around using backup/restore, DBCC, recovering from hardware issues, planning disaster recovery or high-availability strategies.
General Setup discussions, Upgrade Advisor, Best Practices Analyzer.
SQL Server SMO/DMO Any questions on SQL Server Management Objects (SMO) or Distributed Management Objects (DMO).
SQL Server Tools General Any questions and discussions related specifically to SQL Server tools. For discussions on features exposed through tools, please post to the directly-related forum.
TSQL challenges? This is the place for advice / 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.
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 ...
其他
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...
其他
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...
其他
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...
其他
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...
其他
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....
其他
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...
其他
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 ...
其他
Microsoft æ£å±•é–‹ä¸€ä»½ç·šä¸Šå•å·èª¿æŸ¥ï¼Œäº†è§£æ‚¨å°æ–¼ç¶²ç«™çš„看法。如果您é¸æ“‡åƒåŠ ，您離開網站時å³æœƒé¡¯ç¤ºç·šä¸Šå•å·èª¿æŸ¥ã€‚
