Top "Sql-server-2008-r2" questions

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

Receiving SQLException "Login failed for user" connecting to SQL Server 2008

I am trying to connect to SQL Server 2008 via Java. I've added sqljdbc4.jar to my project's library. No username …

java sql-server-2008-r2 connection-string sqlexception
Set Tablix row height to a specific number in SQL Server Report Builder 3.0?

I'm trying to set the row height of the detail row to a specific value, like 0.5 in. If I click …

reporting-services sql-server-2008-r2 bids ssrs-tablix reportbuilder3.0
How to determine which SSAS Cube is processing now?

There is a problem when several users can process the same cube simultaniously and as a result processing of cube …

sql-server-2008-r2 ssas olap
How to implement Socket.IO with ASP.Net, IISNode, Node.JS, and SQL Server for event-based push notifications?

For a notification project, would like to push event notifications out. These are things like login, change in profile, etc., …

node.js sql-server-2008-r2 asp.net-4.0 socket.io iisnode
SSIS how to convert string (DT_STR) to money (DT_CY) when source has more than 2 decimals

I have a source flat file with values such as 24.209991, but they need to load to SQL Server as type …

ssis sql-server-2008-r2 data-conversion money-format
In SQL Server 2008 R2 script data missing on Script Wizard

In my SQL Server 2008 R2 Script Option Screen of Script Wizard under section Table/View Options Look I find Script …

sql-server sql-server-2008-r2
Search XML with a LIKE or similar full search operation

I want to search an XML valued column to see if a contains a string. I don't know the schema, …

sql xml xpath sql-server-2008-r2
I am unable to use THROW SQL Server 2008 R2

SQL Server 2008 R2 Management Studio does not recognized my throw in the below example, it says incorrect syntax near Throw …

sql sql-server sql-server-2008-r2 try-catch throw
OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE

I use SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio. I create one project of Business Intelligence Project …

sql sql-server sql-server-2008-r2 ssas olap
Does SQL Server CACHES Query Results?

When I run a query does the SQL Server caches the results? Because: When I run the below query: SELECT …

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