Forum Replies Created

Viewing 15 posts - 331 through 345 (of 7,636 total)

  • RE: SQL Server fails to start after creating Server Principle Names

    rstringer (5/21/2012)


    No firewalls in this environment.

    Windows has a software firewall built into the OS. You need to check that on the Server that is running your SQL Server instance....

  • RE: SQL Battleship Game

    OK. But I've been playing Battleship since 1963 and we always had 5 ships, but it seems like you have 7? Are there any other variations from the...

  • RE: Save DAT file in sqlserver

    formatting your code:

    IPSearchLight.GeoLocator loc = new GeoLocator();

    loc.Database_Path_or_URL = "GeoLiteCity.dat";

    string VisitorIP = Request.ServerVariables["REMOTE_ADDR"];

    ...

  • RE: Same Query , Same Database, Different Version ....Different Result!!!

    Rachel Lee-244397 (5/20/2012)


    What I really wonder, is to why they results should be different, asd the data is extacly the same -

    Robert already explained this to you. Did...

  • RE: SQL Battleship Game

    This doesn't seem to follow the rules that everyone knows (and that you linked to at Wikipedia). Maybe you could post the rules that your game is following?

  • RE: Save DAT file in sqlserver

    Methew (5/20/2012)


    @young:

    i do not know the internal structure(and i do not know how to know/check its internal structure)...i have this file GeoLiteCity.DAT.I am passing IP address of current user and...

  • RE: SQL DDL trigger

    You know, You could also just use use a View that remaps the Table Default information already stored in the database's metadata and presents it in the same format as...

  • RE: Save DAT file in sqlserver

    What is the format / structure / contents of this DAT file?

    You can certainly put the raw file into SQL Server and retrieve it again, however that alone will not...

  • RE: SQL Table column issue

    Which column is it and what exactly are you trying to enter?

    (I ask because it doesn't look like a date column/value that you are trying to enter).

  • RE: To TOP or not to TOP?

    OK, I believe that I have it, though the why of it is still a mystery...

    This line in your SELECT statement:

    + CASE WHEN dc.[name] IS NOT NULL THEN ' CONSTRAINT...

  • RE: To TOP or not to TOP?

    Surprisingly, I am able to (partially) reproduce this problem.

    When I run it against one of my tables with the TOP clause I get:

    smallidINT NOT NULL -- no default

    ,bigidINT NOT...

  • RE: To TOP or not to TOP?

    gemisigo (5/18/2012)


    Yes, it's not the ordering that fails here. Barry clarified quite a few things that was unknown for me but he wasn't saying he is addressing that part of...

  • RE: To TOP or not to TOP?

    HowardW (5/18/2012)


    Hi Barry,

    That's interesting. Here though, its not just the ordering that's incorrect, the entire accumulated resultset gets discarded, so it just doesn't work.

    Right, but the "Why" of that...

  • RE: Case in Where Clause? Alternatives pls.

    !!! How did you guys get in front of me?!?

  • RE: Case in Where Clause? Alternatives pls.

    CptCrusty1 (5/17/2012)


    OK.. Case statement works, but is it the best way....

    .....

    AND (CASE WHEN COL_1 = 25 AND COL_2 <> 30 THEN 1

    ...

Viewing 15 posts - 331 through 345 (of 7,636 total)