(Verify that the OCI versions are registered correctly as described earlier in this article.

Note If the registry entries are all correct, the MtxOCI.dll file is loaded. If the MtxOCI.dll...

I found these two dealing with the issue in both SQL Server 2000 and 2005, check to see what you need to change.  Hope this helps.

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

http://www.dotnetjunkies.com/WebLog/daveadamson/archive/2005/11/22/133928.aspx

Ok I have got the links to the Microsoft provided code, you should write a stored proc to collect all the new values and put the values into a separate...

Ok now I see what is wrong Steve wrote about it while back in SQL Server all aggregate functions ignore nulls except COUNT(*), so add COUNT(*) to your Min because...

(It is not a bug the other nulls come from OUTER JOIN it default to a null, you could use ISNULL and provide the expected value.)

I did not say anything...

(Windows NT 5.2 (Build 3790: Service Pack 1)

The OS is in service pack one.

They are .sql files in an installer they also includes all previous service packs of the product, the changes are based on hardware, network, OS and other factors.  I run...

(The query includes a summary function (MIN), joins 17 tables form 3 database, and has a group by clause with 22 fields. He says that the query works in SQL...

Try dropping the indexes before dropping the tables if you don't have plans to use the tables again.

I will second that Microsoft SQL Server patches are harmless .sql files yes I have opened and used with most OS, if you watch closely you can see how many...

In 2005 you can shrink the log file to specific size so if most of the 20gig is log file you can either truncate it or shrink it to size. ...

This is very easy to do with DTS/SSIS package run as a job using xp_cmdshell, SQL Server Agent needs Admin level permissions either as clone or nonclone.  There is .NET code...

All of the above is not valid because there are some of us without kids who still face the same discriminations.

Ralph Kimbal in 2004 published a 38 points ETL(extraction transformation and loading) checklist it is a formal structured way to move from OLTP to OLAP.  Hope this helps.

http://www.intelligententerprise.com/showArticle.jhtml;jsessionid=UOJCDIO4MVFE0QSNDLRCKH0CJUNN2JVN?articleID=54200319

Actually Backup and Restore moves logins too it moves everything and you can keep 2000 compatibility level, known issues orphaned permissions solution delete the restore and create a new one. ...