Forum Replies Created

Viewing 15 posts - 6,106 through 6,120 (of 13,460 total)

  • RE: database mail Error

    wierd; you are getting the same error as before when you look in failed items?

    SELECT

    err.[description],

    fail.*

    FROM [msdb].[dbo].[sysmail_event_log] err

    inner join [msdb].[dbo].[sysmail_faileditems] fail

    ...

    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:18 am

    #1432649

  • RE: Sorting issue when deployed

    glad you got it all sorted out!

    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:14 am

    #1432644

  • RE: database mail Error

    wissam ismail (1/12/2012)

    Hi

    I have set up database mail.

    I know the settings are correct because I use the same ones for MS Outlook on the same machine.

    I am getting the following...

    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:02 am

    #1432619

  • RE: Script Wizard - DML Triggers

    it might be easier to simply do it via TSQL:

    select definition from sys.triggers

    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 8:56 am

    #1432610

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

    The idea is related to workflow and testing, and making sure you have a decent (rigid) testing dfunctionality before anything gets deployed to "production"

    first, what are we trying to avoid:...

    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 8:45 am

    #1432590

  • RE: Logon Triggers. A good idea? Or a nerve-racking exprience?

    I'm under the impression that by using the default parameter, it reads all the automatically created rollover files.

    http://msdn.microsoft.com/en-us/library/aa258856(v=sql.80).aspx

    Users may specify the default value "default" to tell SQL Server to...

    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 7:53 am

    #1432529

  • RE: Logon Triggers. A good idea? Or a nerve-racking exprience?

    here's a snippet that woudl generate a CREATE view statement for your traces;

    default naming convention of VW_TRACE_[traceid]

    SELECT

    ' CREATE VIEW master.dbo.VW_Trace_' + CONVERT(varchar,id) + '

    ...

    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 7:20 am

    #1432493

  • RE: Logon Triggers. A good idea? Or a nerve-racking exprience?

    GSquared (1/12/2012)

    But you can query trace files directly, without the import step, by using fn_trace_gettable(). That's what I usually do.

    taking that one step further, since you can directly query...

    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 7:18 am

    #1432492

  • RE: Sorting issue when deployed

    does your dataset have an ORDER BY?

    remember, there is no "default" sorting.

    if you do not explicitly order your results, there's no guarantee they will be in any given order.

    SQL would...

    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 6:35 am

    #1432430

  • RE: Convert date format in SQL sever report(BIDS) with Oracle date format

    when i said parameters, i mean on the report side, sorry for the confusion.

    if you are building a string and executing it from your report, without parameters, you need to...

    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 11, 2012 at 5:22 am

    #1431721

  • RE: run stored proc against selected databases.

    Oracle_91 (1/10/2012)

    Hi Lowell,

    This is working perfectly. I am using sql 2005 and sql 2008. However i have few questions.

    1. How to unmark the stored procedure as system proc if i...

    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 11, 2012 at 4:42 am

    #1431704

  • RE: Convert date format in SQL sever report(BIDS) with Oracle date format

    you parameters are datetime in the report, right, so they will convert cleanly to the DATE datatype for oracle?

    It sounds like you are using varchars instead...

    if your parameters are 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 10, 2012 at 8:39 pm

    #1431545

  • RE: Management Studio Foreign Key constraints don't show up.

    excellent, thanks Paul!

    added to my 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!

    January 10, 2012 at 5:51 pm

    #1431525

  • RE: run stored proc against selected databases.

    without using dynamic SQL, you need to rename it to be sp_* and simply want to mark the procedure as a "system" procedure.

    use master

    go

    --any proc starting with sp_ 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 10, 2012 at 5:48 pm

    #1431523

  • RE: Management Studio Foreign Key constraints don't show up.

    SQL Kiwi (1/10/2012)

    They're in the keys folder, and also have a different icon in the columns folder.

    what app did you use to make the "tearing" with the drop shadow? ...

    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 10, 2012 at 5:41 pm

    #1431520

Viewing 15 posts - 6,106 through 6,120 (of 13,460 total)