Forum Replies Created

Viewing 15 posts - 5,551 through 5,565 (of 7,164 total)

  • RE: Help trying to flatten an EAV table?

    al_nick (7/12/2011)

    Hi all-

    I have the following EAV table based on exam data which we are receiving:

    CREATE TABLE [dbo].[Exams](

    [examid] [int] NULL,

    [entity] [varchar](255) NULL,

    [value] [varchar](255) NULL,

    [examrowid] [int] NULL

    ) ON [PRIMARY]

    GO

    SET ANSI_PADDING OFF

    GO

    INSERT...

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

    July 12, 2011 at 3:35 pm

    #1351918

  • RE: Running Stored Procedures

    Jeffrey Williams-493691 (7/12/2011)

    I would recommend SSIS also - and I don't see Service Broker as the right solution. I would think service broker is more geared toward event driven...

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

    July 12, 2011 at 2:43 pm

    #1351896

  • RE: Running Stored Procedures

    Elliott Whitlow (7/12/2011)

    opc.three (7/12/2011)

    If you're ready for a new challenge asynchronous behavior can be achieved purely in T-SQL using Service Broker.

    I absolutely agree it can be done with service broker,...

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

    July 12, 2011 at 2:28 pm

    #1351885

  • RE: No error for missing Linked Server?

    This script from Lowell is pretty slick:

    http://www.sqlservercentral.com/Forums/FindPost1140415.aspx

    It's better than what I had in place. It only needs a few tweaks. I gave it a spin and the I saw it...

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

    July 12, 2011 at 2:13 pm

    #1351876

  • RE: set variable from openquery

    That's scary, we even picked the same alias and variable names :blink:

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

    July 12, 2011 at 2:00 pm

    #1351865

  • RE: Running Stored Procedures

    If you're ready for a new challenge asynchronous behavior can be achieved purely in T-SQL using Service Broker.

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

    July 12, 2011 at 1:53 pm

    #1351861

  • RE: SSIS: What's New in Denali

    Thanks for sharing the links. They had me at "Undo/Redo" 😀

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

    July 12, 2011 at 1:51 pm

    #1351859

  • RE: set variable from openquery

    Try this form (changes to your original query bolded):

    DECLARE @cnt INT

    SELECT @cnt = cnt

    FROM OPENQUERY(SDW, 'SELECT count(*) as cnt

    ...

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

    July 12, 2011 at 1:43 pm

    #1351855

  • RE: WMI Event Watcher Task

    sandyinfowave (7/12/2011)

    Hello guys,

    I am using WMI Event Watcher Task to watch for any files placed in the folder....How does it actually work?? Should the package be running all the time

    Thanks

    Yes,...

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

    July 12, 2011 at 1:31 pm

    #1351844

  • RE: Remove article from existing publication, does it require a new snapshot?

    David Benoit (7/12/2011)

    Yes, force_invalidate_snapshot = 1 is identical to the warning in the GUI. Only run the sp_droparticle statement though not the sp_dropsubscription statement that you have. You really don't...

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

    July 12, 2011 at 1:17 pm

    #1351828

  • RE: Remove article from existing publication, does it require a new snapshot?

    Thanks for the reply David. I would like to do this in T-SQL if possible. Would running this on the publisher instance be equivalent to the steps you provided for...

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

    July 12, 2011 at 12:39 pm

    #1351813

  • RE: A type of string search.

    This is a first for me...I never before heard anyone say they used the "English Query" sub-system. I am curious as to why it was dropped from the product since...

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

    July 12, 2011 at 10:30 am

    #1351755

  • RE: Query plan issues after 2000 -> 2008R2 migration

    Dean Cochrane (7/12/2011)

    Syed Jahanzaib Bin hassan (7/12/2011)

    Change the compatibility mode to 100 and rebuild the indexes and update the stats also,did you ?

    I haven't tried that - change compatibility to...

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

    July 12, 2011 at 9:11 am

    #1351653

  • RE: Execute Permissions for Stored procedure

    opc.three (7/11/2011)

    Raghavender (7/8/2011)

    Hi All,

    We have a user for a database. Here we need that user should have exec permissions on all stored procedure.

    If any new stored procedure created, that user...

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

    July 11, 2011 at 9:32 pm

    #1351406

  • RE: Execute Permissions for Stored procedure

    Raghavender (7/8/2011)

    Hi All,

    We have a user for a database. Here we need that user should have exec permissions on all stored procedure.

    If any new stored procedure created, that user should...

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

    July 11, 2011 at 5:05 pm

    #1351377

Viewing 15 posts - 5,551 through 5,565 (of 7,164 total)