Forum Replies Created

Viewing 15 posts - 8,506 through 8,520 (of 13,460 total)

  • RE: Diagnosing Errors in [msdb].[dbo].[sysmail_faileditems]

    Thank you for the script and the link to the other thread;

    I especially liked the snippet for resending failed mails that WayneS posted; good to have that in the toolbox.

    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!

    October 22, 2010 at 8:25 am

    #1240952

  • RE: Diagnosing Errors in [msdb].[dbo].[sysmail_faileditems]

    ok, post coffee, with a clearer head, i found the answer.

    the table sysmail_event_log, has the error description and the mailitem_id, so you can join it to failed items and see...

    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!

    October 22, 2010 at 7:35 am

    #1240907

  • RE: Automatically check results of DBCC CHECK DB

    nice proc Gianluca; i added that to my snippets.

    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!

    October 22, 2010 at 7:30 am

    #1240901

  • RE: which cmd or function can transfer printed message to a sql file?

    Jeff's right on target.

    no matter what, if a message was generated by SQL(i.e. #row(s) affected or PRINT statements), you cannot read it into a variable with TSQL, whether you wanted...

    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!

    October 22, 2010 at 7:01 am

    #1240878

  • RE: Silverlight cannot connect to production SQLServer

    here's my first guess, when covering the basics.

    your server has a hyphen in it's name. that causes problems, in my experience.

    i think the connection will have problems with that unless...

    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!

    October 22, 2010 at 5:49 am

    #1240834

  • RE: which cmd or function can transfer printed message to a sql file?

    lvzheng (10/21/2010)

    thank you ,but i want a function or procedure to meet that

    you won't be able to capture the messages via TSQL. the information is generated, but not capturable via...

    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!

    October 21, 2010 at 8:18 pm

    #1240681

  • RE: Hashing data in existing schema

    you cannot change the datatype, but can you change the size?

    for example, a 8 letter password using AES requires 40 characters to store the hashed value...

    so if you cannot 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!

    October 21, 2010 at 2:37 pm

    #1240598

  • RE: migrate linkedserver

    I think the original poster is out of luck.

    when you script a linked server, you get this specific comment/message, telling you that it won't script the password:

    /* For security reasons...

    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!

    October 21, 2010 at 2:32 pm

    #1240594

  • RE: Updating a table

    camiloaguilar1 (10/21/2010)

    I got that clear but I did not explain it that good, I create that table in temporal way. The goods are already with the client to so modifications...

    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!

    October 21, 2010 at 1:57 pm

    #1240568

  • RE: select

    Tara-1044200 (10/21/2010)

    how would you get the rest of the databases?

    i updated my post with a second sql, probably while you were reading the first version of the post...so the second...

    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!

    October 21, 2010 at 12:26 pm

    #1240512

  • RE: Updating a table

    camiloaguilar1 (10/21/2010)

    Because we have a lot of order details from a sale. So for no wasting of lot of order papers we want to make 1 order from all the...

    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!

    October 21, 2010 at 12:23 pm

    #1240507

  • RE: select

    Tara-1044200 (10/21/2010)

    i tried "top 50 percent" but i does not work with distinct and also for bottom 50%

    on my db with 51 databases, this gives me 26 rows: what does...

    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!

    October 21, 2010 at 12:15 pm

    #1240500

  • RE: Wierd one..

    make sure you are comparing the actual execution plans, and not the estimated plans....

    the estimated woudl probably be teh same on both, but the performance issue is in the actual...where...

    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!

    October 21, 2010 at 12:12 pm

    #1240498

  • RE: Updating a table

    well you didn't provide any examples of what was going wrong;

    here's the data you posted in a consumable format, as well as a query that pulls the data you were...

    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!

    October 21, 2010 at 11:57 am

    #1240491

  • RE: Alter multiple Table

    Please don't crosspost. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1008657-391-1.aspx

    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!

    October 21, 2010 at 11:12 am

    #1240474

Viewing 15 posts - 8,506 through 8,520 (of 13,460 total)