Forum Replies Created

Viewing 15 posts - 7,066 through 7,080 (of 7,429 total)

  • RE: MS DOS char set

    It is the font, change the font under options to terminal in QA and it will look the same.

    "Don't roll your eyes at me. I will tape them in place."...

  • RE: Service Packs

    If you are talking about install a SP for SQL, I believe based on my experience 'No'. I have never run into any issues.

    "Don't roll your eyes at me. I...

  • RE: Binary data in database

    1) Experience was somebody elses headache.

    2) Store to disk and store links in database is easiest and most efficient, plus you don't have to code for placement and readin in...

  • RE: bcp error when queryout is "exec stored_proc ..."

    COuld you post some details on the procedure. I have tried several and could not duplicate, nor have I come across this before.

    "Don't roll your eyes at me. I will...

  • RE: Executing script files from my hard drive

    Usually you just open in Query Analyzer and run. You can associate the file with Analyzer so you can click and open from the file then run. But when ...

  • RE: Disaster Recovery

    One of the big bennifits you can give yourself with repliocation is have a seperate distributor instead of having it the same server as the publisher. Also if you are...

  • RE: Service Packs

    I don't believe so.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • RE: Suspect databases

    Have you checked in the SQLServer Log to see what error may be occurring when this happens or if anything specific is logged. Also check event viewer. Finally are you...

  • RE: Is 0% Downtime Possible?

    Log replication is not better than any other method but I use replication here on our SQL server for data that I need to make sure I have an almost...

  • RE: Trigger Problems Part 2....

    Have you traed on the remote server as well to see what it is doing. Since the data is all one transaction I believe it will fail to commit no...

  • RE: MULTIPLE ORDER BY in a stored procedure.

    Wow I missed that one as I was thinking that if your case output no column you would be left with ASC, aulname DESC, ASC, aufname DESC which will bark...

  • RE: nonlogged insert

    If you have the space, then yes but I would give the log file a large grow ratio and start size then force it down after done. There is a...

  • RE: Why need Sql 7 client Config Utility?

    Actually the client software sets a set of values in the registry and I have successfully put out several apps without the use of the client. As far as resolving...

  • RE: BackupExec & SQL 2000 problem: recovery model

    Open Enterprise manager and right click the offending DB and open properties. You will find the recover model on one of the tabs (sorry no visual to help remember but...

  • RE: nonlogged insert

    If you have some key in your data that you can use to segment then do it in pieces that way you can truncate the log after each copy. Also...

Viewing 15 posts - 7,066 through 7,080 (of 7,429 total)