Forum Replies Created

Viewing 15 posts - 1 through 15 (of 47 total)

  • RE: Stored procedure naming prefix

    Maninder S. (7/3/2008)

    Well i think everybody should start using the schema based Sepration Procedures for all objects. that will also be helpful in distinguishing the Objects and relate them...

    July 15, 2010 at 5:35 am

    #1193377

  • RE: Stored procedure naming prefix

    RonKyle (7/7/2008)

    I would recommend as a MINIMUM that all the stored procs you create be abbreviated usp_ for "user stored procedure." Not only does that avoid the sp_ issue...

    July 15, 2010 at 4:01 am

    #1193330

  • RE: Microsoft SQL Server, Error: 18456

    From http://www.sqlservercentral.com/Forums/Topic534163-359-1.aspx

    state 16 = "default database not accessible"

    May 25, 2010 at 7:34 am

    #1172056

  • RE: Microsoft SQL Server, Error: 18456

    vyas (11/22/2007)

    Check server's error log where a corresponding entry will be written.

    Is this the SQL Server log or the Windows Event Log?

    [Edit: The messages appear in both logs,...

    May 25, 2010 at 7:17 am

    #1172040

  • RE: Regular Service

    Jeff Moden (5/1/2010)

    ...While I'm here... have any of you had any problems with getting 2k8 Dev Edition to install on Windows 7?

    I installed SQL 2008 Developer Edition on Wondows 7...

    May 2, 2010 at 7:35 am

    #1160989

  • RE: Regular Service

    bwillsie-842793 (4/28/2010)

    I vote for SP's on a regular basis. My gut instincts tell me that cherry picking CUs is going to cause me problems at some point.

    I also look...

    April 28, 2010 at 1:45 pm

    #1159260

  • RE: Concrete Code

    Mike Hinds (4/27/2010)

    Still, rebar in concrete won't crumble, unlike its T-SQL counterpart.

    Regrettably, this side of the Atlantic, there have been re-enforced concrete bridges and buildings where the Re-Bars rusted and...

    April 27, 2010 at 9:06 am

    #1158306

  • RE: Concrete Code

    I would term the approach adopting a pragmatic approach rather than a "purist" approach.

    April 27, 2010 at 5:11 am

    #1158092

  • RE: What is the value of SCOPE_IDENTITY()

    An excellent question! - Thank you!

    April 19, 2010 at 3:33 pm

    #1154180

  • RE: Map IP Address to a Geographical Location

    Whilst the article was very good, I would like to issue a note of caution; even if the address does not appear to be that of a DHCP pool used...

    April 18, 2010 at 3:10 pm

    #1153510

  • RE: TRUNCATE

    Continuing on the humour on this thread, please see http://apod.nasa.gov/apod/ap100401.html

    April 1, 2010 at 1:11 am

    #1143711

  • RE: Code Writing Code

    I have been writing stored procedures for some time that not only write stored procedures using the table definitions as Steve mentions in his editorial, but also write the required...

    March 15, 2010 at 2:45 pm

    #1134079

  • RE: Timing is Everything

    craig.nixon (2/28/2010)

    I think it's better to use the international UTC time standard and convert to local as necessary.

    This is much the best way of handling multiple time zones.

    March 1, 2010 at 7:01 am

    #1126441

  • RE: Timing is Everything

    stevet-1034619 (2/26/2010)

    ...and why does it have to be Mean time? Can't it be Happy time? Can't we all just get along?

    😉

    The M in GMT is not Mean as in nasty...

    February 27, 2010 at 12:25 pm

    #1126136

  • RE: Concatenation Cursor

    nicolasallan (2/25/2010)

    Thanks Clive,

    ... There are various workarounds to this "feature", follow the above link if you're interested.

    _Nick

    Thank you for the link.

    February 26, 2010 at 5:06 am

    #1125490

Viewing 15 posts - 1 through 15 (of 47 total)