20 марта 2006 г. 23:05Модератор
Hello everyone and welcome to the SQL Express forum. One of the primary goals of the SQL Express MSDN Forum is to offer a gathering place for SQL Express users to share experiences, discuss issues related to SQL Express, ask questions and interact with the folks here at Microsoft. Hopefully everyone on the forum will contribute not only questions, but opinions and answers as well. I’m looking forward to seeing an active community of experts grow up around SQL Express.
This post has information to help you understand what questions to post here, and where to post questions about other technologies as well as some tips to help you find answers to your questions more quickly and how to ask a good question. See you in the group.
SQL Express team
Be a good citizen of the Forum
When an answer resolves your problem, mark the thread as Answered. This makes it easier for others to find the solution to this problem when they search for it later. If you find a post particularly helpful, click the link indicating that it was helpful
It seems obvious, but this forum is for discussion and question of the SQL Express family of products. When you want to discuss something that is specific to SQL Express, this is the place to be. An example of something that is specific to SQL Express is User Instances. Since SQL Express uses the same database components as other SQL Editions, there are several common pieces of functionality and there may be better forums elsewhere to ask about those. Don’t worry, this is a great place to start if you’re using SQL Express, if there is a better batch of experts to answer your question, we’ll just move your post to that Forum so those experts can answer. Any alerts you set up will move with the post, so you’ll still get notification. Here are a few of the other forums that you might find interesting:
SQL Server Setup & Upgrade – This is where to ask all your setup and upgrade related questions, even for SQL Express. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=95&SiteID=1)
SQL Server Tools General – This is the best place to ask Management Studio Express questions. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1)
SQL Server Reporting Services – If you’re working with RS in Express Advanced, check out this forum. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)
SQL Server Database Engine – Great forum for general information about engine issues such as performance, FTS, etc. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=93&SiteID=1)
SQL Server Data Access – If you’re connecting to SQL through almost any protocol this is a SQL forum dedicated to you. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1) There is also a .NET Data Access forum that covers similar topics, but with a VS focus. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=45&SiteID=1)
There are also some general forum categories that will interested you:
Visual Studio Express Editions (http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=35&SiteID=1)
Visual Web Developer and ASP.net (http://forums.asp.net/)
.NET Development (http://forums.microsoft.com/MSDN/default.aspx?ForumGroupID=12&SiteID=1)
There is a wealth of information already available to help you answer your questions. Finding an answer via a few quick searches is much quicker than posting a question and waiting for an answer. Here are some great places to start your research:
SQL Server 2005 Books Online:
Microsoft Support Knowledge Base:
Search it online at http://support.microsoft.com
Search the SQL Express Team Blog:
The blog is located at http://blogs.msdn.com/sqlexpress
Search the MSDN Forums:
Search other SQL Forums and Web Sites:
MSN Search: http://search.msn.com/
Or use your favorite search engine
Make sure to give all the pertinent information that people will need to answer your question. Questions like “I’m having problems using SQL Express with C#, any ideas?” will likely go unanswered, or at best just result in a request for more information. Here are some ideas of what to include:
· The exact error message if you’re getting an error. (The SQL Error Logs can be a rich source of information. See the section on error logs below.)
· Any tools you’re using when experiencing the problem. (Management Studio, VS Express product, etc.)
· Any troubleshooting you’ve already done. (eg. “I’ve tried connecting to SQL Express with SQLCmd and that fails with the same error.”)
· If you’re having a coding problem, include a sample of the code that cuases the problem. Make sure to identify the line where the problem occurs if you can.
· Connection strings you’re using when you’re having connection problems.
· Is everything installed on the same computer or are you working across a network?
Finding the Error Logs
You will often find more information about an error by looking in the Error logs. There are two sets of logs that are interesting:
Setup Error Log default location: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG
SQL Error Log default location: C:\Program Files\Microsoft SQL Server\MSSQL.#\MSSQL\LOG (Note: The # changes depending on the ID number for the installed Instance. This is 1 for the first installation of SQL Server, but if you have mulitple instances, you will need to determine the ID number your working with. See the BOL for more information about Instance ID numbers.)