Forum Replies Created

Viewing 15 posts - 256 through 270 (of 341 total)

  • RE: Clarification Required in SSIS implementation

    Your 2nd requirement is where I'm hoping someone else can chime in. I have never had a requirement to do conditional control flow in an SSIS package. We have always...

  • RE: *= VS left outer join

    select col1,col2 from table1,table2

    where table1.col1*=table2.col2

    and table1.col4=table2.col4

    This one would be:

    select col1,col2

    from table1

    inner join table2 as innertable2 on table1.col4 = innertable2.col4

    ...

  • RE: *= VS left outer join

    select col1,col2 from table1,table2

    where table1.col1*=table2.col2

    You need to change this statement to (for 2005 and mode 90):

    select col1,col2

    from table1 left outer join table2 on table1.col1 = table2.col2

    I have this all over...

  • RE: Start Debug tries to build project???

    Does it work on another PC? Have you tried re-installing BIDS to see if the problem corrects itself?

  • RE: Clarification Required in SSIS implementation

    Your first requirement is easy. A Foreach Loop Container can be setup to pull all files (one at a time) from a particular directory you specify. Within that container, you...

  • RE: Post-SP2 implementation

    ahutch (5/15/2008)


    Is there any need to run sp_updatestats after upgrading from SP1 to SP2?

    What about DBCC_CheckDB?

    Anything else needed (or not) that I haven't mentioned?

    I personally haven't done either when I...

  • RE: IT and Musicians?

    Val Byref (5/15/2008)


    It's really the same kind of skill set -- the ability to imagine a finished work and then construct all the minutely detailed components acting together in concert...

  • RE: script out views in a database

    It is really the same in Query Analyzer. Right-click on the view and make the appropriate scripting selection and destination.

  • RE: script out views in a database

    Right-click on the View and select Script VIEW as > and make the appropriate selections in the next menu.

    I'm not positive but I assume at least DBO rights are necessary....

  • RE: License Tracking in SQL Server 2005

    Considering it does not track licensing on its own, I'm not sure what benefit you'll gain. If you have to manually enter it, whether into a table or the registry,...

  • RE: Encrypting Data

    Another thought would be doing a cost-benefit analysis of taking the "risk" to be encrypted or not. Of course, the risk if you are not encrypted is that the data...

  • RE: How do i set a default solution in SQL Server Management Studio

    The only option I can find is rather than opening SSMS first, just open the file and it will open in SSMS. The drawback is that it does not show...

  • RE: sql server 2005 memory usage

    coastliner (5/13/2008)


    What I need is to have the possibility to schedule backups...so I left active the SQL server Agent. Stop.

    BTW I was always told of a 4GB limit on 32bit...

  • RE: sql server 2005 memory usage

    Marios Philippopoulos (5/13/2008)


    jim.powers (5/13/2008)


    No, it was a 32-bit machine.

    Unless you enabled AWE, that's mathematically impossible.

    The 32-bit address space simply does not have the capacity to reach that kind of memory...

    I...

  • RE: sql server 2005 memory usage

    not since SP2, Maint plans no longer require SSIS

    That is certainly good to know! Interesting enough, though, even with SP2, it still stores them in SSIS.

Viewing 15 posts - 256 through 270 (of 341 total)