Forum Replies Created

Viewing 15 posts - 151 through 165 (of 282 total)

  • RE: Two Things

    That was funny... thanks for the laugh.

  • RE: Two Things

    By the way, jesus is dead and did not live in the 20th century.  Influential in the 20th century ... maybe.  Alive in the 20th century ... definitely not.  Now,...

  • RE: Two Things

    No particular order here either:

    Doyle Brunson

    Antonio Estfendari

    Phil Ivey

    Phil Lak

    Phil Helmuth

    Johnnie Chan

    Scotty Negyun

    Daniel Negraneau

    Scott Fishman

    Chris (Jesus) Ferguson

     

  • RE: Mulitple Instances on SQL 2000

    easily done... just configure each instance with 2 gig via sp_configure

  • RE: accessing results from procedure using VB record set

    I've encountered this issue.  You cannot have print statements in a stored procedure that returns a recordset to VB, otherwise the recordset will be returned "closed".  Try removing the print...

  • RE: any want can help me

    There is a "boolean" data type - it's the "Bit" data type. 

  • RE: Change ''''local to named instance

    Instances can only be created upon install.  Thus I think you are left with 2 installs to do to accomplish your goal.

  • RE: Lost All databases

    Sometimes these things just happen, sometimes they are signs of bigger problems to come (failing hard drives, etc). 

    In my 8 years of dealing with SQL Server, I only ever...

  • RE: Lost All databases

    I assume you've tried:

    Use master

    DBCC CHECKDB

    GO

    Sounds like your master database is fried somehow.  You might want to think about rebuilding your master database.  Do a search in BOL for Rebuild...

  • RE: Lost All databases

    The error log was complaining about DBID 1, this is the master database.  Run DBCC CHECKDB against that database.

  • RE: store proc debug

    Did you grant exec privledges on master.dbo.sp_sdidebug to the login attempting to do the debugging?

    Be warned that using the T-SQL debugger will cause major blocking issues.  It's a common practice to...

  • RE: Is there a need for real-time monitoring tools? Budget Time...

    I can't tell you anything about the real-time monitoring tools.  But I can tell you that Litespeed and SQLCompare are both well worth the $$.  They've both saved countless hours...

  • RE: Lost All databases

    DBCC CHECKDB

  • RE: Lost All databases

    did you run dbcc checkdb on master? 

  • RE: Urgent - Need to increase database size.

    When a database is set to autogrow - that's what it does.  It's autogrows the file(s) as nessecary.  It is not needed to increase the size at this time.  Although...

Viewing 15 posts - 151 through 165 (of 282 total)