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...

    May 10, 2012 at 5:12 am

    #1485605

  • 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...

    May 10, 2012 at 3:35 am

    #1485554

  • 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...

    May 9, 2012 at 4:48 am

    #1484971

  • 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...

    May 9, 2012 at 4:35 am

    #1484962

  • 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,...

    May 9, 2012 at 3:55 am

    #1484950

  • 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. ...

    May 9, 2012 at 3:48 am

    #1484948

  • 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 😀

    May 9, 2012 at 3:36 am

    #1484947

  • 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...

    May 9, 2012 at 2:37 am

    #1484928

  • RE: Executing Errors

    manju.ccc (5/9/2012)

    Thank you guys.

    I solved the porblem.

    :-D:-D

    Care to explain what was the issue 😉 ?

    May 9, 2012 at 2:31 am

    #1484926

  • 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...

    May 9, 2012 at 2:24 am

    #1484924

  • 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...

    May 8, 2012 at 5:06 am

    #1484429

  • RE: SQL developer

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

    May 4, 2012 at 6:38 am

    #1483497

  • 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....

    May 4, 2012 at 4:23 am

    #1483455

  • 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...

    April 27, 2012 at 5:18 am

    #1480295

  • 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...

    April 27, 2012 at 5:04 am

    #1480288

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