Forum Replies Created

Viewing 15 posts - 3,481 through 3,495 (of 7,164 total)

  • RE: Upgrading from SQL Server 2000

    It is nice you can leverage some of the T-SQL improvements now that you have completely moved off 2000. However, while your perspective might be tilted towards "we just moved...

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

    July 30, 2012 at 9:33 am

    #1519238

  • RE: RPC:Completed

    Sounds odd. Can you please post more from the trace? Including the text data from the entries for the proc calls?

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

    July 30, 2012 at 9:25 am

    #1519236

  • RE: Script Task to Format Column Headings to an Excel Spreadsheet

    GBeezy (7/30/2012)

    Thanks for the reply OPC...

    I did try that method as I researched out to get this done. My problem that I had with it, is that the File...

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

    July 30, 2012 at 9:22 am

    #1519233

  • RE: SQL Server Version History

    Cool doc. Thanks for sharing it. The Wikipedia page on SQL Server has a lot of this with background info but where it tries to be more detailed it has...

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

    July 30, 2012 at 9:05 am

    #1519214

  • RE: Deadlocks: Determining the victim with little info from Profiler...

    Please save off the deadlock graph and attach it to this thread.

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

    July 30, 2012 at 7:28 am

    #1519137

  • RE: Transaction log failure

    shrishasqldba (7/28/2012)

    xecuting query "DECLARE @Guid UNIQUEIDENTIFIER

    EXECUTE msdb..sp".: 100% complete End Progress Error: 2012-07-29 15:00:32.68

    Code: 0xC002F210 ...

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

    July 29, 2012 at 9:25 pm

    #1518986

  • RE: Setting up log shipping for multiple databases

    stephen.chapman 77519 (7/24/2012)

    Hi,

    I am new to this forum but I have just had to deal with setting up log shipping for a DR site which would have meant setting this...

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

    July 29, 2012 at 9:08 pm

    #1518985

  • RE: Inserting VBA Procedure into CSV Files Using SSIS

    You're welcome.

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

    July 29, 2012 at 6:33 pm

    #1518981

  • RE: Today's Random Word!

    L' Eomot Inversé (7/29/2012)

    Quiet here. Where is everyone?

    A word:- Frustration.

    http://www.xkcd.com/844/

    One of my favorites! Was actually my desktop wallpaper for a while 😎

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

    July 29, 2012 at 12:14 pm

    #1518955

  • RE: CREATE USER FOR | FROM

    Nothing.

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

    July 29, 2012 at 12:07 pm

    #1518954

  • RE: Inserting VBA Procedure into CSV Files Using SSIS

    Mordred (7/28/2012)

    Alright, I think the issue might be that I have some duplicate values in the csv file trying to be passed into the PK fields. Is the csv...

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

    July 28, 2012 at 11:19 am

    #1518885

  • RE: Script Task to Format Column Headings to an Excel Spreadsheet

    If you're not versed in programming in C# (SSIS 2008+) or VB.NET against the Office Object Model, or at all, then I would recommend you create an empty Excel Workbook...

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

    July 27, 2012 at 11:54 am

    #1518676

  • RE: Importing SQL Server Data Using SSIS - Which Option is Fastest?

    Welsh Corgi (7/26/2012)

    Thanks for all of the ideas.

    I got audited today but an outside firm and I got dinged for having the Staging and Data Warehouse on the same server....

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

    July 26, 2012 at 9:24 pm

    #1518262

  • RE: T-SQL (Proc) Conversion to SSIS!

    Jeff Moden (7/26/2012)

    opc.three (7/26/2012)

    SSIS places us squarely inside the data pipeline to handle those rows in memory however we like: writing them to a file, discarding them without writing them...

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

    July 26, 2012 at 9:22 pm

    #1518261

  • RE: Importing SQL Server Data Using SSIS - Which Option is Fastest?

    Matt Miller (#4) (7/26/2012)

    opc.three (7/26/2012)

    Welsh Corgi (7/25/2012)

    I was trying to determine which option for importing SQL Server into SQL Server was fastest.

    I would have assumed that a Stored Procedure would...

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

    July 26, 2012 at 6:33 pm

    #1518230

Viewing 15 posts - 3,481 through 3,495 (of 7,164 total)