Forum Replies Created

Viewing 15 posts - 5,656 through 5,670 (of 13,460 total)

  • RE: script to find orphan records on single DB

    Lynn Pettis (4/3/2012)[hr

    I think the pointers may be to files stored elsewhere, not to data in the database.

    [/quote]

    must be a long day; i'm still not reading the requirement right yet.....

    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!

    April 3, 2012 at 3:11 pm

    #1468545

  • RE: script to find orphan records on single DB

    ricardo.cuevas (4/3/2012)

    Greetings. Long time lurker first time poster. BTW I love this site. Very professional and educational. I'm looking to find orphan records on a single...

    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!

    April 3, 2012 at 3:04 pm

    #1468539

  • RE: query for consecutive alphabets

    Is there an easier way to determine "good" vs "garbage"?

    would it be a solution to find values not in the dictionary, or values that do not pass a spell check...

    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!

    April 3, 2012 at 12:21 pm

    #1468419

  • RE: Idera SQL Complaince - Creating Trace files

    if you want to script out the trace just in case you need to put it back again, I've posted a very nice TSQl for it you can find here:

    sp_ScriptAnyTrace.txt

    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!

    April 3, 2012 at 10:46 am

    #1468349

  • RE: Idera SQL Complaince - Creating Trace files

    do a quick SELECT * FROM sys.traces

    if you have C2 auditing on, id=1 is the c2 trace, and id=2 is the default DDL trace;

    otherwise id=1 is the default DDL trace.

    everything...

    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!

    April 3, 2012 at 10:43 am

    #1468346

  • RE: Rights Required to Send Mail with Attachment in SQL Server 2005

    pammu (4/3/2012)

    Thanks for your quick reply.

    mentioned rights given to the user and after executed the send mail query i am getting the below mentioned error. May be it needs some...

    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!

    April 3, 2012 at 7:12 am

    #1468191

  • RE: 2008R2 Foreign Keys Don't have cardinality

    to make it 1:1, you simply add a unique constraint on the child table's column that is referencing the Parent;

    so it's not a "type" of foreign key you are looking...

    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!

    April 3, 2012 at 6:56 am

    #1468183

  • RE: Rights Required to Send Mail with Attachment in SQL Server 2005

    your user "TEST" needs to also be a user in the msdb database.

    that user needs to be in the DatabaseMailUserRole which exists in that database.

    something like this is 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!

    April 3, 2012 at 6:26 am

    #1468164

  • RE: Database Mail does not work on New Server

    I absolutely did not mean to imply that you did not have any experience, and I definitely did not mean to offend you.

    If you read my post that way, I'm...

    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!

    April 3, 2012 at 4:56 am

    #1468114

  • RE: Database Mail does not work on New Server

    SQLKnowItAll (4/2/2012)

    Yup! Stepping away and observing because this is clearly not what I thought... 🙂

    I think digging at the setup for db_mail is fine; we've got to get Welsh from...

    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!

    April 2, 2012 at 3:17 pm

    #1467921

  • RE: Database Mail does not work on New Server

    Lynn Pettis (4/2/2012)

    SSIS shouldn't have anything to do with Database Mail.

    What has me slightly confused is you talk about using Database Mail, but the code you show is using CDONTS....

    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!

    April 2, 2012 at 2:47 pm

    #1467910

  • RE: Database Mail does not work on New Server

    Welsh Corgi (4/2/2012)

    SELECT *

    FROM sysmail_event_log

    Nothing but start & stop DB Mail

    SELECT *

    FROM sysmail_allitems

    I found the items were listed as failed.

    Waia minute...you said for all...

    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!

    April 2, 2012 at 1:37 pm

    #1467865

  • RE: VBScript: ActiveX Component can't create Object CDONTS.NewMail Code: 800A01AD VBScript

    CDONTs was a com object, and that error says it's not registered yet;

    you may need to copy the dll to the server, and then register it.

    http://www.jppinto.com/2009/03/install-cdonts-mail-component-and-smtp-on-windows-server-2008/

    I know from your outer...

    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!

    April 2, 2012 at 11:42 am

    #1467771

  • RE: Create user defined database role for create and alter views

    ravisamigo (4/2/2012)

    Hi All,

    How to create a user defined database role to give create and alter permissions only on views.

    Please advise.

    Thanks and Regards,

    Ravi.

    Ravi take a look at this thread on 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!

    April 2, 2012 at 4:34 am

    #1467549

  • RE: FK referencing PK in *same* table

    we have that in a few tables;

    it's usually something like an Entity and need to to identify the "prime" entity,

    an example might be a table of bank names,...

    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!

    March 30, 2012 at 12:35 pm

    #1467138

Viewing 15 posts - 5,656 through 5,670 (of 13,460 total)