Forum Replies Created

Viewing 15 posts - 8,581 through 8,595 (of 9,244 total)

  • RE: I can't create a database T__T

    Vista users run as low privelege normally, what does sql authentication produce running the same statement?

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

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

  • RE: Is there a Bug with the Replace() Function in SQL Server 2005

    Lynn Pettis (12/17/2008)


    since it needs to create the table on the fly it doesn't know how big the column needs to be so it so it makes it the maximum...

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

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

  • RE: SQLVDI error 1060

    fputhod (12/22/2008)


    I installed from a internet download

    from where exactly?

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

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

  • RE: SQL Server Failover Clustering Test Methods

    Nicholas Cain (12/24/2008)


    The best way to test....unplug stuff

    at the end of the day this is exactly what clustering is designed to protect against so yes its the best way. Fail...

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

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

  • RE: Database mail using Exchange Server

    just be sure not to tick the "relay messages to all domains" check box otherwise after a couple of hours your public ip address will be blocked 😉

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

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

  • RE: RAID 1 vs. RAID 10

    kendal.vandyke (12/24/2008)


    Maybe the question was misunderstood.

    not at all.

    RAID 10 will generally offer a performance boost over RAID1 due to the striping across mirrored sets. As SQL server writes to...

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

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

  • RE: Backup Compression in sql server 2000

    there are some freebiee sql utils but the best bet is either Redgate SQL Backup or Quest Litespeed?

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

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

  • RE: RAID 1 vs. RAID 10

    i would say the RAID 10 array is best as it offers the best performance and fault tolerance combined into one package. The downside of RAID 10 is the disk...

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

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

  • RE: Missing Indexes

    sorry god but i'm not the one with the ego problem am i. Also i havent made any obscene comments, i just told you to quit crying like a pair...

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

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

  • RE: Server Status Icons

    VEB (12/24/2008)


    I have similar situation.

    The problem is that the host with SQL Server has Windows Firewall configured. Ports 1434/UDP and the static ports associated with instances are opened in the...

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

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

  • RE: Database mail using Exchange Server

    port 2525 is usually used if blocking port 25.

    Verify with the exchange admin the listener and outgoing ports?

    Is the exchange server on the same network as the sql server?

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

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

  • RE: Considerations for RAM

    the following post

    http://www.sqlservercentral.com/Forums/Topic529146-146-1.aspx

    has a detailed answer from Gail for a similar scenario

    and this post

    http://www.sqlservercentral.com/Forums/Topic622415-146-1.aspx

    has my previous answer

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

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

  • RE: Missing Indexes

    why act like a couple of little girls. The solution you provided is correct if the question were different. As far as i can see he wanted to know what...

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

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

  • RE: copy a database from one server to another server

    Perry Whittle (12/22/2008)


    use the generate scripts option to script of the indexes, constraints, triggers,etc

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

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

  • RE: Database mail using Exchange Server

    the sql server simply connects to exchange over port 25 and sends the mail!

    from your sql server, telnet to port 25 on the exchange box, do you get a successful...

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

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

Viewing 15 posts - 8,581 through 8,595 (of 9,244 total)