Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 13,463 total)

  • RE: mail merge in sp

    similar to A word document, you can set up a template with something that represents the items that would be substituted.

    then you need a cursor/loop for each email you plan...

  • RE: Excel 64 bit driver

    Koen Verbeeck (1/15/2013)


    That's great stuff Lowell, I didn't know you could force the installation of the provider.

    Thanks Koen!

    I've bean my head against that 64 bit installation rock a few times,...

  • RE: Lock tabels

    Krasavita (1/15/2013)


    Thank you,How you move the table into a separate filegroup?

    peek at the code i posted, which creates a new table in the filegroup.

    for an existing table, you can Use...

  • RE: Excel 64 bit driver

    I've been in on a few other ACE /EXCEl threads, and have my comments saved from when i thouroughly tested this and got it to work:

    myself(Lowell)


    a couple of prerequisites:

    install...

  • RE: problem using bcp to exporto to xml bad format

    Want a cool sig is correct. what was produced is valid XML, just not prettified for readability.

    SQL2000 used to have trace flag 257, which would format the xml with extra...

  • RE: Lock tabels

    here's something i put together for a different post that was talking about setting a table to read only:

    this is not copy/paste/execute code, but rather, amodel to use to modify...

  • RE: Regular Expressions

    ok i'm not sure if this is doing a valid performance test or not;

    i had initially thought that creating an object would be slower than regex, but that's not what...

  • RE: orphaned extended properties in SQL

    it depends;

    you cannot create an extended property that points to an object(includes the parameters for level0type/@level1type/@level2type) without the object actually existing.

    an example:

    EXEC sys.sp_addextendedproperty

    @name=N'ColumnDescription',

    @value=N'Credit...

  • RE: Error creating new db; "application is not configured for this database"

    cummings.rd (1/14/2013)


    I may not understand correctly what you are stating so please bear with me. The database I am transferring isn't empty. It has lots of information across...

  • RE: Error creating new db; "application is not configured for this database"

    i'm guessing that the application does not expect an empty database...it expects a database with specific tables, procedures, views etc to exist, but probably many of those objects are allowed...

  • RE: trigger that will update one table when a record is updated in another

    doesn't look quite right to me.

    It looks to me like you are missing a relationship between t he two tables.

    maybe the PO_Number exists between the two table,s and you need...

  • RE: Regular Expressions

    OK here's a starter kit for you in C# for SQL2008.

    the usual caveats about downloading strangers code and all that applies, obviously.

    don't deploy code you don't fully understand, and only...

  • RE: Regular Expressions

    this is the code for the CLR i use; It leverages the the .Net Mail object, which has some pretty expansive, built in rules for handling email addresses.

    If you are...

  • RE: Excel Source - validation error - due to file already open for edit by different user

    i've always done a file task to copy an excel to a new file with a name unique to the process, so i was sure my process was the one...

  • RE: All server trigger creates virtual paging file?

    maybe he's confusing a virtual page with a server side trace and the possibility of a log file that has no limitations on the size or number of files...

Viewing 15 posts - 4,141 through 4,155 (of 13,463 total)