Forum Replies Created

Viewing 15 posts - 241 through 255 (of 318 total)

  • RE: SQL 2008 installation

    Please review the following link to answer your question and good luck

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

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Identify SQL Licensing Configuration

    This is a really ugle subject in my opinion as Microsoft stopped asking for the license key at installation in version 2005 and higher, now you get a piece of...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Connect to Database Engine Box

    Good to hear, glad I could help.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: No option available to create subplan SQL Server 2005

    Great to hear, glad to help.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Memory configuration

    Since this is a dedicated SQL Server, the memory allocation is fine being set as default. Other things to look at are backups of the databases especially the transaction...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: No option available to create subplan SQL Server 2005

    No worries, I am just glad homebrew01 caught the obvious oversight on my part. That has always been one of SQLs most annoying statements, @@version gives only the build...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: No option available to create subplan SQL Server 2005

    That's it, you are currently running SQL Server 2005 RTM - no service packs have been applied. If you would like to see all available versions, updater, service packs...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: No option available to create subplan SQL Server 2005

    Good catch - please run the following in SSMS

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    Results need to be SQL Server 2005 Service Pack 2 2005.90.3042 or higher

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: No option available to create subplan SQL Server 2005

    One more question than I will bow to the higher powers - is this happening on the actual server or when you are attempting to create a subplan via your...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: No option available to create subplan SQL Server 2005

    May I ask what SP you are running, there was a bug on Maintenance Plans prior to SP2 on SQL 2005

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: No option available to create subplan SQL Server 2005

    I must be confused by what you are saying as I have multiple Maintenance Plans in SQL Server 2005 where I created multiple Subplans. If you are in the...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: SQL Server 2008 Login Error

    One more option, besides verify the TCP/IP enabled is to check the firewall and specificly port 1433

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: Connect to Database Engine Box

    You need to delete a particluar file, which will remove all listed servers - "It turns out that you actually can clear the list, but it requires that you remove...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: SSMS shows is Busy when right clicking on the Instance Name

    Is this happening at the server or on a local workstation? Check to see how much memory is allocated to your SQL Server instance and also take a look...

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

  • RE: hot fix service number

    The following site lists all versions of SQL with a link to what exactly is in each update/release.

    http://sqlserverbuilds.blogspot.com/

    Hope this helps.

    Chris Powell

    George: You're kidding.
    Elroy: Nope.
    George: Then lie to me and say you're kidding.

Viewing 15 posts - 241 through 255 (of 318 total)