RE: Beginner Resource Kit

My normal list of recommendations follow: Analysis Services 2000 Step by Step, Microsoft Press MDX Solutions, George Spofford, Wiley msdn.microsoft.com -- AS Documentation, sqlserver.olap user group www.mosha.com/msolap www.ralphkimball.com Hope that helps. Steve Hughes Magenic Technologies steve.hughes@magenic.com

RE: audit failed logins

NEWTONS2 is right. Profiler can help with this . For more information how to make profiles record sucessful and unsuccessful logins see http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/prodtech/dbsql/sql2kaud.asp

RE: Re: SQL2K SQL2K silent installation

I have found a solution for it. After the slient installation, you need to modify the licensing mode in registry to support per processor. Thanks again for your time.

RE: How to change Working Directory

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

RE: Running DTS packages from ASP

Here's the code that connects to the database Const DTSSQLStgFlag_Default = 0 Const DTSStepExecResult_Failure = 1 Dim oPkg, oStep, sErr, bSuccess Dim sServer, iSecurity, sUID, sPWD, sPkgName, sPkgPWD ' Get Form Variables sServer = Request.Form("txtServer") iSecurity = CInt("0" & Request.Form("optSecurity")) sUID = Request.Form("txtUID") sPWD = Request.Form("txtPWD") sPkgName = Request.Form("txtPkgName") sPkgPWD = Request.Form("txtPkgPWD") ' Validate Variables […]

You are a database administrator of a SQL...

RE: Catching an error from a trigger to a sp

You should be able to check the value of @@error from your stored procedure right after the insert or update statement

RE: LTRIM/RTRIM NOT TRIMMING

I think the problem in QA is setting the option to have column aligned in the result tab. Thanks for your response.

SQL Server Security: Fixed Database Roles

Brian is back with a new security article, this time working through the details of the fixed database roles. There are some important concepts here. In particular if you're not totally clear on the difference between dbo and db_owner, read this article.

RE: Determining the default value of a column

It's the Text property of the DMO column object's DRIDefault property. --Jonathan