Forum Replies Created

Viewing 15 posts - 8,176 through 8,190 (of 9,244 total)

  • RE: Script to find all objects owned by a user (loginname)

    JC-3113 (11/18/2009)


    Hi Perry

    does that just give me a llst for the person logged in ?

    Thanks

    Jim

    no, not especially. Is that specifically what you are looking for?

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

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

  • RE: Script to find all objects owned by a user (loginname)

    Greetings all

    Vivien Xing (7/8/2008)


    rbarryyoung (7/8/2008)


    Actually, it is not valid to exclude 'dbo' here. If a Login owns a database, then they are user 'dbo' in the database and they...

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

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

  • RE: how to configure sql server memory

    verify connectivity to the sql server and database. from a remote machine start a sqlcmd session and connect then query the database. What results do you get?

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

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

  • RE: how to configure sql server memory

    what errors particularly. Can you post some samples

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

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

  • RE: I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1

    Lyn

    its not a good idea to hijack another thread best to start your own. That aside can you post details of the setup log as Santosh has done Some idea...

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

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

  • RE: I have two instances of SQL Server 2005 version 9.00.3042 on a windows 2003 Enterprise Edition server service pack 1

    santosh_chandel (10/2/2008)


    **********************************************************************************

    Products Disqualified & Reason

    Product ...

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

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

  • RE: Cannot Reinstall SQL Server 2005

    try manually installing the SQL native client and .NET 2 framework first

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

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

  • RE: Page life expectency & Memory

    yeah, in my experience McAfee software has some nasty memory leak issues. Get your AV version and go to the McAfee site and check for any fixes. Also stop the...

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

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

  • RE: Changing locaton of data and logs for the database and server

    Krav

    seriously, if you are not comfortable moving files at the OS level you should leave well alone and seek extra help first. Beware also, that whatever path and filename you...

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

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

  • RE: Page life expectency & Memory

    what antivirus software do you have installed?

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

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

  • RE: SQL Server Management Studio 2005 Crashes

    do you have any info about the machine the client is installed on?

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

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

  • RE: Page life expectency & Memory

    antivirus client installed scanning the SQL server folders by any chance?

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

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

  • RE: new 64-bit Sql 2005 Server - integrity check completes then memory spikes 75% and doesnt lower

    the Technet article is incorrect (it wouldnt be the first time would it 😉 )

    see the following Microsoft KB

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

    i always use lock pages on 64 bit systems, its even more...

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

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

  • RE: Page life expectency & Memory

    i would set the lock pages in memory policy for the sql server service accounts and configure the min and max memory setting values

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

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

  • RE: awe on 64 bit

    on 64 bit sql server systems you only need to apply the lock pages in memory policy to the sql server service account, dont touch the AWE check box it...

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

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

Viewing 15 posts - 8,176 through 8,190 (of 9,244 total)