Attempting to connect from Java 6 console app to Microsoft SQL Server 2008 R2 on an Microsoft Windows Server 2008 R2 64bit system via an ODBC System DSN using SQL Server Native Client 10.0. The follow
I want to create indexed view MyView with such t-sql Select o.Theme_ID as Theme_ID, DATEADD(day, DATEDIFF(day, 0, o.Object_CreationDate), 0) as Objext_CreationDate,
I have a very odd performance issue with an SSIS package in Sql Server 2008 R2. Here the facts: Recently we migrated from a Sql Server 2005 (on Windows Server 2003 R2 32bit) to Sql Server 2008 R2 (on
I\'m trying to get SQL Server Report Manager to work. I\'m on windows 7, 64 bit, installed SQL Server Developer with everything included. Every service for MSSQLSERVER is running, IIS is running.
We have transactional replication between two MS SQL Server 2008 R2. Our servers were rebooted because of failure of a hard drive.
When I try to deploy the Adventure Works DW 2008 cube, I get the following error开发者_运维知识库:
What would cause a server side trace to disappear before I call exec sp_trace_setstatus @TraceID, 2? On a local database, I\'m using SQL profiler to export a server side trace definition.
I hope someone can shed some light on the SPLA methodology which allows you to get SQL Server 2008 R2 for ~$25/month if I understand correctly.
I want to un-install completely SQL Server 2008 R2 from my 64bit system. When I tried to install, I experienced a common problem about \"INSTALLSHAREDWOWDIR\" but I managed to install anyway. Now, I c
I have a query like this: Select Count(*) as TotalCount, Object2_ID, Object_ID, Object_Description from Table1
加载中,请稍侯......