Forum Replies Created

Viewing 15 posts - 1,636 through 1,650 (of 1,790 total)

  • RE: Prob with Mail following DTS Pkg Send Mail Fail

    Not yet, will do and let you know how I make out. Thanks Steve!

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 23, 2002 at 1:32 pm

    #422549

  • RE: Prob with Mail following DTS Pkg Send Mail Fail

    Yes, this is to get SQL Mail working again and both the Server and the Agent are working fine except with mail. I can still mail from the client directly,...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 23, 2002 at 1:21 pm

    #422546

  • RE: Table Size issue

    The sp_spaceused system stored proc will bring back everything you want and the sp_MSforeachtable will let you get all the tables in the current db at once. I'm sure that...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 17, 2002 at 3:25 pm

    #422290

  • RE: Tr. Log File Corrupt (HD fail) detached cant atach

    Try using sp_attach_single_file_db and see how that goes. This will eliminate the transaction log from the attach and "should" work.

    Good luck.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 17, 2002 at 2:02 pm

    #422286

  • RE: xp_sendmail attachment open failure

    Should have stuck with my gut feeling at first. Thanks for letting us know what the problem was.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 16, 2002 at 2:02 pm

    #422252

  • RE: xp_sendmail attachment open failure

    DUH David! Sorry I didn't catch this before but your path to the file has spaces in it and that won't fly. You will have to put quotes around the...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 16, 2002 at 9:58 am

    #422249

  • RE: ex_sendmail function problem

    Is the wilda account listed a valid email account. If this account is not on your domain, then you should specify the smtp address such as your.name@yourdomain.com

    Other than that email...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 16, 2002 at 9:44 am

    #422247

  • RE: How do I copy a SQL database?

    You have to use the "with move" option. However, if you can detach as Oleg has offered, then the files you would look for would be the .MDF and .LDF...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 16, 2002 at 7:20 am

    #422242

  • RE: How do I copy a SQL database?

    Backup from current location and restore to new location.

    Should be all three options in three posts.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 16, 2002 at 7:07 am

    #422237

  • RE: FK constraint error,Urgent!!!!!!!!!!!!!!!!!!!!!!!!

    Are you sure that another table is not referencing this table as a foreign key and by truncating it you would be causing a constraint there?

    Right click on the...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 15, 2002 at 11:52 am

    #422209

  • RE: Restore 2 Tables From FULL BACKUP

    Unfortunately that's not possible. Ultimately your best bet from what you have described is to restore to another "mock" database and copy tables back over.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 15, 2002 at 11:20 am

    #422207

  • RE: Tame Those Strings! Part 5 - Proper Casing Strings

    I just had to search this out so that I could work through this issue. Thanks for doing much of the leg work for me.

    OBTW - Great Article /...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 15, 2002 at 9:54 am

    #422202

  • RE: xp_sendmail attachment open failure

    Sounds like permissions or path may be inaccurate. If you post the code that would be helpful. Thanks.

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 15, 2002 at 9:27 am

    #422201

  • RE: dts and email

    Assuming that your global variable is formatted to reflect the proper email address you could use xp_sendmail and then set the @recipients variable in that procedure to equal your global...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 15, 2002 at 8:10 am

    #422199

  • RE: Copying data using DTS

    I have found that task to be unreliable. It gets more reliable if you go through the options (options button on transfer tab)and deselect the "transfer database users and database...

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

    January 9, 2002 at 2:14 pm

    #422032

Viewing 15 posts - 1,636 through 1,650 (of 1,790 total)