theres an application out there called What's Up!, which does what you are asking for...tests servers and services on those servers, and notifies people if anything goes down.

last i heard...

ok, still not an issue; read the file from the database, and recreate the view as needed:

--we want the current trace folder

declare...

what i would suggest do is on the server itself, create a VIEW that selects the data from the trace; the view would run under the context of the owner...

why cant you just use find and replace in a text editor or SSMS before you run the command? there cannot be that many defaults you have to change; just...

and this command still works with the missing WITH in 2005/2008;...

the UPDATE command is really misleading...it only identifies if the column was specifically listed int eh column names of the update. It does not tell you if it changed or...

I agree with Coldcoffee; no significant difference.

Also i think i read in the future versions directives like that in the future will require the "WITH (nolock)" format, instead...

i think using the row_number function is the right way to tackle this; note i went to the trouble of putting your data into a consumable format; It helps you...

--a query as an attachment to the email

declare @body1 varchar(4000)

set @body1 = 'Sample Email from SQL2008 ' + CONVERT( VARCHAR( 20 ), GETDATE(), 113 ) +

' '

EXEC msdb.dbo.sp_send_dbmail

...

you have to have setup database mail before you can use it.

in SSMS, under the "management" folder, find Database Mail

you have to create a profile, and also at least one...

the parameters are comma delimited, you have a semi colon before @message.

change to a comma.

also, this param is spelled wrong:

@receipent

and i think you might need more parameters; see the...

naveedanjum1 (3/3/2011)

---

0 down vote favorite

I am working with a database name xyz , table name a ,b, c, d. my question is if in table a name field , table...

via SSIS, it's not possible; you'd have to automate excel in order to do that: formatting codes for excel cells are not exposed.

see this thread for Koen's more complete answer:

http://www.sqlservercentral.com/Forums/Topic1069138-148-1.aspx

a...

if your code is centralized, meaning all inserts occur in a single point of entry, like a stored procedure, then adding the email code to that stored procedure makes sense.

if...