Forum Replies Created

Viewing 15 posts - 271 through 285 (of 290 total)

  • RE: Using FTP in a DTS

    Great question. This problem was resolved in Service Pack 1 for SQL Server 2000. Make sure you install it on the client executing the package as well. ...

    Brian Knight
    Free SQL Server Training Webinars

    July 17, 2001 at 9:45 pm

    #417150

  • RE: Estimating space usage

    quote:

    I've got ERwin and have no clue how to use it. I though it just did schema layouts easyer for you.

    Brian Knight
    Free SQL Server Training Webinars

    July 17, 2001 at 7:03 pm

    #417145

  • RE: Estimating space usage

    I'm working on an article next week about this actually. It'll be up on Monday. If you have a general idea about how many records you'll be receiving each...

    Brian Knight
    Free SQL Server Training Webinars

    July 17, 2001 at 5:50 pm

    #417140

  • RE: Encrypting Data With the Encrypt Function

    quote:

    Encrypt function in T-SQL is fine what about Decryption of encrytion columns.

    kindly tell us how to do it!

    Brian Knight
    Free SQL Server Training Webinars

    July 16, 2001 at 7:23 am

    #417085

  • RE: Auto logoff of users

    quote:

    We have a data warehouse with olap cubes. We update the data nightly starting at 7pm-?. I would like to block the...

    Brian Knight
    Free SQL Server Training Webinars

    July 11, 2001 at 7:37 am

    #417027

  • RE: DTS Query using Global Variable

    Are you using SQL Server 2000 or 7.0? There's a huge difference when you deal with this topic. This is a great question though and should be fun....

    Brian Knight
    Free SQL Server Training Webinars

    July 10, 2001 at 10:30 pm

    #417022

  • RE: Securing DTS packages

    You may have read it from this tip:

    http://www.sqlservercentral.com/columnists/bknight/dtslockdown.asp

    You're right on with the stored procedures you need to deny. Of course, simply placing owner and user passwords will take care...

    Brian Knight
    Free SQL Server Training Webinars

    July 10, 2001 at 10:23 pm

    #417019

  • RE: Any better tools to develop packages (3rd pty)?

    quote:

    Are all of these codepage, locale ID, sorting differences transparent to DTS, or is that going to create any issues in actually...

    Brian Knight
    Free SQL Server Training Webinars

    July 10, 2001 at 2:16 pm

    #417002

  • RE: Determining Standard or Enterprise Installed

    I missed the second part of your question...sorry! You can do the upgrade to 2000. Just make sure you backup all the databases before the upgrade.

    Brian Knight
    Free SQL Server Training Webinars

    July 10, 2001 at 11:08 am

    #416993

    • Viewing 15 posts - 271 through 285 (of 290 total)