Forum Replies Created

Viewing 15 posts - 181 through 195 (of 234 total)

  • RE: SQL Services will not start...

    I see..

    what's interesting about the error message is that it normally revolves about the (Error : 9003 severity 20, State 1) master database having issues with and not the DB...

    Cheers,
    John Esraelo

  • RE: SQL Services will not start...

    Just out of curiusity; was this database

    The LSN (1382:341:1) passed to log scan in database 'BEDB' is invalid..

    just recently being restored??

    Cheers,
    John Esraelo

  • RE: Stupid question:User in SQL Server 2000 vs 2005

    this might come handy in the near future too..

    -- ===================================================

    /*

    How to fix orphaned SQL Server users

    --------------------------------------------------------------------------------

    Summary

    When you restore a Microsoft SQL Server database on a different machine, you cannot access...

    Cheers,
    John Esraelo

  • RE: LINK servers in SQL2K5 --> VFP

    The vfp is visual foxpro and the dbc is database container or for lack of a better word a device for the old sql server programmers and admins.

    I will take...

    Cheers,
    John Esraelo

  • RE: SECURITY:: Grant Vs WithGrant

    you are the chosen one...

    John Esraelo

    Cheers,
    John Esraelo

  • RE: security admin vs admin

    perfect, thx

    John Esraelo

    Cheers,
    John Esraelo

  • RE: Backups

    Well, this is a very tricky question.

    Can you start a "new" job or run a backup manually to a different destination file name, yes..

    would SQL run both process in...

    Cheers,
    John Esraelo

  • RE: Best Way to Calculate Age

    funny

    :w00t:

    :rolleyes:

    Cheers,
    John Esraelo

  • RE: Best Way to Calculate Age

    /*

    I was born on Nov/16/1957 therefore I am 50 years of age. However, the only correct statement, regardless the returning data-type, is the second one. So, I am not going...

    Cheers,
    John Esraelo

  • RE: Help with copying subdirectory structure of a folder to another location::

    YOU GUYS rock...

    eventhough I was looking for the copy command options, but, I think I will be happy with... this is great.

    I have not worked with VFP until end of...

    Cheers,
    John Esraelo

  • RE: Cannot convert a char value to money

    I run the code and there is nothing wrong with that:

    here is the value I get back 111.00

    It looks like you have posted this elsewhere and you have...

    Cheers,
    John Esraelo

  • RE: Problem with Select Top x Percent?

    This is very interesting; I am not sure if you got to this point by a pure luck or you were actually R&D'ing.

    In either case, it looks like in some...

    Cheers,
    John Esraelo

  • RE: Totals to date

    hi there.

    please take a look at this link::

    http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/sequentialordering/2261/

    I have not read it completely, but, I have a feeling you may get some ideas from this page and might be able...

    Cheers,
    John Esraelo

  • RE: BackupExec and SQL 2005:

    This is very good piece of information. Awesome.

    I need to re-read what I posted, I just sounded like an idiot.

    I do not want them to use the agent to backup...

    Cheers,
    John Esraelo

  • RE: data dictionary

    I have been using:

    use mydatabase

    go

    select *

    from information_schema.columns

    of course I write this information to a table (mydatabase.dbo.mydictionary) and then take it to my authoring tools for preparing a document.

    I was just...

    Cheers,
    John Esraelo

Viewing 15 posts - 181 through 195 (of 234 total)