Forum Replies Created

Viewing 15 posts - 61 through 75 (of 131 total)

  • RE: Confused related to service pack of sql server

    both are correct

    in the first query o\p

    Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2...

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: report on jobs

    try sp_who4 active SP

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: percentage of backup

    backup database dbname to disk='path' with

    stats=1

    stats indicates percentage

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: need help for 70-443 certfication

    can anybody tell me what is the time duration for 70-443 exam?

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: need script to generate load on tempdb databse!!!

    OK

    i m fine with this

    Thanx a lot to both of u

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: need script to generate load on tempdb databse!!!

    RBarryYoung (2/6/2010)


    Well, I am no fan of loops, but since the goal IS to slow things down, this ought to do it:

    CREATE PROC EXERCISE_TEMPDB_SILLY AS

    SET STATISTICS TIME ON

    SET STATISTICS IO...

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: Moving Master database ldf file

    7th step is not required in ur case

    it is required while restoring master database backup.

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: XP_CMDSHELL

    can u specify the error u r getting?

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: nice topic for debate

    but i haven't seen replication from sql 2000 to sql 2005

    also there is no primary key on that table so its a difficult option

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: Snapshot Replication cant copy the tables from instance 1 to instance 2

    for configuring replication table must have primary key created on it.

    do ur table have it(primary key)?

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: SQL Server 2005 installation on different configurations.

    for more details abt WOW visit foll link

    http://blogs.msdn.com/gauravseth/archive/2006/04/24/582091.aspx

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: SQL Server 2005 installation on different configurations.

    attached file will help u for 1st question(details sql support for memory)

    2. u cannot install 64 bit SQL version on 32 OS platform.

    3. this is a component which helps 32...

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: Regarding SQL Server certification.

    see, there are different paths for certification.

    http://www.setfocus.com/certify/mcitp.aspx

    this link will tell u abt ur certification.

    just decide where u want to go.

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: nice topic for debate

    Ok

    Let me tell u my scenario.

    we hav 1 sql server 2000(srv1) on which database db1 is located which is OLTP DB,

    in that there is table tb1 in which frequent inserts...

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

  • RE: nice topic for debate

    any opinions?

    plz reply

    Sanket Ahir
    Don't run behind the success, Try to be eligible & success will run behind u......

Viewing 15 posts - 61 through 75 (of 131 total)