Forum Replies Created

Viewing 15 posts - 256 through 270 (of 330 total)

  • RE: sp_who2 results show one spid 24 times

    hi,

    I am also facing same porblem today when i run Sp_who or Sp_who2 it is returnning only current...

    August 27, 2010 at 2:57 pm

    #1213276

  • RE: How to know what user created a table?

    Lowell (8/27/2010)

    select name,create_date,modify_date from sys.objects

    In the above we can get only the modification date and time but we cant get from which system/user the table has been modified/created.

    I dont think...

    August 27, 2010 at 2:07 pm

    #1213250

  • RE: There is no space in the server

    mlomas76 (8/27/2010)

    Not making any assumptions, so have you checked to see if there are any other files or folders that you can delete? Emptying the recycle bin, deleting any...

    August 27, 2010 at 1:59 pm

    #1213240

  • RE: There is no space in the server

    CirquedeSQLeil (8/27/2010)

    There are multiple ways to add disk space and have the data use the new space. One method is to extend your partition.

    Even for partition we need to...

    August 27, 2010 at 10:24 am

    #1213091

  • RE: There is no space in the server

    pankushmehta (8/26/2010)

    You can start by backing up the TLOG to a network location and then shrinking the log files, which will start to free up some space.

    If you add additional...

    August 27, 2010 at 7:40 am

    #1212935

  • RE: There is no space in the server

    Perry Whittle (8/26/2010)

    parthi-1705 (8/25/2010)

    hi,

    It is just the situation that was given to me, it may be due to some more data might have up added additionally...

    August 26, 2010 at 11:37 am

    #1212465

  • RE: There is no space in the server

    hi,

    It is just the situation that was given to me, it may be due to some more data might have up added additionally or due to...

    August 25, 2010 at 2:50 pm

    #1211956

  • RE: There is no space in the server

    Are your log files being managed properly ? (backed up frequently if full recovery)

    Yes it is in Full recovery model, log files are done @ proper interval due to...

    August 25, 2010 at 11:19 am

    #1211805

  • RE: Unable to update records

    Dont forgot to reenable that trigger since it might have be wrriten for some other purpose.Ensure that it is enabled.

    Thanks

    Parthi

    August 25, 2010 at 9:49 am

    #1211752

  • RE: Unable to update records

    Hi,

    Check whether Trigger is enabled for this table or not

    If so disable the trigger and...

    August 25, 2010 at 9:11 am

    #1211704

  • RE: GETDATE() does not return any data

    Hi

    1)You can check DELIVERY_date column in the table it may be in datetime or Smalldatetime

    2)If it is datetime/Smalldatetime and storing the in same datetime/Smalldatetime formate it will be stored as...

    August 20, 2010 at 12:22 pm

    #1209858

  • RE: SQL server 2008 file stream

    hi

    Any guess for the question wating for any replay

    Thanks

    Parthi

    August 6, 2010 at 9:36 am

    #1203615

  • RE: how to get Getdate() without using convert or cast

    Chris Morris-439714 (7/1/2010)

    parthi-1705 (6/30/2010)

    Dan.Humphries (6/30/2010)

    K I have to ask why should you not use cast or convert?

    Just i am trying to find out any possiable ways are there other than...

    July 1, 2010 at 12:08 pm

    #1187836

  • RE: how to get Getdate() without using convert or cast

    Dan.Humphries (6/30/2010)

    K I have to ask why should you not use cast or convert?

    Just i am trying to find out any possiable ways are there other than this... you can...

    June 30, 2010 at 9:18 pm

    #1187428

  • RE: SQL server 2008 file stream

    Hi

    how to insert a file in my database that is tro attachment.

    i am using browse option in my computer after that i am selecting a file (which may be any...

    April 5, 2010 at 8:46 am

    #1145763

Viewing 15 posts - 256 through 270 (of 330 total)