Forum Replies Created

Viewing 15 posts - 511 through 525 (of 789 total)

  • RE: Virtual Memory exceed in new

    Don't do double post!

    All reply should be in this post:

    http://www.sqlservercentral.com/Forums/Topic627895-146-1.aspx

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 31, 2008 at 2:25 am

    #919503

  • RE: Virtual Memory exceeds in new

    We have double post all reply should be in this post:

    http://www.sqlservercentral.com/Forums/Topic627895-146-1.aspx

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 31, 2008 at 2:23 am

    #919502

  • RE: How can i drop database

    jaydeep (12/30/2008)

    Yes I found the same one.

    Thank you.

    Cheers,

    Jaydeep

    Ok...can you post the info how did you find the solution!? - just for info ...couz we here are trying everyday to help...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 6:47 am

    #919002

  • RE: Sql 2005 to 2000 restore

    I agree with Gila's solution ...this is the best way you can do!:cool:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 6:28 am

    #918984

  • RE: Active Logins

    Raghavender (12/30/2008)

    Apart this,

    can we change the active logins to inactive ?

    Simple no!

    These info are coming from Master database sys tables! You should write other code to enable or disable users...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 5:56 am

    #918969

  • RE: Active Logins

    Raghavender (12/30/2008)

    Hi All,

    can any body provide me How to find out Active and inactive logins of a SQL server logins.

    Inactive logins means the logins which are not using for more...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 5:35 am

    #918954

  • RE: altering table taking ages in SSMS

    I think better is to do with T-SQL !

    Simple:

    First Drop Constraint then

    Add Constraint again

    ALTER TABLE Your_Table

    DROP CONSTRAINT constraint_name;

    ALTER TABLE Your_Table

    ADD CONSTRAINT constraint_name FOREIGN KEY (your_field) REFERENCES Ref_Table_Name(Ref_field) ON DELETE...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 3:26 am

    #918896

  • RE: Joining 2 Table Records

    dhunted2000 (12/30/2008)

    hehe..

    i guess that solves my problem..

    thanks to you guys..

    Anyway ...you are welcome!

    😛

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 2:53 am

    #918885

  • RE: altering table taking ages in SSMS

    How many records do you have in you table!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 2:26 am

    #918873

  • RE: Joining 2 Table Records

    I don't know what is your code but you can look here that everything is OK!

    CREATE TABLE TAB2

    (

    DATE DATETIME,

    EMP INT

    );

    CREATE TABLE TAB1

    (

    DATE DATETIME

    );

    INSERT INTO TAB2

    SELECT '01/01/2008', 123

    UNION ALL

    SELECT '02/01/2008', 123

    UNION...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 30, 2008 at 2:21 am

    #918868

  • RE: Linked Server to MS Access 97 Database Problem

    Patrick Womack (12/29/2008)

    Thanks, Dugi.

    The Access database is not password protected. The linked server works sometimes (once a day), but it fails often.

    So do you have still problem with linking...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 29, 2008 at 9:11 am

    #918421

  • RE: Stored procedures with output parameters

    dobinf (12/29/2008)

    ok I am new to this site. Can you please solve my problem?

    Sure that you are new here and you are welcome ... but please read carefully all the...

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 29, 2008 at 6:44 am

    #918367

  • RE: Autoincrement variable

    Chirag (12/2/2008)

    i think i got this from some code written by Jeff Modem 🙂

    Yes he has skills to generate the code in professional way, simply he's Code Generator!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 29, 2008 at 6:41 am

    #918364

  • RE: How to create an extract file in .ovl format from SQL2005 db

    Yea ... no application which support this file format ...and from google results have info something with dos!

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 29, 2008 at 6:36 am

    #918360

  • RE: Linked Server to MS Access 97 Database Problem

    Is the Access file with password!?

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    December 29, 2008 at 6:31 am

    #918358

Viewing 15 posts - 511 through 525 (of 789 total)