Forum Replies Created

Viewing 15 posts - 3,496 through 3,510 (of 3,603 total)

  • RE: Worst Practice - Bad Comments

    I've set up a case-sensitive SQL Server simply because the data that had to be imported from external sources needed to retain its case sensitivity. ID fields were an...

  • RE: SQL 2000 SP3

    I've got a strange problem that has occured after an SP3 install.

    All my SQL Servers, including my Lap top install are at SP3. All are running fine.

    If I use...

  • RE: Worst Security hole I have ever seen

    In the UK 2 Years ago a SQL DBA could look for work in the £30K - £40K region.

    Being a DBA meant something.

    Today a SQL DBA will probably see jobs...

  • RE: SQL Worm - Are we lazy

    I WISH!!!

    The problem is that it is on a client's site and is working fine. It is a case of "if it ain't broke, don't fix it".

    All(!?!) we have...

  • RE: Using Exotic Joins in SQL Part 1

    I'm not sure how they could drop support for the WHERE clause.

    If they are then they would be breaking away from ANSI standard SQL and force a paradigm...

  • RE: SQL Worm - Are we lazy

    I have an issue with some legacy systems that are running MS SiteServer 3.0.

    If you've ever dealt with this package you will know that you have to follow a 16...

  • RE: Using Exotic Joins in SQL Part 1

    Is there any benefit in using these sort of joins instead of using the WHERE clause?

  • RE: Initial Installation of the Production Database

    We have a similar testing methodology but also have UAT (User Acceptance Testing). This keeps the end user involved in the system that they are going to have inflicted...

  • RE: SQL 2000 SP3

    quote:


    Microsoft SQL Server 2000 - 8.00.760 (Intel X86)

    Dec 17 2002 14:22:05

    Copyright (c) 1988-2003 Microsoft Corporation

    Enterprise Edition on Windows NT...

  • RE: SQL Worm - Are we lazy

    Sorry for the daft question buy what is a hibernating lap-top?

    To summarise the key points that have arisen due to Slammer.

    Patches/Service Packs are not applied because:-

    • Applying a patch to...
  • RE: SQL Worm - Are we lazy

    I agree with everything you said.

    My issue is that the fix did not say "put this on or you will get a virus" and I am not sure that it...

  • RE: SQL 2000 SP3

    The "not enough space on the C:" drive was absolutely correct.

    The extraction process must bounce stuff via the TEMP directory or something.

    As soon as I had cleaned up my C:\...

  • RE: Block the DBA?

    Actually your article highlights a need that isn't satisfied via legitemate means i.e. triggers on system tables.

    Role on YUKON.

  • RE: SQL 2000 SP3

    I can't get SP3 off the launch pad.

    The SETUP.BAT file refers to \x86\setup\sqlsetup.exe as does the readme file however, I don't get a \setup directory within \x86.

    I've tried SQL2KSP3.EXE and...

  • RE: Block the DBA?

    I know you said it was wortst practice in your article, but the icy hand of DBA's past gripped my heart when I read about altering system tables.

    I am always...

Viewing 15 posts - 3,496 through 3,510 (of 3,603 total)