Viewing 15 posts - 8,011 through 8,025 (of 13,469 total)
LutzM (3/3/2011)
Duplicate post. No replies please.Original post can be found here
March 3, 2011 at 2:50 pm
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...
March 3, 2011 at 2:45 pm
ok, still not an issue; read the file from the database, and recreate the view as needed:
--we want the current trace folder
declare...
March 3, 2011 at 2:43 pm
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...
March 3, 2011 at 1:08 pm
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...
March 3, 2011 at 12:34 pm
opc.three (3/3/2011)
Just FYI using NOLOCK in an UPDATE or DELETE statement has been marked as deprecated in SQL 11 (Denali).
and this command still works with the missing WITH in 2005/2008;...
March 3, 2011 at 12:32 pm
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...
March 3, 2011 at 11:58 am
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...
March 3, 2011 at 11:47 am
--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
...
March 3, 2011 at 8:44 am
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...
March 3, 2011 at 8:29 am
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...
March 3, 2011 at 7:56 am
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...
March 3, 2011 at 7:26 am
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...
March 3, 2011 at 7:18 am
Viewing 15 posts - 8,011 through 8,025 (of 13,469 total)