Forum Replies Created

Viewing 15 posts - 691 through 705 (of 789 total)

  • RE: Deleting data in tables

    CREATE PROCEDURE USP_BOOM_DATA

    AS

    DELETE FROM TABLE_NAME1

    DELETE FROM TABLE_NAME2

    .

    .

    .

    .

    DELETE TABLE_NAME100

    after that you can call this procedure

    EXEC USP_BOOM_DATA

    But if you have the table with Primary Key and it's sure that you...

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

    July 17, 2008 at 11:37 am

    #844558

  • RE: Datafile.MDF out of space

    Interesting your mdf file is 38 ~ 39 MB and your C drive is out of space so the D drive has 170 GB!!! What do you have in...

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

    July 17, 2008 at 7:41 am

    #844382

  • RE: SQL Server Authentication problem(SQL server 2005)

    Check the Shared Memory is enable in your SQL Server Configuration Manager

    Start->All Programs->Microsoft SQL Server 2005-> Configuration Tools -> SQL Server Configuration Manager and click Protocols for your_server_name and you...

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

    July 17, 2008 at 7:15 am

    #844366

  • RE: SQL Server Authentication problem(SQL server 2005)

    sreevani.chireddy (7/17/2008)

    Hi, I'm having trouble to access my DB(SQL server 2005). I prefer to use SQL Server Authentication over windows Authentication. The problem I'm facing is that...

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

    July 17, 2008 at 7:03 am

    #844352

  • RE: how many users r connected to the sqlserver

    GilaM thnx for alternatives!

    :hehe:

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

    July 17, 2008 at 5:42 am

    #844288

  • RE: how many users r connected to the sqlserver

    You can use system procedure, it shows the information about login name, host name instead of IP address, also in which DB etc etc!

    sp_who ( it has info what command...

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

    July 17, 2008 at 2:48 am

    #844208

  • RE: How to Pivot a table

    Here I agree with Jeff ( his is also SQL Server MVP), he writes the very professional code how to do it without PIVOT and simply you do not need...

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

    July 17, 2008 at 2:21 am

    #844200

  • RE: Pivot view date - SQL vs Oracle

    Another important thing to know is that I'm trying it in Oracle 8i - but not working! Is it any reason for the Oracle version!

    Dugi

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

    July 16, 2008 at 8:26 am

    #843805

  • RE: Pivot view date - SQL vs Oracle

    richard.clarke (7/9/2008)

    Hi

    Sorry about the original SQL, it was using MS SQL syntax and not Oracle. Anyway try this. I tested this on Oracle Express 10 and it looks...

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

    July 16, 2008 at 8:03 am

    #843785

  • RE: Pivot view date - SQL vs Oracle

    I forget it to post reply, I tested today and it works very fine!

    Also I changed and I tested with function TO_CHAR, but not working the wrong things was [...

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

    July 16, 2008 at 7:46 am

    #843762

  • RE: SQL Server 2005 restart service and db in reovery for over an hour now

    hmm can you explain how did you do shrinking the log file till you said that you detach the DB!?

    :w00t::w00t:

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

    July 16, 2008 at 7:08 am

    #843737

  • RE: Need to remove duplicate records and get distinct values

    Hi Jeff!

    Your code here just selecting and ordering asc the data inside the table it doesn't do any elimination of duplicate records!

    Can you explain little bit this!

    Dugi

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

    July 16, 2008 at 6:45 am

    #843727

  • RE: Need to remove duplicate records and get distinct values

    Ooppsss I didn't see in which forum we are discussing ... sorry!

    I posted the technique for the SQL Server 2005!

    there is one of the solutions:

    you should add the column as...

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

    July 15, 2008 at 7:26 am

    #843082

  • RE: How do I group the column with these condiitions

    Swamy seems to be very professional for T-SQL! This code is very profi!

    :w00t::w00t::w00t::w00t::w00t:

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

    July 15, 2008 at 1:45 am

    #842865

  • RE: import and export wizard

    Hi,

    First of all you will do a full backup of you db or make a copy of your db as you want!

    than try to change the compatibility level from 90...

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

    July 15, 2008 at 1:34 am

    #842859

Viewing 15 posts - 691 through 705 (of 789 total)