Forum Replies Created

Viewing 15 posts - 6,136 through 6,150 (of 7,164 total)

  • RE: SQL Script to DELETE FOLDERS?

    Crispin Proctor (6/10/2011)

    You could use a pretty simple command line delete via xp_cmdshell.

    xp_cmdshell is disabled on all systems by default since SQL 2005 for a reason. Can it be properly...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 12:37 pm

    #1337196

  • RE: DTS vs. SSIS Row-End Detection

    Craig Farrell (6/10/2011)

    I've ended up turning those last 3 columns into a single column as far as metadata is concerned and shoving the entire process through a synchronous script component.

    It's...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 11:50 am

    #1337171

  • RE: The multi-part identifier could not be bound.

    JAYANTH KURUP gave you a solution but might I suggest you use MERGE instead. It looks strange at first but once you learn the syntax it becomes easy, plus it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 11:42 am

    #1337163

  • RE: DTS vs. SSIS Row-End Detection

    Phil Parkin (6/10/2011)

    I'm interested to know how you avoided getting a meta-data error as a result of the expected columns being missing on the dodgy row?

    Guessing a little but it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 11:16 am

    #1337159

  • RE: DTS vs. SSIS Row-End Detection

    Craig Farrell (6/9/2011)

    In DTS, these final columns were simply NULLS, it detected end of row correctly, and moved on with the next row.

    In SSIS, It's not detecting the {CR}{LF} properly,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 11:14 am

    #1337157

  • RE: Security problem arised while preparing for use of 'Cross Database Ownership Chaining'

    carsten.jorgensen (6/10/2011)

    In fact, we tried to reproduce the problem at our test environment by restoring a backup of both databases involved. We used a fresh backup of DBX (the unchanged...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 10:55 am

    #1337134

  • RE: Create a look up in SQL similar to HLookup in Excel

    Jnrstevej (6/10/2011)

    Thanks for the post it worked perfectly

    Double happiness 😀

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 9:25 am

    #1337070

  • RE: How do you avoid dynamic SQL with this code?

    John, Consider asking for a change to a typed input parameter. A lot of the validation logic will then vanish (Edit: as was previously stated, wasn't trying to be a...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 9:10 am

    #1337061

  • RE: Security problem arised while preparing for use of 'Cross Database Ownership Chaining'

    carsten.jorgensen (6/10/2011)

    Thank you for your suggestions.

    Yes - The synonym in db DBX is in a schema owned/authorized by dbo.

    And I do understand why you are suggesting that even DBX should...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 8:29 am

    #1337036

  • RE: Insert loop

    Crispin Proctor (6/10/2011)

    can I add, bcp looks cooler when in full screen. More so if you star at it intently and mutter when strangers walk by :hehe:

    I win 😉

    I...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 7:49 am

    #1336999

  • RE: Insert loop

    My normal approach is to split the file with winrar into 100MB chunks and repair volumes. Makes it easy to copy the file and if there is a problem, winrar...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 7:21 am

    #1336967

  • RE: Insert loop

    Crispin Proctor (6/10/2011)

    as has been suggested, why why why touch the source table again.

    What you are doing is telling 10000 people to step forward, checking to see you've not spoken...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 10, 2011 at 6:26 am

    #1336921

  • RE: Security problem arised while preparing for use of 'Cross Database Ownership Chaining'

    carsten.jorgensen (6/9/2011)

    Hi guys,

    We did some changes to our production SQL server instance a couple of days ago.

    After the changes were applied, it turned out that a specific application failed and...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 9, 2011 at 4:50 pm

    #1336774

  • RE: SQL server

    sqlfriends (6/9/2011)

    I'm trying to figure out some license issues.

    I know if only client tool like sql management studio is installed, it will not require license.

    how can I know if it...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 9, 2011 at 4:30 pm

    #1336768

  • RE: update constraint

    Chances are the constraint was created as a named-default in Tab1 and an unnamed-default in Tab2. It may have gone something like this:

    CREATE TABLE dbo.Tab1

    (

    [ToDate] [datetime] NOT NULL

    ...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    June 9, 2011 at 2:38 pm

    #1336729

Viewing 15 posts - 6,136 through 6,150 (of 7,164 total)