Forum Replies Created

Viewing 15 posts - 7,561 through 7,575 (of 9,241 total)

  • RE: Stopping Services in an Active\Passive Cluster

    Jpotucek (10/14/2010)


    Do you think I should only take the Cluster Group offline

    No that would disable access to the cluster! This group will go offline when the last cluster node shuts...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Stopping Services in an Active\Passive Cluster

    Are we talking windows 2003 or 2008 cluster here?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: @@VERSION at odds with SP2 uninstall

    try posting on the MSDN forums may help.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Connect to SQL Server using I/P address in SSMS

    RaviShankar1234 (10/13/2010)


    I'm not able to connect to it even if I give i/p address with port number associated with Instance2

    what format are you using to specify the ip and port...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: @@VERSION at odds with SP2 uninstall

    have you informed MicroSoft product support?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Stopping Services in an Active\Passive Cluster

    as soon as you install SQL Server into a clustered environment it sets the service startup to manual on all nodes (imagine if 2 nodes both had the services set...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to remove/uninstall Management Data Warehouse

    No problem, the annoying thing is there are other issues with PDC which aren't fixed until at least SP1 CU7.

    Thing is it is a new technology in SQL server and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: slipstream sqlserver 2008 standard sp1

    george sibbald (10/13/2010)


    and SP2 is out so perhaps you should slipstraem that.

    Maybe in your test environment only at first 😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Add memory to sql server

    min and max memory settings are indeed dynamic. use the following query to set these

    exec sp_configure 'Show advanced options', '1'

    reconfigure

    exec sp_configure 'min server memory (MB)', 'valueinMB'

    exec sp_configure 'max server memory...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: slipstream sqlserver 2008 standard sp1

    yes!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: How to remove/uninstall Management Data Warehouse

    this is a real problem and many have complained! Don't use scripts to remove the default collection set jobs as you will have issues if you try to re enable...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 MS DTC

    Halcyon (10/12/2010)


    we have got service going down and not being restarted

    Thank you

    Sounds dire and beyond the scope of forum posts. What is your location, I am available on a contract...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: SQL Server 2008 MS DTC

    This post explains it a little more

    http://www.pluralsight-training.net/community/blogs/jimjohn/archive/2008/03/23/50536.aspx

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Transfering the Sa password from one server to another

    MarvinTheAndriod (10/12/2010)


    Thanks. Ran the T-SQL and it generated the following script:

    ALTER LOGIN [SA] WITH PASSWORD = 0x01004086ceb66433e82f3f8946c27e33641a8179e4ad419c5811 HASHED, CHECK_POLICY = ON, CHECK_EXPIRATION = OFF

    But it still generated the same error:

    Incorrect...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Transfering the Sa password from one server to another

    MarvinTheAndriod (10/12/2010)


    Lowell (10/11/2010)


    i see what you were refering to...if you run sp_rev_login with no parameters, every login EXCEPT sa is scripted.

    if you pass a specific login name, it gets scripted...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 7,561 through 7,575 (of 9,241 total)