Forum Replies Created

Viewing 15 posts - 91 through 105 (of 335 total)

  • RE: sp_send_dbmail and hyperlinks with spaces

    replace the space with %20, so "just a name" will be "just%20a%20name"

    (%20 is hex for 32, which is ASCII for space)

    Wilfred
    The best things in life are the simple things

  • RE: SP3 Installation

    Interesting:

    Microsoft SQL Server 2005 - 9.00.4028.00 (X64) Oct 20 2008 19:33:01 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790:...

    Wilfred
    The best things in life are the simple things

  • RE: SP3 Installation

    when i checked on the server property at Version i see this

    9.00.3042.00

    Nope, 3042 isn't SP3, it's SP2. SP3 should give 9.00.4035 (just installed SP3)

    See this link http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx for...

    Wilfred
    The best things in life are the simple things

  • RE: why the backup failed ?

    make sure the password for this account is the same on both servers

    Wilfred
    The best things in life are the simple things

  • RE: why the backup failed ?

    Do you have an error message or some detailed logging?

    Wilfred
    The best things in life are the simple things

  • RE: Job Failed

    The problem is quite clear: SQL Server does not exist or access is denied

    Seems this script transfers data to another SQL Server?

    Check manually if you can make a connection to...

    Wilfred
    The best things in life are the simple things

  • RE: SP3 Installation

    Just to be sure, the

    Build 3790: Service Pack 2

    has nothing to do with SQL but with Windows Server.

    Have you checked your version with the SERVERPROPERTY function?

    Wilfred
    The best things in life are the simple things

  • RE: what is the use of Raid ?

    It's also excellent for getting rid of bugs

    http://www.killsbugsdead.com/raid/

    Brilliant! that's a interesting implementation of RAID. No more bugs on my SAN storage! :):)

    Wilfred
    The best things in life are the simple things

  • RE: Application

    SQL 2000 is dead

    SQL 2005 is dying (almost)

    SQL 2008 is just born

    Go for 2008

    Wilfred
    The best things in life are the simple things

  • RE: Database growth

    Other question: Why do you have 2 logfiles?

    Unlike datafiles, logging is not spreadded over 2 files. It's just filling logfile 1 before using logfile 2

    Wilfred
    The best things in life are the simple things

  • RE: Is this possible: move logfile online?

    A lot of application servers are connected to this database and this database is used allday. If I need to stop the database, I have to stop a lot of...

    Wilfred
    The best things in life are the simple things

  • RE: cannot connect to 2005 (x64) server

    Thanks for your reply.

    Unfortunately, this results in the same error (login failed)

    Wilfred
    The best things in life are the simple things

  • RE: Back-up jobs taking forever to run

    Other thing I was thinking of:

    If you delete a backup, SQL has to do some maintenance in the msdb database. So deleting an outdated backup results in:

    - a DOS (yeah,...

    Wilfred
    The best things in life are the simple things

  • RE: Back-up jobs taking forever to run

    Try defrag your disks

    Wilfred
    The best things in life are the simple things

  • RE: Difference between Saving Table And BAckup

    Or you could use a SQL script for the structure and export the data with the BCP utility.

    Or save your tabledata by running:

    select * into {savedtablename} from {tablename}

    Wilfred
    The best things in life are the simple things

Viewing 15 posts - 91 through 105 (of 335 total)