I'm seeing others that have problems with this update.  It will not install
on my SBS 2003 server.  In the article http://support.microsoft.com/kb/948110 
there is detail about the SP4 not being correctly installed.  I did notice
that if I eliminated the autorun.inf on my sp4 ...

The Problem:
I'm trying to backup a SQL2000 cluster over the network using 2 maintenance
plans, one for 'simple' recovery DB's and one for 'Full'.
However for different databases I'm getting a mix of the following problems:

SQL Server 2005
Sharepoint with mirroring of all databases to DR box
One of the Sharepoint databases has hyphens in it.  This is causing an
error in the Database Mirroring Monitoring Job.  The error seems

Firstly I have a W2K3 SP2 server with SQL2000 SP3 build 818 on it. If I run
Microsoft Update under IE7 it is not picking up the bad version of SQL2000.
I had seen a note to say that MS has improved the detection of this patch.
Personally I would never use Microsoft Update to ...

I am able to activate sql users by exec EXEC sp_change_users_login
'Update_One', 'Mary', 'Mary'
How do I run a scrypt to activate windows user?

I added a company_type field to the COMPANY table and deleted the
MANUFACTURER table to normalize the database.  Now I need to put the
comp_id in the CAR table in place of the man_id. If the man_id in
Manufacturer = the man_id in CAR then put the comp_id value in the

SQL 2000 Enterprise Server.
I have a database with the user: user1 that has a db_owner rights.
That databases has about 50 tables.  We need for user1 to have
db_owner role to all tables except the two (new requirement).  user1

I have the following as part of a query on a SQL 05 server.
patient_name = case patient.middle
    when NULL then patient.first+' '+patient.last
    else patient.first+' '+patient.middle+' '+patient.last

We are running SQL 2000 for the back end.  We have created a DB on the
server called MFGData.  In MFGData there are a series of tables where we
dump our test results from our products.  The sofware we use to test was
developed with National Instruments Labview which connects to ...

In SQL 2005 (version 9.0.1406), I could not restore a backup of a database
without having to stop and restart the SQL Server service.  Beforehand, if I
tried to restore, I would get a message saying that the database was in use
even though it was not in use.  Again, once I ...

On a SQL 2005 SP2 when detaching a user database as a user (has admin
rights) using management studio from another pc. Afterwards the
permissions on the database files only have permissions for the user
that was used for the detach.

Last night I did upgrade SQL express to SQL std using command
setup.exe SKUUPGRADE=1. Then I applied SP1 and SP2. However I only did
database service upgrade and forgot the workstation components. Can I do this
after upgrading the database service and applied the sps.

I have been mucking about (reading) recently with some
MicroSoft SQL Server database files.  One of the databases
I have been given contains an enormous 20Gig+
*_log.ldf file (about 10 times as large as the *.mdf)

I have SQL Server 2005 and SharePoint Server 2007 installed on a single box.
The problem I am having is with SharePoint backups, they fail claiming that
another tool carried out the last back up.
It appears that at 10PM every night, SQL Server backs itself up some how.

If I have a Table NAme "StudentGrades"
Is there a way to add a More Descriptive Name to Table for Display purposes???
I may want to show a list of tables and sometimes the name are misleading
and also I may show table in Various Languages and have the Name Translated