Use this tag for questions specific to the 2008 R2 version of Microsoft's SQL Server.
I'm trying to remove white spaces from a string in SQL but LTRIM and RTRIM functions don't seem to work? …
sql sql-server tsql sql-server-2008-r2I have a computer which was used by another employee. SQL Server 2008 R2 was installed but I don't know the …
sql sql-server-2008-r2I'm trying to write the following in order to get a running total of distinct NumUsers, like so: NumUsers = COUNT(…
sql sql-server tsql sql-server-2008-r2 sql-server-2014My SQL code is fairly simple. I'm trying to select some data from a database like this: SELECT * FROM DBTable …
sql sql-server sql-server-2008-r2I'm getting the error below when I try and access SSRS on SQL Server 2008 R2 I'm not sure how many …
sql-server-2008 ssrs-2008 sql-server-2008-r2How can we find which table is locked in the database? Please, suggest.
sql-server sql-server-2008 sql-server-2005 sql-server-2012 sql-server-2008-r2I am using this query to rename the database: ALTER DATABASE BOSEVIKRAM MODIFY NAME = [BOSEVIKRAM_Deleted] But it shows an …
sql sql-server sql-server-2008-r2I've been working on this for about a day and a half now, and searched numberous blogs and help articles …
sql stored-procedures sql-server-2008-r2 server-errorI am working with SQL Server 2008 R2. I am unable to connect to my database remotely. I got the following …
sql-server sql-server-2008 sql-server-2008-r2We have a few huge databases (20GB+) which mostly contain static lookup data. Because our application executes joins against tables …
sql sql-server sql-server-2008 sql-server-2005 sql-server-2008-r2