Top "Sql-server-2008-r2" questions

TSQLT unit test - The data types text and text are incompatible in the equal to operator

I am getting this error from AssertEqualsTable "The data types text and text are incompatible in the equal to operator." …

tsql tdd sql-server-2008-r2 tsqlt

Process/SPID is being blocked by itself, how to clear/kill without restarting Sql Server

We have a process that was running for 4 hours. Because it was running so long, it was causing other issues …

sql-server sql-server-2008-r2 locking spid

How do you know if a SQL table has been changed since the last time you used it?

Is there a way to know if the data in a SQL Server 2008 R2 table has changed since the last …

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

SSRS Report Manager javascript fails in non-IE browsers for Drop Down Menus

I've been debugging the ReportingServices.js file using Firefox and Firebug. I've found that the reason SSRS (SQL Server Reporting …

javascript reporting-services ssrs-2008 sql-server-2008-r2 reportmanager

How to add description to columns in Entity Framework 4.3 code first using migrations?

I'm using Entity Framework 4.3.1 code first with explicit migrations. How do I add descriptions for columns either in the entity …

c# .net sql-server-2008-r2 entity-framework-4.3

Transfer SQL job to another machine

How can I transfer my SQL Agent job (maintenance plan) from my server to another server? I use SQL Server 2008 …

sql-server-2008-r2 sql-job

What does PI in OSIsoft's 'PI System' stand for?

What does PI in OSIsoft's 'PI System' stand for? https://www.osisoft.com/resources/case_studies/case_studies.aspx I …

sql-server-2008-r2 complex-event-processing pi-db

How to update an XML column with value from T-SQL built-in function?

I have a MS SQL 2008 R2 Standard database. I have a column with varchar(250) data and a column with xml. …

sql-server xml tsql sql-server-2008-r2 xml-dml

Weird "OLE DB provider 'STREAM' for linked server '(null)' returned invalid data for column '[!BulkInsert].Value' error

Software used: Windows 7 64 bit Ultimate, .Net 4, SQL Server 2008 R2. select @@version returns: Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 …

c#-4.0 sql-server-2008-r2 sqlbulkcopy

SQL Server Backup error - not part of a multiple family media set

I am trying to backup my SQL Server 2008 R2 database. However I am getting the below error, no matter where …

sql-server sql-server-2008-r2 database-backups