Top "Sql-server-2008-r2" questions

Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.

ALTER INDEX failed because of QUOTED_IDENTIFIER when running from sp_msForEachTable

When I try to rebuild an index on a table: ALTER INDEX ALL ON [dbo].[Allocations] REBUILD that works fine. …

sql-server sql-server-2008-r2 reindex sp-msforeachtable
Update Query with Nolock hint

I am trying to put an with(NOLOCK) on an update query: UPDATE pth_patchLookup with(nolock) SET ScanDateTime = Getdate() …

sql sql-server-2008-r2 nolock
SQL Server xp_delete_file parameters

Who can explain list of xp_Delete_file parameters in sql server. I don't find msdn document for this stored …

sql-server sql-server-2008-r2 sql-server-2012 sql-server-2014
Fastest way to find string by substring in SQL?

I have huge table with 2 columns: Id and Title. Id is bigint and I'm free to choose type of Title …

sql sql-server full-text-search query-optimization sql-server-2008-r2
Entity Framework Not Creating Database

Been playing around with the Code First feature of Entity Framework 4.1 using an ASP.NET MVC 3 project. However the database (…

visual-studio-2010 entity-framework asp.net-mvc-3 ef-code-first sql-server-2008-r2
Upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise

When I tried upgrading from SQL Server 2008 R2 Express to SQL Server 2008 R2 Enterprise, it passed all tests and then …

sql-server windows sql-server-2008-r2 upgrade sql-server-2008r2-express
Query AD Group Membership Recursively Through SQL

Background I'm creating some SQL to assist with security auditing; this will take security info from various systems databases and …

tsql active-directory sql-server-2008-r2 adsi ldap-query
Change encoding (collation?) of SQL Server 2008 R2 to UTF-8

We'd like to move our Confluence system to a SQL Server 2008 R2. Now, since Confluence uses UTF-8 encoding, I'd need …

utf-8 sql-server-2008-r2 collation ucs2
The Messenger service has not been started - NetSend notifications will not be sent

In my SQL Server agent, I did not set any notifications, then why this error is coming? I run pakg …

sql-server sql-server-2008-r2 sql-server-agent
Unique key vs. unique index on SQL Server 2008

I have a table called countries and I define the country_name column to be unique by creating a “Index/…

sql sql-server sql-server-2008 tsql sql-server-2008-r2