Forum Replies Created

Viewing 15 posts - 40,096 through 40,110 (of 49,552 total)

  • RE: Who CREATED and/or ALTERED an object

    Stamey (3/30/2009)

    I don't know how long the info stays in there, as this is from the default trace, perhaps it is determined by how busy the DB is, but...

    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

    March 30, 2009 at 8:34 am

    #968390

  • RE: Is there a backdoor login to SQL Server 2000

    Find the database files on the PC in question (.mdf and .ldf), copy them to another machine that has SQL 2000 on and attach them.

    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

    March 30, 2009 at 8:31 am

    #968388

  • RE: Unique Key Combination

    ALTER TABLE < Table name >

    ADD CONSTRAINT < Constraint Name > UNIQUE (ColA, ColB)

    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

    March 30, 2009 at 8:18 am

    #968370

  • RE: Who CREATED and/or ALTERED an object

    Casper (3/30/2009)

    Is there a way to see what user login created a specific object, like a specific stored proc or a table?

    And for that matter is there a way to...

    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

    March 30, 2009 at 8:10 am

    #968362

  • RE: Have no access and unable to administer

    john (3/30/2009)

    Oddly though there are two instances of sqlserver running in the task manager there is only one in services and it is Backup Exec.

    Check both under SQL and under...

    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

    March 30, 2009 at 7:43 am

    #968332

  • RE: Have no access and unable to administer

    I need the actual names of the services in order to help you. One of those is going to be the default instance, one is going to be a named...

    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

    March 30, 2009 at 7:19 am

    #968308

  • RE: Can't see DBs content after server reboot

    My guess is that the SQL service is starting before the disks are available. If you check the error log, you'll probably find a lot of errors relating to SQL...

    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

    March 30, 2009 at 7:09 am

    #968294

  • RE: Reg: MCTS EXAM 70-445

    http://www.microsoft.com/learning/mcp/certifications.mspx

    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

    March 30, 2009 at 7:05 am

    #968287

  • RE: Do DBAs Still Read Techincal Books?

    Grant Fritchey (3/30/2009)

    And the bleeding from one of Tony's editing sessions only lasts for three or four days, so don't worry.

    You sure? I'm still wincing from the last one I...

    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

    March 30, 2009 at 6:49 am

    #968277

  • RE: Trigger

    Sure. no problem.

    That is, if you can give us some info on the table the trigger's going on, what the trigger needs to do and when, and, if it has...

    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

    March 30, 2009 at 6:48 am

    #968276

  • RE: Trigger

    Yes

    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

    March 30, 2009 at 3:01 am

    #968180

  • RE: Full Text Search (Thesaurus)

    Please don't start a new thread for an existing problem.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic685529-145-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

    March 30, 2009 at 2:59 am

    #968179

  • RE: MCTS & MCITP exam cost

    http://www.register.prometric.com/Menu.asp

    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

    March 30, 2009 at 2:58 am

    #968177

  • RE: Have no access and unable to administer

    john (3/29/2009)

    sqlservr x2

    Specifics please. That's not enough information to help you. To give you an idea what I need, here's the output of SQL Server services running on my machine.

    MSSQLSERVER

    MSSQL$SQL2008

    Also,...

    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

    March 30, 2009 at 2:53 am

    #968175

  • RE: Microsoft certification 70-433

    trackingraj (3/29/2009)

    Thanks for your reply. I'm a developer.

    Then write 433 and don't worry about 432. 432 is the first of the DB Admin exams for 2008 and, unless you want...

    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

    March 29, 2009 at 1:36 pm

    #968075

Viewing 15 posts - 40,096 through 40,110 (of 49,552 total)