Forum Replies Created

Viewing 15 posts - 4,966 through 4,980 (of 13,460 total)

  • RE: problem with Database mail:All mails have Unsent status

    Aspet Golestanian Namagerdi (8/10/2012)

    Thanks for your replies.This database mail setup used to work,but suddenly stopped working.As I wrote before,I am able to ping and telnet the mailserver(mashine).Regarding authentication,that setting is...

    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!

    August 10, 2012 at 9:13 am

    #1524504

  • RE: unique constraint

    Nice post, Mr. Celko!

    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!

    August 10, 2012 at 9:11 am

    #1524500

  • RE: Remove non alphabetic characters but retain (space, single quote and dash)

    here's one way;

    the nice thing about this technique, is it makes it very easy to change/adapt to include/exclude other special characters...at least for me it's obvious, that is.

    additionally, depending on...

    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!

    August 10, 2012 at 8:53 am

    #1524491

  • RE: Equivalent to "#INCLUDE" Preprocessor Directive in T-SQL?

    ok how about this idea:

    if you grab the free, add-on SSMS Tools

    from here:

    http://www.ssmstoolspack.com/

    one of the options it provides is a "default" template every time you create a new query window...

    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!

    August 10, 2012 at 8:36 am

    #1524477

  • RE: Are the posted answers getting worse?

    very true;

    i've seem questiosn where the problem query was psoted, the issue is either a syntax issue or something like a case statement manipulation, but a knee-jerk reaction post asking...

    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!

    August 10, 2012 at 5:55 am

    #1524365

  • RE: Not able to view standard reports in management studio

    Could it be the SSMS version?

    Maybe the SSMS for Express with advanced services was installed, instead of SSMS that comes with 2005 STD?

    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!

    August 10, 2012 at 5:53 am

    #1524363

  • RE: How can I make ten rows in a column into one comma seperated row

    the trick is to use a technique using FOR XML:

    does your table have more columns than just the year? the solution's the same, but the detaisl are a little differnet.

    here's...

    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!

    August 9, 2012 at 2:41 pm

    #1524125

  • RE: Why same data/sp in different DB returns result in different order?

    halifaxdal (8/9/2012)

    Thanks guys, I realized adding "order by" can resolve the issue but was just puzzling on why the result was generated differently and why for each DB the sp...

    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!

    August 9, 2012 at 2:32 pm

    #1524117

  • RE: problem with Database mail:All mails have Unsent status

    ok don't telnet by ip address, try to go to the mx record: mail.yoursever.com or whatever.

    the DNS resolution seems to be the issue, i'm thinking...either DNS or name change?

    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!

    August 9, 2012 at 2:28 pm

    #1524112

  • RE: Stored Procedure Wont Create - Invalid column name

    wait, your adding a column, updaiting it to a string value, and then dropping the same column?

    we can certainly help streamline THAT process.

    you can probably use a CTE or something...

    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!

    August 9, 2012 at 2:25 pm

    #1524109

  • RE: Why same data/sp in different DB returns result in different order?

    lol so true!

    thanks for noticing Scott!

    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!

    August 9, 2012 at 2:22 pm

    #1524103

  • RE: Database Mail XPs disabled so can't send mail!

    I wouldn't be surprised if some just didn't feel like enabling it for you, and used the "it's locked down for security" trump card just to cut off discussion.

    I'm agreeing...

    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!

    August 9, 2012 at 2:21 pm

    #1524100

  • RE: Why same data/sp in different DB returns result in different order?

    if there is no ORDER BY, SQL is free to return the data in any order it deems efficient.

    only with an ORDER BY are you guaranteed consistent order by results.

    in...

    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!

    August 9, 2012 at 2:15 pm

    #1524093

  • RE: Creating a table

    looks pretty good; if first and last name are required, i think they need to be NOT NULL, right?

    Create Table Customers

    (FirstName VarChar(20) NOT NULL ,

    LastName VarChar(20)NOT NULL,

    CustomerSSN SSN Primary...

    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!

    August 9, 2012 at 2:11 pm

    #1524090

  • RE: Stored Procedure Wont Create - Invalid column name

    you cannot ALTER a table and then also use the column in the same group of commands ; the column has to be added, and then a GO statmenet...

    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!

    August 9, 2012 at 2:02 pm

    #1524084

Viewing 15 posts - 4,966 through 4,980 (of 13,460 total)