Forum Replies Created

Viewing 15 posts - 2,236 through 2,250 (of 2,462 total)

  • RE: Simple and weird problem in OLE DB source component

    it got corrected automatically , i closed the project and restarted it again, and didnt find the problem dont know it got resolved ..its working fine now

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: MSDB..sysjobhistory issue

    thanks a lot

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Problem with Linked Sever

    mahesh,

    my understanding says, your "csd\jason" user must have equal rights on both the server. (according to ur settings db_owner on both the servers)

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Problem with Linked Sever

    thanks for it

    please tell me we have another option like

    1. be made without using security context

    2. be made using login's current security context

    what do we understand...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Problem with Linked Sever

    Nagaraj

    as you have told that if we have different password for sa account , it will fail

    In my one of my environment, we have same sa password on...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Strange Execution Plan !!!!!!!!!!!!

    thanks a lot

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Strange Execution Plan !!!!!!!!!!!!

    As per ur suggestion , i have select only required columns ( in below query)

    select acct_id , acct_num, acct_name from tmp_account where

    acct_stub = 'E0519F76-94DB-411A-8FAA-0CDA6AF046C2'

    and acct_name = 'event003'

    but stil...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Strange Execution Plan !!!!!!!!!!!!

    ok thanks

    how can i avoid

    key lookup

    give me the query

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: link or website for Performance tuning and optimizing query

    thanks

    but i am talking about tuning Sql queries

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Problem with Linked Sever

    if possible set up linked server again

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Check file existence by command prompt in sql server

    my requirement is only to check the existence of file

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Check file existence by command prompt in sql server

    Thanks to all you put their efforts , i got the resolution of it

    below :

    declare @nRetVal int

    SET @nRetVal = ''

    SET @filename = @share_unc + '\' + @filename

    EXEC @nRetVal...

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Crazy and Weird Output !!!!!!!!!!!!!!!

    thanks

    but any alternative for it ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Using "Sql server" option for Configuration type

    Can anyody help me ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • RE: Playing with LEFT JOIN

    Thanks 🙂

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 15 posts - 2,236 through 2,250 (of 2,462 total)