Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I am badly stuck up with this problem! I am running Microsoft SQL Server 2008 R2 and Business Intelligence Development Studio. …
sql sql-server sql-server-2008-r2 analysisJacob asked the perfect question: give me the MERGE syntax. Every answer out there immediately jumps to the most complicated …
sql-server merge sql-server-2008-r2 upsertIs there a way I can add the time in the following query as the body of my email : EXEC …
sql-server tsql sql-server-2008-r2 sp-send-dbmail dbmailI would like to keep a task in an SSIS package but enable/disable it when i please. Is there …
ssis sql-server-2008-r2 bidsIs it possible to script All of the Log Shipping configuration? For example: I need to write a job that …
sql-server scripting sql-server-2008-r2 log-shippingWhile trying to access databases, logins, etc in SQL Server Management Studio 2008 R2, below error is always popping up. I …
sql-server sql-server-2008-r2 database-engineAssuming that I have the following T-SQL code: SELECT * FROM Foo f INNER JOIN Bar b ON b.BarId = f.…
sql sql-server tsql sql-server-2008-r2 inner-joinHow do you rewrite expressions containing the standard IS DISTINCT FROM and IS NOT DISTINCT FROM operators in SQL implementations …
sql sql-server tsql sql-server-2008-r2 ansi-sqlLast night I had a database that had it's data and log files physically removed without first taking the proper …
database sql-server-2008-r2 database-restore repairI have posted something similar before, but I am approaching this from a different direction now so I opened a …
sql sql-server-2008-r2 common-table-expression