Forum Replies Created

Viewing 15 posts - 16 through 30 (of 130 total)

  • RE: help with syntax

    I'd agree with that, and apologise.

    DB


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: help with syntax

    Oracle is my guess. Also the spelling and grammar in this cross post has magically improved. And who says cross-posting is now ethically allowed (apart from Muhammad Abbars of course)...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: First SQL Error Message

    Have a look at :

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

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

    DB


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: BAK Files - Attributes

    A form of backup has been done for these files that used to have the Archive attribute set ?

    Most backup programs will reset the A attribute.

    So, potentially, you do a...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: What''s the Right Thing?

    If a promotion said 'buy one, get one free' wouldn't you expect to have to pay for one and get one free ? the only possible confusion here is when...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Shortening the length of a column in a table

    or on a per-session basis-

    SET ANSI_WARNINGS

    Specifies SQL-92 standard behavior for several error conditions.

    Syntax

    SET ANSI_WARNINGS { ON | OFF }

    Remarks

    SET ANSI_WARNINGS affects these conditions:

    • When ON, if null values...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Daily Newsletter Layout

    You get it everyday ? Hey, that's not fair. Or is it an option ?

    Actually it's been more regular recently but still not every day.

    You guys should release the psychics's...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Best practices - How an app. should behaves when the DB server is gone

    Ninja's RGR'us:

    If you are using Visual Studio (whatever language) and MSofts Best Patterns and Practices (Errologging block) you can configure the app to log to multiple error loggers or...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Reindex

    So, 5 big tables at app. 1 million rows ea. + some other tables occupying 85 GB ? Is this right ? (85 GB data file?)

    How are you doing the...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Fatal error 625 - Connection broken problem (Help needed)

    One nasty horrible little program I came across can cause this - apart from the suggestions supplied.

    It's called Entercept (or was, I think they renamed it) from McAfee and...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Simple Select statement help

    You mean put the results into notepad, print it, and stick it up on the wall ?

    Sorry it's friday morn 6:50am and I haven't really started on my coffee yet.

    (hey, I...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Simple Select statement help

    It's time you used BOL a bit more - there is absolutely heaps of info there. Your last two queries are well handled by Books OnLine.

    It is possible that BOL...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: strange sql memory error

    Ahh, the Devil's in the detail isn't it.....

    Can you show us the query and the ddl please ?

    And maybe some details of the machine you running the query from (Available...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Perfromance Monitor: unable to connect to machine

    2003 has much improved security. Check that domain admins are a member of the Adminstrators group.

    If you can get to the console, log in as yourself and try running perfmon...


    The systems fine with no users loggged in. Can we keep it that way ?br>

  • RE: Some clients cann''''t connect to QSL server after restarting SQL service

    "did you restart the services using CLUSTER MANAGER ?" is a dang good question.

    But, you are saying some clients can't connect and some can ?

    Check the problemattical clients ODBC settings....


    The systems fine with no users loggged in. Can we keep it that way ?br>

Viewing 15 posts - 16 through 30 (of 130 total)