Forum Replies Created

Viewing 15 posts - 4,636 through 4,650 (of 6,679 total)

  • RE: Shrink log file

    I am going to guess that the recovery model of the database is full - and that you don't have regular scheduled transaction log backups.

    If that is the case, you...

    August 24, 2009 at 9:36 pm

    #1043972

  • RE: What issues are there with running 64-bit sql server?

    I've been running several systems in production for several years now, and we have not had any problems. Of course, we do not have any issues with accessing other...

    August 24, 2009 at 9:32 pm

    #1043971

  • RE: Using INNER and OUTER joing withou non-ANSI joins: need help!

    willian (8/24/2009)

    Sorry, I forgot the final result:

    SELECT A.NOME,

    A.MATRICULA,

    CASE P.TIPO_AULA

    ...

    August 24, 2009 at 2:25 pm

    #1043872

  • RE: Can't increase size of database

    helpmhost (8/24/2009)

    I tried again today. We have the auto-shrink property set as well, so today the Initial size of the data file was significantly less. I also added a second...

    August 24, 2009 at 1:47 pm

    #1043859

  • RE: installing SQL Server 2005

    gmamata7 (8/23/2009)

    After the Installation, I have noticed that the .mdf & .ldf of System databases were created at C:\Program files\Microsoft SQL Server\MSSQl.1\MSSQL\Data.

    You have the option during the installation (click...

    August 23, 2009 at 2:06 pm

    #1043399

  • RE: Sql Server DR Strategy - Advice Reqd

    pdchandran (8/23/2009)

    The important which I had missed is - Sql Server has the database and log files locked as long as the Sql Server service is running. It would not...

    August 23, 2009 at 1:55 pm

    #1043398

  • RE: Schema permissions for Windows workgroup

    In addition to the previous poster - you cannot define a default schema to a Windows Group. If the user does not schema qualify access to the object, the...

    August 21, 2009 at 2:23 pm

    #1043152

  • RE: SQL server 2005 SP3 install on cluster

    When you ran the service pack - it should have listed everything that it was going to upgrade. Rerun the service pack upgrade and verify that all items in...

    August 21, 2009 at 2:01 pm

    #1043136

  • RE: Remove log file

    Krasavita (8/21/2009)

    It is located in when I go to the db property under Files. I see: Log file that I don't need, when I click remove,I get an error message,...

    August 21, 2009 at 12:28 pm

    #1043051

  • RE: SQL server 2005 SP3 install on cluster

    How are you verifying that the instance you are connected to was in fact upgraded to SP3? Do you have multiple instances on that cluster?

    August 21, 2009 at 11:14 am

    #1043012

  • RE: Remove log file

    Is this a SQL Error log? The SQL log? Or a database transaction log?

    What did you try - and what was the exact error message?

    If you are talking...

    August 21, 2009 at 11:13 am

    #1043009

  • RE: Changing locaton of data and logs for the database and server

    GilaMonster (8/21/2009)

    Krasavita (8/21/2009)

    1.How to - move the files at OS level?

    Are you serious? Do you not know how to move a file using window explorer?

    2.Do you have a link how...

    August 21, 2009 at 11:08 am

    #1043007

  • RE: clarification on NULL s

    Bob Hovious (8/20/2009)

    Got it. I was looking at the difference in execution plans, and you example has a compute scalar... which obviously calculates a single value. ...

    August 20, 2009 at 10:14 pm

    #1042586

  • RE: clarification on NULL s

    Bob Hovious (8/20/2009)

    Hey Jeffery, thanks for joining in. 🙂

    I will confess to totally overlooking the null set as you illustrated. So let me ask you this...

    August 20, 2009 at 8:31 pm

    #1042560

  • RE: clarification on NULL s

    Bob Hovious (8/20/2009)

    NULL is the absence of a value in a column for a given row (or a variable), not the absence of a row.

    If no rows meet your WHERE...

    August 20, 2009 at 8:04 pm

    #1042554

Viewing 15 posts - 4,636 through 4,650 (of 6,679 total)