Forum Replies Created

Viewing 9 posts - 1 through 9 (of 9 total)

  • RE: understanding locks

    erics44 (7/16/2012)


    Hi

    I am trying to understand locks and how i deal with them.

    i have read a couple of articles on them which is fine but i more need a conversation...

  • RE: Is there a way to generate an insert stored procedure

    Lowell (6/19/2012)


    and another way:

    download and install the SSMS add-on Called SSMS Tools Pack:

    http://www.ssmstoolspack.com/

    that adds a CRUD generator to the right click of any table, which is exactly what you were...

  • RE: Script to remove login which is mapped to several databases

    Lowell (6/19/2012)


    something like this should be pretty close:

    if you cannot drop a database user because it is the object owner, this would rroll it back so you can fix that...

  • RE: Grant access to login to run bunch of SP

    Thank you Lowell & andersg98. Really appreciate it.

    Regards,

    SueTons

  • RE: Multiple Queries-Please Help

    opc.three (6/12/2012)


    SueTons (6/12/2012)


    opc.three (6/12/2012)


    GilaMonster (6/12/2012)


    3. Deletes don't cause fragmentation.

    I thought that deletes were a major cause of internal fragmentation, though not necessarily external fragmentation.

    Yes, I second that deleting also cause...

  • RE: Multiple Queries-Please Help

    opc.three (6/12/2012)


    GilaMonster (6/12/2012)


    3. Deletes don't cause fragmentation.

    I thought that deletes were a major cause of internal fragmentation, though not necessarily external fragmentation.

    Yes, I second that deleting also cause fragmentation. ...

  • RE: Need help with creating StoreProc

    David Webb-200187 (6/8/2012)


    What do you want the proc to do if an invalid combination is passed in?

    What do you want it to do when a valid combination is passed in?

    Hi,...

  • RE: Need help with creating StoreProc

    thadeushuck (6/8/2012)


    create table Zips (Zip int, City [varchar](36) null, StateCode [varchar](2) NULL, County [varchar](36) null)

    insert into Zips values (75056, 'Dallas', 'TX', 'Dallas');

    insert into Zips values (75057, 'Irving', 'TX', 'Dallas');

    insert into...

  • RE: Need help with creating StoreProc

    Lynn Pettis (6/8/2012)


    SueTons (6/8/2012)


    Hi all, I'm new to SQL, any instructions or sample code to create the Store Proc below would be greatly appreciated.

    Find below the details.

    Requirement: create SP...

Viewing 9 posts - 1 through 9 (of 9 total)