Home Forums SQL Server 2005 T-SQL (SS2K5) Email script RE: Email script

  • September 24, 2009 at 11:29 am

    #1058175

    that looks more like an error from running the script on the wrong database.

    if the original SQL you pasted was valid, the rest should be valid too...

    what you pasted is not the same as the original...what you pasted does not have a FROM statement...so it would fail.

    the forum seems to chop some stuff out due to HTML that you want as part of your email.

    the attached file passes syntax, so if the table and column objects are there, you should be good to go.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!