Forum Replies Created

Viewing 15 posts - 6,091 through 6,105 (of 13,460 total)

  • RE: 'Invalid Column Name' Error

    i don't see biz.city or biz.state in this definition:

    CREATE TABLE [dbo].[shops](

    [bizID] [int] IDENTITY(1,1) NOT NULL,

    [bizName] [nvarchar](255) NULL,

    [bizPhone] [nvarchar](15) NULL,

    [bizURL] [nvarchar](500) NULL,

    [bizLogo] [nvarchar](max) NULL,

    [clicks] [int] NULL,

    [clickReset] [datetime] NULL,

    [clickTotal] [int] NULL,

    [bizActive] [bit]...

    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!

    January 12, 2012 at 3:27 pm

    #1432923

  • RE: Timestamp column

    "TIMESTAMP" is a very misleading name...it's actual datatype is "ROWVERSION", which gives you an incrementing value to let you know which row was last edited...

    if your source is a datetime,...

    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!

    January 12, 2012 at 11:10 am

    #1432791

  • RE: Database Mail Error - A recipient must be specified

    An exchange server will do a lookup for you to determine that "Joe Smith" is actually j.smith@somedomain.com.

    a regualr SMTP server does not do that, it requires a valid email address...

    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!

    January 12, 2012 at 10:49 am

    #1432769

  • RE: Why msdb.dbo.sp_send_dbmail is not working for me? Thanks.

    halifaxdal (1/12/2012)

    I am the admin of the server/db

    ok, but where is the code running from? SSMS directly, or part of a job? wouldn't a job might be using a...

    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!

    January 12, 2012 at 10:28 am

    #1432757

  • RE: Why msdb.dbo.sp_send_dbmail is not working for me? Thanks.

    halifaxdal (1/12/2012)

    It's on the same server.

    it might still be a permissions issue, though.

    if im a user and only have access to production.dbo.Tables, and no access to the ISCSGSWEBUP01 database (which...

    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!

    January 12, 2012 at 10:21 am

    #1432750

  • RE: Dropping Image column

    for something similar, we've created the parallel table without the image column, migrated the data, then renamed the old vs new table, and after we were sure everything was beautiful,...

    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!

    January 12, 2012 at 10:18 am

    #1432743

  • RE: Creating million row test tables?

    i have a very slight variation of Cadavre's same table; i keep it as a static table, and use it for masking data for testing.

    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!

    January 12, 2012 at 10:17 am

    #1432742

  • RE: Why msdb.dbo.sp_send_dbmail is not working for me? Thanks.

    so you have a linked server for ISCSGSWEBUP01, right?

    did you specify which credentials should be used when accessing it?

    could it be that YOU, as a sysadmin, have matching credentials 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!

    January 12, 2012 at 10:15 am

    #1432740

  • RE: OPENQUERY Query :p

    i think it has to do with the way you have the linked server set up;

    if you look at it graphically, you want to make sure the radio button that...

    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!

    January 12, 2012 at 10:12 am

    #1432738

  • RE: database mail Error

    can you show a screenshot of your dbmail profile you created? that might give us some more information.

    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!

    January 12, 2012 at 10:05 am

    #1432734

  • RE: Question

    i like to use a company and contact as examples.

    a Company is an entity.

    a table describing that entity, might include fields for the name, address, website and more.

    then an...

    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!

    January 12, 2012 at 9:45 am

    #1432705

  • RE: database mail Error

    wissam ismail (1/12/2012)

    it worked on outlook, but not on SQL database Mail :angry:

    oops spoke too soon then.

    Jacks suggestion on checking the firewall is the first thing to check.

    if that 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!

    January 12, 2012 at 9:40 am

    #1432694

  • RE: database mail Error

    wissam ismail (1/12/2012)

    hi,

    I added the configuration same as I tested it and worked on outlook!

    sweet! i was just about to post something about "Could not connect to mail server." and...

    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!

    January 12, 2012 at 9:28 am

    #1432673

  • RE: What is Prod,Dev and Test servers?

    jr.sqldba (1/12/2012)

    Thank you lowell

    you are very welcome! good luck!

    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!

    January 12, 2012 at 9:27 am

    #1432667

  • RE: database mail Error

    also, doublec check which email address you are using.

    i know, for exmaple, from one of my mail servers, my from address must be the same as the email address realted...

    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!

    January 12, 2012 at 9:22 am

    #1432657

Viewing 15 posts - 6,091 through 6,105 (of 13,460 total)