Forum Replies Created

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

  • RE: Deploying SQL 2012 client

    it looks to me that on my 2012 DVD, you could simply grab the 58 meg MSI found here:

    {YourDrive} X:\x64\Setup\sql_ssms.msi, right?

  • RE: Copy Database Wizard

    ok my memory is solid, even if my confidence in it is not:

    http://www.sqlmatters.com/Articles/Creating%20a%20copy%20only%20backup%20to%20avoid%20breaking%20a%20backup%20chain.aspx

    Important : You might have noticed that I've not mentioned transaction log backups or log chains at all....

  • RE: Copy Database Wizard

    Gazareth (1/16/2013)


    Ha, beat me to it 🙂

    lol fast fingers today my friend,, but am i correct about a full backup not breaking the log chain?

  • RE: Copy Database Wizard

    As I understand it, a full backup will never break the log chain .

    for me, i just do a backup with copy only for these situations.

    BACKUP DATABASE [SandBox] TO ...

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

    cummings.rd (1/16/2013)


    Hi

    The DB I restored is 8.25 MB; I use SQL management studio 2008, I set the options for the restore as follows...

    Overwrite existing database WITH REPLACE

    Leave db ready...

  • 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...

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