SQL Server

SQL Server 2008 - Trouble exploring databases node with newly created user. Grant new user rights for each of the databases with no rights http://connect.microsoft.com/SQLServer/feedback/details/424329/the-server-principal-testuser-is-not-able-to-access-the-database-msdb-under-the-current-security-context https://www.orcsweb.com/blog/desiree/the-server-principal-a-is-not-able-to-access-the-database-b-under-the-current-security-context-microsoft-sql-server-error-916/ http://blogs.msdn.com/b/euanga/archive/2006/05/04/585513.aspx

How to identify your SQL Server version and edition? SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') http://support.microsoft.com/kb/321185

How To: Reset Identity column in SQL Server DBCC CHECKIDENT('Customer', RESEED, 0) http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx

List All the Tables for All Databases sp_msforeachdb 'select "?" AS db, * from [?].sys.tables' http://blog.sqlauthority.com/2009/04/26/sql-server-list-all-the-tables-for-all-databases-using-system-tables/

SQL Documentation BI Documenter - http://msdn.microsoft.com/en-us/magazine/ee335714.aspx SQL Doc - http://www.simple-talk.com/sql/sql-tools/database-documentation-using-sql-doc/ Code project - http://www.codeproject.com/KB/database/sqldoc.aspx

Error: Saving changes not permitted Menu >> Tools >> Options >> Designers >> Uncheck “Prevent Saving changes that require table re-creation http://sqlserverpedia.com/blog/sql-server-bloggers/sql-server-–-fix-management-studio-error-saving-changes-in-not-permitted-the-changes-you-have-made-require-the-following-tables-to-be-dropped-and-re-created-you-have-either-made-changes/

SQL Server Performace

Tip of the Day #5 (SQL Server memory usage) http://blog.colinmackay.net/archive/2008/07/20/2996.aspx

SQL Server queries with DMVs for examining bottlenecks *** http://searchsqlserver.techtarget.com/tutorial/SQL-Server-queries-with-DMVs-for-examining-bottlenecks

Using COALESCE to Build Comma-Delimited String

http://www.sqlteam.com/article/using-coalesce-to-build-comma-delimited-string

Download details: Microsoft® SQL Server® 2008 Express with Advanced Services http://www.microsoft.com/downloads/en/details.aspx?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

SqlMag article: SQL Server 2008 Express Editions http://www.sqlmag.com/article/sql-server-2005-express/sql-server-2008-express-editions.aspx