Viewing 13 posts - 16 through 28 (of 28 total)
I asked my boss if I could get rid of the milliseconds and it seems I can. So If I write the query like this:
SELECT count(1)
FROM...
August 6, 2012 at 3:00 am
This is the query I was trying first, but this doesn't work.
August 6, 2012 at 2:03 am
@j-2 LivingStone SQL
The 1st query you posted works but the second doesn't. If I try to replace the date in your 1st query by my CounterDateTime column, it...
August 6, 2012 at 1:57 am
Thanks for fast reply 🙂
You are guessing well, the first query doesn't work, the second either by the way :/
The third one tells me that approximatively all my records are...
August 6, 2012 at 1:35 am
Okay thanks for fast reply. I'm gonna try to find a workaround. I'll let you know...
Regards.
Franck
December 5, 2011 at 5:07 am
Thanks for your fast replies.
Well, I'm sure of nothing about the apps installed on application servers. I've my plan for our future architecture, but as I didn't find any best...
February 10, 2011 at 12:14 am
I supposed the table isn't "updated" every milliseconds. Because asking to receive a mail on every insert on a huge table doesn't make sense, to me...
February 9, 2011 at 8:47 am
Hi,
You could use a trigger for such a job:
CREATE TRIGGER CustomerUpdateMail
ON YourTable
FOR UPDATE
AS
declare @recordContent varchar(200)
declare @body varchar(2000)
SELECT @recordContent = recordContent
...
February 9, 2011 at 8:16 am
Since yesterday I tried different solutions to solve my problem. The solution of Lars works, indeed.
Here's another one that works too:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create trigger [newdbtrg]
on ALL Server
for...
January 11, 2011 at 12:31 am
Thanks for your reply Lars. I'll try your solution tomorrow and I'll give you feedback.
Have a nice day.
Regards.
Franck.
January 10, 2011 at 8:19 am
Hum,
Here's the code I tested:
create trigger [newdbtrg]
on ALL Server
for CREATE_DATABASE
EXEC msdb.dbo.sp_send_dbmail
@recipients='DBA@company.com',
@subject='A new database was just created !',
@body='A new database was created. Database name: ',
@query = 'SELECT TOP 1 name...
January 10, 2011 at 2:40 am
Thanks for fast reply !
If I use a job, I'll get a mail every day even if no DB was created, right ?
The purpose is to get a mail only...
January 6, 2011 at 1:51 am
Viewing 13 posts - 16 through 28 (of 28 total)