Forum Replies Created

Viewing 15 posts - 301 through 315 (of 921 total)

  • RE: HardQuery

    Unless you exclude (or include in your CategoryRelationship table) any heirarchies greater than two (grandparent), this will not be possible without some form of loop, be it a temorary stack...



    --Jonathan

    December 24, 2003 at 7:06 am

    #487735

  • RE: audit trail

    You can buy a product to do this, such as Entegra,OminiAudit, or VigilEnt.

    --Jonathan



    --Jonathan

    December 24, 2003 at 6:53 am

    #487733

  • RE: Public role

    From Chip Andrews' (SQLSecurity.com) lockdown script:

    

    USE msdb

    REVOKE execute on sp_add_job to public

    REVOKE execute on sp_add_jobstep to public

    REVOKE execute on sp_add_jobserver to public

    REVOKE execute on sp_start_job to...



    --Jonathan

    December 23, 2003 at 2:10 pm

    #487678

  • RE: Script out logins and users 

    

    Sub logins(Server As String, DB As String)

    Dim objServer As New SQLDMO.SQLServer

    Dim objDatabase As New SQLDMO.Database

    Dim objLogin As SQLDMO.Login

    Dim objUser As SQLDMO.User

    objServer.LoginSecure = True

    objServer.Connect Server

    Set objDatabase =...



    --Jonathan

    December 23, 2003 at 1:18 pm

    #487672

  • RE: Pervasive SQL

    Pervasive.SQL is actually built on top of the old Btrieve database. When Novell bought SoftCraft (the developer of Btrieve), they wanted a server-side RDBMS application (NetWare Loadable Module) implemented...



    --Jonathan

    December 23, 2003 at 12:14 pm

    #487661

  • RE: Help with Sql Select statement

    quote:

    I agree also with the normalization aspect as well.

    Unfortunatly sometimes in the real world (or at least my world ) we...



    --Jonathan

    December 23, 2003 at 9:13 am

    #487620

  • RE: Help with Sql Select statement

    I'm uncomfortable with this problem for a few reasons. First, this data is obviously not even in first normal form. This information should be in two tables, not...



    --Jonathan

    December 23, 2003 at 7:44 am

    #487591

  • RE: How to reduce TLog size?

    You need to wrap the active point of the log back to one of the first VLFs before you can delete subsequent VLFs. See the following article for an...



    --Jonathan

    December 23, 2003 at 5:57 am

    #487573

  • RE: Max Memory - Enterprise, W2K AS, W2003 EE

    quote:

    How much memory can SQL Server 2000 Enterprise Edition use when running on a Windows 2003 Enterprise Edition server?



    --Jonathan

    December 21, 2003 at 8:35 am

    #487362

  • RE: MSX Server error 14274

    http://support.microsoft.com/?id=281642

    --Jonathan



    --Jonathan

    December 21, 2003 at 8:05 am

    #487360

  • RE: Memory Management

    I suspect that the third-party package is using the server as more than just a database server, i.e. they're using it as a file server or application server. When...



    --Jonathan

    December 21, 2003 at 7:44 am

    #487359

  • RE: CODD's Rules - Term definition

    A language has a linear syntax if it can be invoked using character strings.

    A non-procedural (or declarative) language is one where the programmer need not determine exactly how to get...



    --Jonathan

    December 21, 2003 at 7:21 am

    #487358

  • RE: Finding only the modified rows

    Thanks, I needed the exercise. 

    

    DECLARE @cutoff datetime

    SET @cutoff = '20031101'

     

    SELECT pr.Pr_Id, Pr_Name, Su_Name, Tr_Name, PP_Price

    FROM Product pr JOIN Supplier su...



    --Jonathan

    December 21, 2003 at 6:04 am

    #487357

  • RE: Procudure in cache has parse and compile time

    http://support.microsoft.com/?id=243586

    --Jonathan



    --Jonathan

    December 19, 2003 at 11:45 am

    #487268

  • RE: Cast and Convert Problem in SQL server 2000

    If you are storing them as eight characters (should use char(8), not varchar(8), BTW), then are they something like '19/12/03' or something like '20031219'? The latter is the ISO...



    --Jonathan

    December 19, 2003 at 11:40 am

    #487266

    • Viewing 15 posts - 301 through 315 (of 921 total)