Top "Sql-server-2008-r2" questions

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

determining the character set of a table / database?

What T-SQL command can be run to find character set of a table or database in SQL Server? edit: Server …

sql-server sql-server-2008-r2 collation
Connecting to MS SQL Server with Windows Authentication using Python?

How do I connect MS SQL Server using Windows Authentication, with the pyodbc library? I can connect via MS Access …

sql-server sql-server-2008-r2 odbc windows-authentication pyodbc
LIKE query with Entity Framework

Possible Duplicate: How to do SQL Like % in Linq? Like Operator in Entity Framework? I'm doing a query like this: …

c# wpf sql-server-2008-r2 ef-code-first
How to return default value from SQL query

Is there any easy way to return single scalar or default value if query doesn't return any row? At this …

sql sql-server sql-server-2008-r2
How to enable "World Wide Services (HTTP)" in the firewall using command line?

I'm trying to share my site in the local network. I want to use command line tool to perform this …

iis iis-7 sql-server-2008-r2 windows-server-2008 firewall
is not a recognized built-in function name

Created a function CREATE FUNCTION Split_On_Upper_Case(@Temp VARCHAR(1000)) RETURNS VARCHAR(1000) AS BEGIN DECLARE @KeepValues AS VARCHAR(50) SET @…

sql sql-server sql-server-2008 sql-server-2008-r2
Sql Server replication requires the actual server name to make a connection to the server

I get the following message when I want to create a new publication or Subscription. "Sql Server replication requires the …

sql-server sql-server-2008-r2
How to run the same query on all the databases on an instance?

I have (for testing purposes) many dbs with the same schema (=same tables and columns basically) on a sql server 2008 …

sql-server sql-server-2008-r2 multiple-databases
How to prevent arithmetic overflow error when using SUM on INT column?

I am using SQL Server 2008 R2 and I have an INT column where the data inserted never surpasses the max …

sql-server-2008-r2 int sum overflow arithmeticexception
SQL Server 2008 IIF statement does not seem enabled

I am trying to use IIF() in a select statement. The boolean expression checks to see if a fields value …

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