Is there anything in the SQL server error log ? Are there any *.DMP files on the SQL Server ? Do the event logs have any entries that correspond to...

Standards are meant to be followed, although not 'rigidly' ... as with most sets of rules there are always going to be exceptions. So here's my thinking ... #tables ('true'...

Nothing is 'phantom'. Based on  the output you posted:

OBJECTNAME OBJECTID INDEXNAME INDEXID ...

------------------------ ----------- ------------------------ ----------- ...

BAT_AUDIT 1838785758 PK_BAT_AUDIT 1 ...

BAT_AUDIT 1838785758 TBAT_AUDIT 255 ...

PK_BAT_AUDIT index has INDEXID of 1...

OSQL or QA will work. Here's a link to get you started:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;241397

MSDE databases can most certainly have databases in 'full recovery' mode. I've 2 vendor applications using MSDE that were simple recovery with no maintenance plans whatsoever when originally installed. They now have Integrity Checks,...

The Unix 'fork' command would be a useful addition to the world of Windows ... MS has taken more, | and other things from Unix, why not 'fork' too ?

SET XFILES_MODE ON

XML is a secret government plot (covered up by plausible deniabilty). The government owns major stakes, via clandestine channels, in all major disk manufacturers around the globe. Everyone in IT...

This sp will be 'removed' sometime in the future ...

Use "ALTER DATABASE your_database_name SET RECOVERY SIMPLE" instead.

42000 errors are almost always user/password issues whether it is 'mixed' or Windows Authentication. You could use the 'advanced' tab and capture the actual execution output in a file from...

Agreed. The Q & A section should be reviewed (maybe even tested) prior to posting.

Try the installation without "window 98 compatibility mode" and choose "mixed security".

Also, here's a few links to research as well.

 http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.mspx

 http://support.microsoft.com/default.aspx?scid=kb;en-us;841249

 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp

SET RIB_THE_WEBSITE ON

a non-clustered web server ?!?!?

please don't tell me SQL Server is running there too ...

(just touting SQL Architecture 101)

SET RIB_THE_WEBSITE OFF

PFM = 'pure f**king magic'

analogous to the FM box

It will not affect our plans. This feature, as with most in 2K5, are 'nice to have' but not 'essential' for our operations. Granted when we have our DR site...

The choice of 'query modification' over putting the 'not in' the values in a table for a join speaks tremendous amounts. Have we forgotten that an RDMS (erlational database management...