• Error Message in SQL Server 2008 code.

    Hi, I am currently going through the Tutorials on SQL Server Management Studio 2008 R2. One of the samples instructs me to run the following code: SELECT  Mgr.EmployeeID AS MgrID, Mgr.LoginID AS Manager,  Emp.EmployeeID AS E_ID, Emp.LoginID, FROM EmployeeDemo AS Emp LEFT JOIN EmployeeDemo AS Mgr...

    JKJK45 pointsBadges:
  • session error

    Just upgraded a vendor app from sql 2005 to sql 2008 r2 sp1 and are consistently getting Error: 18056, Severity: 20, State: 29. The client was unable to reuse a session with SPID 72, which had been reset for connection pooling. I have applied all patches and stil lcan't get rid of error. User's...

    tcstl95 pointsBadges:
  • The SSIS 2008 R2 job does not complete execution

    I have an SSIS package created in 2005 SP2. I have compiled this and is sheculed to run under SQL Server 2008 R2, which connects to a SQL Server 2005 database. What the package does. 1.The package FTP's some files to the local folder. I verified to confirm the files are downloaded correctly. 2....

    Iamhere98025 pointsBadges:
  • SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?

    I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like any scenario where SSIS speaks to a clustered SQL...

    RobertDBA5 pointsBadges:
  • Frequency of witness pings to partners

    Does anyone know how often the witness instance pings the partners? I am aware of the timeout setting but want to know exactly how often the ping is initiated. Is it the same or different from the timeout value. Thanks in advance for your reply.

    BitBangerDBA5 pointsBadges:
  • International SQL Server Replication

    I have a unique challenge involving keeping 2 SQL Server Databases in synch, one of which will reside in Iraq, the other will be in a base camp in Kandahar, Afghanistan where the local clinic will use a client application that communicates to the local database. The database in Iraq will be for...

    MattPoirier15 pointsBadges:
  • Cross-database name change in SQL Server 2008 stored procedures

    Hi: The easy part is the databases will be on the same server.  However at the moment I am writing code in database SOMEDATABASE_TEST which is accessing objects in SOMEOTHERDATABASE_TEST.  When its time to go to production the names are going to change to SOMEDATABASE and SOMEOTHERDATABASE. ...

    Rusty25 pointsBadges:
  • Performance and Resource Consuming Monitors SQL Server 2008 R2

    Are there any specific GUI tools available to monitor the performance and resource consuming process? At present we are using third party tool to do so (Spot light)?

    ITKE352,565 pointsBadges:
  • Cost to Upgrade to SQL Server 2008 R2

    How much will it cost to upgrade from SQL 2005 to the 2008 R2?

    ITKE352,565 pointsBadges:
  • I need to replace a word in a Document through SQL Server 2008

    Hello  i'm using SQL 08 R2 to store my resume collection , i want Sql to find an Email  in the MS WORD document and replace it with an empty string  so far I've succeeded to find the word using fullTextSearch  this my example for finding the documents that contain an email  SELECT  document...

    Shayguri15 pointsBadges:
  • SOLAP in SQL 2008R2

    IS there SPATIAL OLAP implementation in SQL 2008R2

    JiriJ5 pointsBadges:
  • Copy BLOB to BLOB using TSQL

    Is there a way I can copy a BLOB from one column to another using TSQL ?

    Prototyper5 pointsBadges:
  • IT Book Giveaway: Oracle Solaris Cluster Essentials

    We've got your ultimate in-depth resource on the start-to-finish lifecycle guidance for planning, implementation, management and troubleshooting your Oracle Solaris Cluster. There's even helpful advice for both Oracle and non-Oracle database environments. Win this valuable resource by answering one...

    MelanieYarbrough6,345 pointsBadges:
  • How many processors can SQL Server 2008 R2 support?

    How many processors can SQL Server 2008 R2 support?

    ITKE352,565 pointsBadges:
  • SQL 2008 R2 CPU Count

    The SQL 2008 R2 Std specification says it can use up to 4 cpus.  If I have two quad-core xeon processors.  Would this count as 8 or 2?

    LeeHerr15 pointsBadges:
  • Master Data Services – Confused by mdm.tblStgMember

    Hi, In Denny's excellent blog on loading data into Master Data Services, he populated the staging tables as follows: INSERT INTO mdm.tblStgMember (ModelName, HierarchyName, EntityName, MemberType_ID, MemberName, MemberCode) VALUES ('Adventure Works', NULL, 'FirstName', 1, '', 1), ('Adventure...

    IanR5 pointsBadges:
  • Report Server Install Best Practices

    I am setting up my first Report server. Should the Data Engine and two databases that are automatically created reside on the Report Server or on another SQL Server machine?

    Mongo7305 pointsBadges:
  • Is an existing BI solution required to use the BI capabilities of SQL Server R2?

    Is an existing BI solution required to use the BI capabilities of SQL Server R2?

    ITKE352,565 pointsBadges:
  • Managed Self Service Approach to BI

    How can the “managed self service’ approach to BI benefit my organization?

    ITKE352,565 pointsBadges:
  • Do I need to remove SQL Server 2005 to install SQL Server 2008 R2?

    Do I need to do a complete removal of 2005, as tried that on a new Windows Web server 2008, as wanted to put 2008 SQL Server.

    ITKE352,565 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following