Forum Replies Created

Viewing 15 posts - 6,601 through 6,615 (of 13,460 total)

  • RE: E-mail notification for creating new db through triggers

    one of the more advanced features in SQL Server is the ability to use Extended Events.

    those events allow you to capture certain events and respond to them asynchronously, like logging...

    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 7, 2011 at 1:09 pm

    #1391942

  • RE: E-mail notification for creating new db through triggers

    shilpa.shankar87 (10/7/2011)

    Hi Friends,

    Is there any way to get email notifications from triggers if any new db is created in the sql server?

    Thanks in advance.

    you would have to use Extended...

    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 7, 2011 at 11:36 am

    #1391894

  • RE: SQL Server Side trace stop

    when the trace is running and active, the operating system will not be able to report the file size, so it's not suprising it's still showing 0kb;

    only when a rollover...

    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 7, 2011 at 11:31 am

    #1391888

  • RE: Database Mail + Linux?

    WaitingWonder2 (10/1/2011)

    We use Database Mail with gmail account to send email. Our clients uses mail server based on Linux. Is it possible to use Database Mail and mail server 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!

    October 6, 2011 at 12:49 pm

    #1391413

  • RE: Aging Payments query help

    Tom would some4thign like this bee what you are looking for?

    select

    InvoiceNumber,

    InvoiceDate,

    Month(InvoiceDate) AS Mn

    from sometable

    where InvoiceDate < dateadd(dd,-45,getdate)

    Group By

    InvoiceNumber,

    ...

    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 6, 2011 at 11:15 am

    #1391343

  • RE: Pls help me

    Ninja's_RGR'us (10/6/2011)

    Lowell (10/6/2011)

    Ninja's_RGR'us (10/6/2011)

    you're telling the server to do this, which is impossible :

    update set colum = (SELECT col1, col2, ... FROM )

    sigh...Ninja'd again...well deserved nickname, for sure.

    Well you...

    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 6, 2011 at 6:32 am

    #1391169

  • RE: Pls help me

    Ninja's_RGR'us (10/6/2011)

    you're telling the server to do this, which is impossible :

    update set colum = (SELECT col1, col2, ... FROM )

    sigh...Ninja'd again...well deserved nickname, for sure.

    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 6, 2011 at 6:24 am

    #1391165

  • RE: Pls help me

    i think the issue is this:

    SET LMTD_TRCDMA = (SELECT C.CRT_Cod,

    ...

    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 6, 2011 at 6:23 am

    #1391164

  • RE: badpassword count is 0 inspite of valid badpasswordtime

    doesn't a successful login set the badpassword count to zero?

    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 5, 2011 at 1:37 pm

    #1390913

  • RE: Loop within a loop... BUT...

    ugg;

    stick to the data ...without the data we cannot help.

    lets forget all about formatting, cursors, everything...for now.

    does this return all the records that should receive an email?

    it's ok if 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 5, 2011 at 1:07 pm

    #1390897

  • RE: Are the posted questions getting worse?

    i see differences on most of my servers, too; one server is under two seconds, others as much as 37 seconds:

    also, i got overflow adding the milliseconds, so i had...

    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 5, 2011 at 10:50 am

    #1390824

  • RE: Loop within a loop... BUT...

    donato1026 (10/5/2011)

    Not to be a pain, but I did post a sample of what I am looking for... it isis above.

    And thank you SO much for your time!

    i could help...

    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 5, 2011 at 10:35 am

    #1390813

  • RE: inserting data into views

    ok, based on your specific example now,

    you can see you are not providing the Table1.ID, which joins Table@ and Table1 together.

    so you end up inserting NULL,[name] from INSERTED, so...

    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 5, 2011 at 9:10 am

    #1390746

  • RE: How to replicate BLOB (PDF & XML) files and how to extract them

    kenyangyiwei (10/5/2011)

    Receive means a new row of BLOB objects arrive at receiver SQL Server Database, how to check that? is it best to use trigger event or build a stored...

    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 5, 2011 at 7:39 am

    #1390675

  • RE: Connect to 4D via OLE db or ODBC

    i used my Google-Fu on "linked server 4D database" and "4d database ODBC driver", thinking that should get what you need

    this link seemed to have an example of creating...

    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 5, 2011 at 7:20 am

    #1390655

Viewing 15 posts - 6,601 through 6,615 (of 13,460 total)