Forum Replies Created

Viewing 15 posts - 8,461 through 8,475 (of 9,241 total)

  • RE: SQL 2005 and GIS server

    SQL_Quest (2/4/2009)


    Hi Mark,

    I have just a simple question ... we are using ArcGIS server 9.2 enterprise edition... does this server have the ArcSDE service running in it? If yes,...

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

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

  • RE: service accounts - domain vs. local

    VEB (2/4/2009)


    If a domain account is compromised, the domain is affected

    its a low permissions account so no more a risk than any other domain user. Your windows system admin should...

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

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

  • RE: service accounts - domain vs. local

    VEB (2/4/2009)


    Why can't I use local accounts for SS services in a domain environment?

    why build a windows domain in the first place?

    its not that you cant use local accounts, if...

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

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

  • RE: service accounts - domain vs. local

    VEB (1/29/2009)


    Hello,

    I run SQL Server 2005 instances under local service accounts for Servers, Agents, and Browser services in order to follow less privilege account practice. I have no problem so...

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

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

  • RE: Best Practices for the System Databases

    EdVassie (2/4/2009)


    The SP2 install places a new version of mssqlsystemresource into the original location of this database (as defined at install time) and upgrades the master database to the new...

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

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

  • RE: Uninstall one instance of several named instances?

    BOL = SQL server Books online

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

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

  • RE: How to ascertain the path of an active SQL trace (2005 & 2000)

    elitejyo (2/3/2009)


    created using SQL Profiler

    :blush: oops missed that one totally

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

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

  • RE: How to ascertain the path of an active SQL trace (2005 & 2000)

    fn_trace_getinfo returns five rows for every trace active. Property id 2 indicates the trace path and file, maybe you are not checking the correct property for the active trace

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

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

  • RE: service accounts - domain vs. local

    domain or local the account should be low permission. Setup will assign the correct permissions for the account when installing the system or when setting through SQL configuration manager

    domain account...

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

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

  • RE: Want to become expert in clutering

    what version\edition of VMWare are we talking?

    if its VMWare server forget it for a production system. The point of clustering is to remove the hardware failure factor (not load balancing)....

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

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

  • RE: SQL Server Schemas

    database role best ways to go 😉

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

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

  • RE: corrupt Management Studio

    Mark Thornton (2/2/2009)


    it shows that I have 9.00.1399.00

    that's RTM not SP2, apply the service pack again and you should be golden

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

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

  • RE: Not able to Loghsip for MOM onepoint database

    check the onepoint database recovery model as suggested already

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

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

  • RE: Best Practices for the System Databases

    your welcome Jason

    as we have stressed already, just make sure resource is i the same place as master.mdf otherwise when you come to upgrade you could\will hit problems

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

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

  • RE: Best Practices for the System Databases

    IIRC the only time you get problems with upgrades after moving the master database is if the resource database is in a different location. That is why they need to...

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

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

Viewing 15 posts - 8,461 through 8,475 (of 9,241 total)