Forum Replies Created

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

  • RE: user mapped as dbo

    Initially I would have said the login owns the database, double check and confirm this is not the case.

    Has this database come from sql2000 at some point?

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

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

  • RE: Using a static port

    can you post a screenshot of what you see?

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

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

  • RE: What's wrong with my SMO C# tiny program?

    you need to instantiate the Urn[] collection before attempting to use it.

    Revise the following

    StringCollection sc = scripter.Script(new Urn[] {db.Urn });

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

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

  • RE: Checklist to troubleshoot low disk space issues in SQL server

    SQLCrazyCertified (8/13/2012)


    All,

    I need help from all of you to put together a checklist for troubleshooting disk space issues. In our environment, we get a lot of tickets regarding space...

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

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

  • RE: Using a static port

    you're opening the SQL Server configuration manager program, correct?

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

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

  • RE: SQL Distributed Transactions - DTC

    the DTC is used by many applications including sql server. In SQL Server a dtc is used for remote transactions such as lnked servers and openrowset queries.

    A clustered DTC is...

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

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

  • RE: Configuring Services of SQL 2005 in Clustering

    ufcheema (8/14/2012)


    Q. 1.

    ====

    Let me know how and what to configure for stable SQL 2005 cluster in clustering (mean services etc to be configured in win 2003 cluster).

    The installer configures all...

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

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

  • RE: maintenance script to exlclude dbs

    Your main issue was the syntax error in the calling script.

    It won't hurt too much to use page count 8 in your script as your using the results to view...

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

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

  • RE: SQL Browser service needed for non-standard static port?

    that's as maybe, but the idea is to specify port or instance name. Both just serves to cause some people confusion

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

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

  • RE: SQLIO Disk Testing

    SQLSACT (8/14/2012)


    Perry Whittle (8/14/2012)



    If <mask> is absent or 0, then no affinity

    will be enforced.

    :Whistling: 😉

    Thanks

    What does that mean?

    OK, now i'm worried 🙂

    if you intend to...

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

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

  • RE: SQL Browser service needed for non-standard static port?

    andersg98 (8/13/2012)


    At the risk of adding confusion you can connect to an instance using a nonstandard (not dynamic) port and the server name without the browser service.

    example: Servername.domainname\instancename,port_number

    you specify...

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

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

  • RE: SQLIO Disk Testing


    If <mask> is absent or 0, then no affinity

    will be enforced.

    :Whistling: 😉

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

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

  • RE: Copying files from One Server to another (two Servers in different Domains)

    ajay.g (8/14/2012)


    Hi,

    I've a requirement to copy the files from one Server to another Server where they exist on diff. Domains. On first Server, we've administrative privileges with Domain accounts (like...

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

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

  • RE: SQLIO Disk Testing

    well firstly, each of the runs really needs to run for longer than 5 seconds to get any real metrics 😉

    What are the results that are produced from the runs...

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

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

  • RE: SQLIO Disk Testing

    can you supply details of the config file you are using

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

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

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