Forum Replies Created

Viewing 15 posts - 2,086 through 2,100 (of 3,232 total)

  • RE: No autosubscribe when I reply?

    I've looked throughout the Account setup and I do not see that this has been made an option.  I too would like the autosubscribe functionality back.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 24, 2007 at 3:29 pm

    #735804

  • RE: Data Validation

    First off, you'll need to be able to define what is valid and invalid data.  Can you expand on what you are looking for and include some data examples that...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 24, 2007 at 3:13 pm

    #735795

  • RE: Blocking - how to determine cause and effect

    If you think that you've already narrowed it down to possible blocking from long running queries, you can stop running the Windows Performance Monitor and focus more on SQL Profiler. ...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 24, 2007 at 11:07 am

    #735713

  • RE: Trigger prob

    Can you post your procedure?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 20, 2007 at 10:00 am

    #734993

  • RE: aggregate query question

    Can you post sample DDL and data along with the expected results from your sample data?  It would help if you epand on the tie breaker as well - include...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 20, 2007 at 9:53 am

    #734990

  • RE: Trigger not getting values from INSERTED

    To second what Lowell has posted, all triggers should be written to handle multiple row operations.  The way you've written your trigger will only work with the last rows values...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 20, 2007 at 9:40 am

    #734984

  • RE: Upgarde from SQL server 7.0 to SQL server 2005

    Please do not cross post.  This thread should be continued here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=400521

     

     

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 19, 2007 at 4:06 pm

    #734737

  • RE: SQL Query tuning

    This thread is being worked here:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=360&messageid=400533

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 19, 2007 at 3:48 pm

    #734731

  • RE: Transaction LOG Backup

    I would follw JDixon's advice.  Restore your full backup to another database.  DO NOT restore it over your production DB.  Then grab the rows that correspond to the 3 modfications...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 18, 2007 at 3:09 pm

    #734419

  • RE: Foregine key error

    If you are getting an error, it would sure help us help you to know what the error is.  Can you post the error syntax for us?  You are attempting...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 18, 2007 at 3:05 pm

    #734418

  • RE: Counting without Primary Key

    Building on the example data I posted earlier, this should work for you.  Keep in mind that this type of JOIN assumes that there will not be any duplicate Nominee...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 18, 2007 at 9:46 am

    #734350

  • RE: Maintenance Plan Report to UNC Path

    I would say the easiest way to find out is to try it.  It should work for you.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 17, 2007 at 4:19 pm

    #734180

  • RE: Counting without Primary Key

    OK, adding a primary key onto these tables makes no difference to your query the way you have it written.  The 2 result sets you show (one before the PK...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 17, 2007 at 3:51 pm

    #734177

  • RE: Counting without Primary Key

    Yes, it looks like you create a PK on both tables, but what I want to know is on which columns?  Look back at your original post.  It shows your PK...

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 17, 2007 at 3:29 pm

    #734172

  • RE: Counting without Primary Key

    It's a bit unclear from your original post, but which columns are you adding the primary key on?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

    September 17, 2007 at 2:27 pm

    #734158

Viewing 15 posts - 2,086 through 2,100 (of 3,232 total)