Forum Replies Created

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

  • RE: service accounts - domain vs. local

    VEB

    you really are making more complex than it actually is. The whole point of a domain is to centrally manage obects within the domain. If your SQL server is part...

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

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

  • RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

    Great article Jonathan, should wet peoples appetites for CLR a little

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

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

  • RE: SQL 2005 and GIS server

    th post installation will be on the program menu on the server. Yes run the post install and configure a service. Our sql server is on SQL2005 SP2

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

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

  • 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" 😉

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