Forum Replies Created

Viewing 15 posts - 7,471 through 7,485 (of 13,459 total)

  • RE: If column exists

    the problem is the engine validates all objects mentioned in a script...regardless of if-then-else logic ; so if it doesn't exist at the moment it validates all objects 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!

    June 2, 2011 at 2:00 pm

    #1333378

  • RE: Database Mail setup

    Tara-1044200 (6/2/2011)

    is there a way to script out the setup and run the same on a differnt server. I have to create mail setup on mutiple server and its 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!

    June 2, 2011 at 12:40 pm

    #1333302

  • RE: trace?

    I'm assuming you used my example as a partial model?

    my knee jerk reaction was to use EXECUTE AS SELF to avoid permissions issues, and that seems to mask some of...

    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!

    June 2, 2011 at 9:16 am

    #1333169

  • RE: Scripting objects log

    Ramdas Baghel (6/2/2011)

    please try DDL Triggers if you having SQL Server 2005 or Higher

    that won't work...scripting is a DML operation, where it goes out and selects the details for 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!

    June 2, 2011 at 4:25 am

    #1332994

  • RE: Composite primary key

    patla4u (6/1/2011)

    Table:1 CS(customer)

    CS_customer_id,

    CS_customer_code

    CS_customer_br

    Table 2 CD(costomer desciption)

    CD_customer_id

    CD_customer_code

    no explanation whatsoever? another repeat of a schema?

    if you cannot explain what you want, we cannot explain how to do it. please see my...

    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!

    June 1, 2011 at 2:56 pm

    #1332822

  • RE: Composite primary key

    wouldn't do any good.

    you need to help us help you.

    go back to the beginning...we know table1 has a three column PK.

    another table has two out of three columns of 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!

    June 1, 2011 at 2:43 pm

    #1332813

  • RE: Database Mail error

    my google-fu pointed me to an issue where SQL server Agent needs to be restarted, based on this MS article?

    http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/32a2c09a-156f-43b2-9076-b11ba9ccdafb/

    do you think that could be the issue? that db mail...

    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!

    June 1, 2011 at 2:38 pm

    #1332809

  • RE: sys.dm_exec_request showing negative total_elapsed_time

    mohan.pariveda 18256 (6/1/2011)

    Thanks for the reply. According to your reply if i am not wrong, all my sessions need to show in negative times but it is not.

    Only...

    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!

    June 1, 2011 at 2:14 pm

    #1332787

  • RE: Composite primary key

    patla4u (6/1/2011)

    Thanks

    i don't want to join tables but I want to create relation.

    Is there any other way to create relation(foreing key constrain) like junction tables????

    Thanks

    L

    nope. a foreign key must...

    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!

    June 1, 2011 at 2:11 pm

    #1332780

  • RE: Composite primary key

    don't just re-paste the same question...that doesn't help at all.

    two tables can be JOINed via a SQL statement, and that join is not restricted at all...it can join 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!

    June 1, 2011 at 1:59 pm

    #1332770

  • RE: Composite primary key

    patla4u (6/1/2011)

    I am sorry ,,,,but I want to create relationship with two tables.

    Means composite primary key to composite foreign key ????(it's not working)

    SO how can i create relationship with table...

    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!

    June 1, 2011 at 1:51 pm

    #1332762

  • RE: accidental DBA needing help

    unless you alias the table, you must use the whole 3 part naming convention(Database.Schema.Table.ColumnName) toi identify the columns in the joins:

    here's the right way, and then again with aliases for...

    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!

    June 1, 2011 at 1:48 pm

    #1332758

  • RE: Find out who dropped a table in a db that's in simple mode.

    dunno about most folks; since it's on by default, and it's a low impact trace, i'm under the impression most people don't actively go and disable it;

    I personally think there...

    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!

    June 1, 2011 at 1:44 pm

    #1332755

  • RE: Composite primary key

    you can join the two tables on two of the three criteria, but you can potentially get duplicates due to the third column

    unless you assume/infer a specific customer_br?

    ...

    LEFT OUTER JOIN...

    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!

    June 1, 2011 at 1:41 pm

    #1332751

  • RE: Converting data to wav format

    Sean Lange (5/31/2011)

    Pretty sure this article will provide you with some useful information.

    nice link!

    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!

    June 1, 2011 at 1:37 pm

    #1332747

Viewing 15 posts - 7,471 through 7,485 (of 13,459 total)