Forum Replies Created

Viewing 15 posts - 271 through 285 (of 644 total)

  • RE: Triggers

    maheshkrishnas (5/7/2012)


    Hi all,

    I am new to sql server, How to write a trigger which stops the DML operation on a table for particular time...

    Can anyone help on this......

    As suggested...

  • RE: Sp_Helptext not working properly

    panwar.jt (5/10/2012)


    What is difference between "Sp_Helptext" and "generating script using right click on stored procedure and click on modify" script.

    In few case both option giving different result set in case...

  • RE: SQL is running on only one node in the cluster. Should be running on two nodes in Active\Active configuration.

    jyoti.patel (5/9/2012)


    Hi All,

    Two sql server 2005 instances are configured by Active\Active cluster configuration and working fine but every day we dont know what happen i saw the email like"SQL is...

  • RE: Replace the Linked server

    Sony Francis @EY (5/9/2012)


    Any way other than replication ?

    Replication requires additional hardware( subscriber and distributer server). Expensiveeee!!!!!!!!!

    Seriously ??? You said that you are using linked server already to get...

  • RE: SSIS error ORA-00942: table or view does not exist.........(Although It does).

    shailesh.thapliyal (5/9/2012)


    Hello All,

    "failed with the following error: "ORA-00942: table or view does not exist". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameter not set correctly,...

  • RE: Replace the Linked server

    Sony Francis @EY (5/9/2012)


    Our company has used Linked server to get the other db server data . Now we are trying to replace the linked server with SSIS package. ...

  • RE: TYpes of formatting and conversion functions

    ramrajan (5/8/2012)


    asa

    I think he wanted to write asap, but before writing "p" he got something even more important to do 😀

  • RE: Query perform differently on 2 different server with identical setup

    andymay-496937 (5/8/2012)


    I have a user report that runs in > 1 minute in one environment and takes over 22 minutes???

    The 2 servers are built the same, 1 is live the...

  • RE: Executing Errors

    manju.ccc (5/9/2012)


    Thank you guys.

    I solved the porblem.

    :-D:-D

    Care to explain what was the issue 😉 ?

  • RE: cant get backup on drive C:\

    vahid.arr (5/9/2012)


    I write this query for getting backup of DB.when i want to save it on Drive c or desktop it give me error but on other drive it complete...

  • RE: Output to CSV or txt file from Query Window

    nick.mcdermaid (5/8/2012)


    "Doing a bcp will not be possible as i will not get permission for xp_cmdshell"

    What about simply creating a SQL Server Job with a step of type CmdExec to...

  • RE: SQL developer

    Yes, why not. Keep learning as much as you can :-).

  • RE: SQL developer

    SQL Developer's work is to write sql queries for differnt processes/applications. It includes writing stored procedures, triggers, functions etc. You'll need to learn the sql syntaxes to write the queries....

  • RE: can i use replication ? what is your idea?

    Larry Page(Ehsan.Akbar) (4/27/2012)


    thank you .

    before i thought we can use linked server for increasing performance.

    so suppose you have a huge data like google ,how you can get best performance?

    what is...

  • RE: can i use replication ? what is your idea?

    Larry Page(Ehsan.Akbar) (4/27/2012)


    vinu512 (4/26/2012)


    Larry Page(Ehsan.Akbar) (4/26/2012)

    what about update?

    You need performance...right??

    The best performance you can get is by getting all the data on 1 server and then perform whatever actions you...

Viewing 15 posts - 271 through 285 (of 644 total)