Forum Replies Created

Viewing 15 posts - 376 through 390 (of 1,079 total)

  • RE: SQL 2012 RTM 64bit Install Fails on Windows Server 8 Beta

    no, physical. OS installs as 64it, tried 32 and 64bit sql installers, same issue.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: DNS A records SQL 2008 R2 InstallFailoverClusterGlobalRules

    1. Are you installing the SQL Cluster as a domain user with sufficient access to the AD OU where the objects need to be created.

    2. Does the setup account have...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: CREATING A SQL SERVER 2008 R2 ACTIVE\ACTIVE CLUSTER

    That could be due to a lot of things.

    Maybe post the error?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Linked Server Naming Issue?

    You'll need to look at the syntax when working with dashes in text:

    select * from [Site1-DV-SS-01].[Database].[Schema].[Table]

    Try this.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: My problem with output parameters

    It can be anything.. y should i be concered with it.. I just need to be sure my code does return the values

    The same reason why any Application Developer should...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: SOL Job Login Failure

    is your package using any network data sources that require authentication?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: My problem with output parameters

    1. There is no way i can check if calling application is recieving the output from my sql server side. And the code is really working or not. There is...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: CREATING A SQL SERVER 2008 R2 ACTIVE\ACTIVE CLUSTER

    The account you are installing with, must have modify rights to the container/OU where the new virtual objects will be created.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: SSAS and Sharepoint

    Its as easy as pie...

    here are a few setup references...

    http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?ID=337

    http://technet.microsoft.com/en-us/sharepoint/ee692578

    http://blogs.devhorizon.com/reza/2010/05/03/bi-center-and-data-connection-errors-when-using-performancepoint-dashboard-designer/

    http://technet.microsoft.com/en-us/library/ee748644.aspx

    In essence, you will need the following:

    1. SSAS Cube

    2. Sharepoint with performance point service

    3. Unattended service account

    4. Secure Store Proxy...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: ETL Tool

    Microsoft SQL Server Integration Services (SSIS) 😉

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: CREATING A SQL SERVER 2008 R2 ACTIVE\ACTIVE CLUSTER

    Be careful or your setup might do the opposite of what you require.

    SQL Server & Windows will create the resource groups based on what you provide in the setup.

    Run Cluster...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: UPDATE STATEMENT ERROR (Subquery returned more than 1 value)

    How many results are returned by this statement?

    SELECT count(*) FROM dbo.tblDependents as a inner join dbo.tblHOF as b on a.FamilyID = b.FamilyID group by a.FamilyID

    your group by clause could return...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: How or Steps to Allocate a dedicated processors to SQL Server instance

    1 more request is to know is it good or bad to acheieve the same. Or pros and cons on the same

    It depends. On the CPU allocation you will need...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: How or Steps to Allocate a dedicated processors to SQL Server instance

    Before making any changes to the CPU settings, read the following.

    http://msdn.microsoft.com/en-us/library/ms187104.aspx

    http://msdn.microsoft.com/en-us/library/ms186255(v=sql.90).aspx

    To set max and min memory for SQL Instances, read below documentation:

    http://msdn.microsoft.com/en-us/library/ms191144.aspx

    http://msdn.microsoft.com/en-us/library/ms178067.aspx

    Keep in mind, there are other considerations when...

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • RE: Linked Server in Win 2008 and SQL Server 2005(64 bit)

    Not sure if you configured the TNSnames yet?

    a few guides below:

    http://www.ideaexcursion.com/2009/01/05/connecting-to-oracle-from-sql-server/

    http://support.microsoft.com/kb/280106

    http://www.sqlmag.com/article/sql-server/setting-up-an-oracle-linked-server49687

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Viewing 15 posts - 376 through 390 (of 1,079 total)