Forum Replies Created

Viewing 15 posts - 1 through 15 (of 73 total)

  • RE: Flatfile generation on app server

    Thanks you opc..

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 23, 2012 at 12:46 pm

    #1463694

  • RE: how do in insert into table after splitting using tally?

    Garadin. I call you a magician. wonderful. works great.

    Yes, This is one time load. task accomplished

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    May 19, 2011 at 8:59 am

    #1327143

  • RE: Says invalid object name after renaming proc..

    OMG.........

    I figured it out.........The developer was writing stupid code inside proc which caused all these mess up.

    if you see the proc which i sent in my initial mail..there is a...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 12:16 pm

    #1293683

  • RE: Says invalid object name after renaming proc..

    am the db_owner...

    even i did renaming on other systems succesfully. i dont know what went erong this time....

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 11:57 am

    #1293671

  • RE: Says invalid object name after renaming proc..

    Even restart did not help...still the same error....:crying:

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 11:51 am

    #1293667

  • RE: Says invalid object name after renaming proc..

    Ninja..I tried clearing proc cache and that does not help..I might reboot in some time from now..

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 11:31 am

    #1293654

  • RE: Says invalid object name after renaming proc..

    Nope..It did not work this way too...:(

    Still the same error..

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 11:09 am

    #1293644

  • RE: Says invalid object name after renaming proc..

    I have saved copy of the script.

    I didnot understand manual deleting part. i have tried dropping and recreating , which does not worked.

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 11:01 am

    #1293642

  • RE: Says invalid object name after renaming proc..

    I have tried executing

    exec dbo.sproc_NR_EWMDupVIN...

    it says the same error..

    Invalid object name 'dbo.sproc_NR_EWMDupVIN'.

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 10:40 am

    #1293631

  • RE: Says invalid object name after renaming proc..

    /****** Object: StoredProcedure [dbo].[sproc_NR_EWMDupVIN] Script Date: 03/02/2011 12:03:00 ******/

    SET ANSI_NULLS OFF

    GO

    SET QUOTED_IDENTIFIER OFF

    GO

    Create PROCEDURE [dbo].[sproc_NR_EWMDupVIN]

    AS

    BEGIN

    declare @AlertMasterID int

    declare @ProcessingDate datetime

    declare @DealerID int

    declare @vin nchar(20)

    declare @DupFinancedDate...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 10:29 am

    #1293620

  • RE: Says invalid object name after renaming proc..

    yes ..dbo is the owner

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 10:25 am

    #1293617

  • RE: Row transpose

    Mark-101232 .. You rock...I was struggling with pivot..and you gave a solution by not using PIVOT..Thanks a lot mark....

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 2, 2011 at 5:56 am

    #1293439

  • RE: Row transpose

    I understand your suggestion regarding not to use in t-sql. But few things which are out of our control makes us to use these inside t-sql.

    I appreciate if you can...

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    March 1, 2011 at 1:38 pm

    #1293193

  • RE: Logshipping failure

    Thanks all..Restoring the latest full backup from source fixed the issue.

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    January 31, 2011 at 9:09 am

    #1280469

  • RE: Logshipping failure

    TYPE: oPERATINGSYSTEM COMMAND(Cmdexec)

    Run as: SQl server agent

    Command: "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\sqllogship.exe" -Restore 02443D0C-6EE6-4139-B9B9-6E272E0324B8 -server EBFFwoe3

    in view job history, error Message is..

    Executed as user: EBFFwoe3\SYSTEM. The step failed.

    -----------------------------------------------------------------------
    For better assistance in answering your questions[/url]
    Perforamance Issues[/url]
    Cross Tabs and Pivots[/url]
    Cross Apply[/url]
    The Numbers or Tally Table- Jeff Moden[/url]

    January 27, 2011 at 1:16 pm

    #1279343

Viewing 15 posts - 1 through 15 (of 73 total)