Forum Replies Created

Viewing 15 posts - 39,256 through 39,270 (of 49,552 total)

  • RE: FCB::Open: Operating system error 3(The system cannot find the path specified.) occurred while creating or opening file 'E:\DATA\xxx\xxxxx.mdf'. Diagnose and correct the operating system error, and retry the operation

    Please don't use polls for normal questions. Thanks.

    Is the path E:\DATA\xxx\xxxxx.mdf valid? Is the mdf file there?

    Does the SQL Server Service Account have full permissions on that file and folder?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 7, 2009 at 5:14 am

    #990235

  • RE: FCB::Open: Operating system error 3(The system cannot find the path specified.) occurred while creating or opening file 'E:\DATA\xxx\xxxxx.mdf'. Diagnose and correct the operating system error, and retry the operation

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic711745-5-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 7, 2009 at 5:12 am

    #990234

  • RE: Recovery Model and Transactions

    GDI Lord (5/7/2009)

    Does the choice of recovery model affect transaction handling in the database?

    No, other than for bulk operations (detailed below).

    Can I still use transactions?

    Yes

    Does...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 7, 2009 at 5:07 am

    #990230

  • RE: Full text index on column of varbinary data type

    Yes, providing the varbinary stores a document and you need a column that describes what the varbinary is.

    From Books Online:

    Only one full-text index is allowed per table. For a full-text...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 7, 2009 at 4:41 am

    #990215

  • RE: Are the posted questions getting worse?

    Bob Hovious (5/6/2009)

    Obviously Gail hasn't talked (or, more properly, listened) to someone about his commercial-application-turned-public-domain-won't-anyone-please-love-me product, which shall not be named. It can do anything better because it's...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 7, 2009 at 4:38 am

    #990212

  • RE: SSRS Reporting : Multi value parameter report error only with Select All

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic711622-150-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 3:35 pm

    #990023

  • RE: query week in the last year?

    ericb1 (5/6/2009)

    sorry about that, I should have given more info. It's actually for another application, which is handling the indexing, so it's not an issue.

    Indexing as in indexes...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 3:30 pm

    #990021

  • RE: Problem with XML code

    I'd say this one's minor. It's an irritation. I only found it when posting pieces of a query's XML plan.

    Though do note that it happens in other code markups than...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 3:23 pm

    #990016

  • RE: Are the posted questions getting worse?

    tosscrosby (5/6/2009)

    Egads, something is amiss. I hit quote on Lynn's last post and it quoted Gail's post one prior to Lynn's!

    It happens if someone's posted a reply since the page...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 2:58 pm

    #989985

  • RE: Problem with XML code

    Steve Jones - Editor (5/6/2009)

    Logged as a bug

    Thanks

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 2:39 pm

    #989962

  • RE: Are the posted questions getting worse?

    Florian Reischl (5/6/2009)

    :sick:

    CREATE SCHEMA [%]

    GO

    CREATE TABLE [%].[%] (Id INT IDENTITY PRIMARY KEY, i INT, [-] INT, [AND] INT, [*] INT, [%] VARCHAR(10))

    CREATE INDEX [master.sys.objects] ON [%].[%] ([-]) INCLUDE ([*])

    INSERT INTO...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 2:39 pm

    #989961

  • RE: Lost model.bak from system database

    There are no errors in that. The model database is starting up without any problems. If model were damaged, there would be lots of high severity errors in there.

    Is your...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 2:09 pm

    #989921

  • RE: Backup Strategies

    barunpathak (5/6/2009)

    1) Do I overwrite the same files everytime?

    You can, but what if you need to restore an older backup, either because the newer one is corrupt (it happens)...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 10:23 am

    #989704

  • RE: What should developers understand about administration?

    Security, security, security and just for completeness, security.

    They need to understand and understand the reasons for the Principle of Least Privilege.

    They need to understand injection and how to prevent it...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 9:52 am

    #989677

  • RE: Please help me.....=`(

    I have no idea how to uninstall MySQL and I have no idea what the error means. I haven't worked with MySQL in 5 years or more.

    I suggest that you...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    May 6, 2009 at 7:14 am

    #989503

Viewing 15 posts - 39,256 through 39,270 (of 49,552 total)