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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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:\...

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

Role on YUKON.

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...

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...

If it works its obsolete

It depends on the nature of the evolution. If it is constantly trying to implement new stuff then this suggests that...