not sure about an Alert, but certainly from a scheduled job; i simply use IF EXISTS...sp_send_dbmail

i use this a lot actually, here's a rough example:

IF EXISTS(SELECT *

...

for reference, this DDL trigger worked for me;

ALTER TRIGGER [Create_Database_Trigger]

ON ALL Server

WITH EXECUTE AS 'sa'

FOR Create_Database -- Captures a Create Database Event

AS

DECLARE

...

somewhere in there you need something like this: that was a partial from my own version of a DDL trigger:

DECLARE @msg XML

SET @msg = EVENTDATA()

--replace also msg. with @msg.

GilaMonster (11/14/2011)

---

Err, no. Look at the EventData function that's available in DDL triggers. From that you can extract the actual command run, who ran it, from where, etc, etc, no...

sounds like a networking issue with the WINS(Windows Internet Name Service)

are you on a network with a primary domain controller providing that service, or just happen to be on a...

kewl! where can i download that?! 😀

no, there's no...

WinMerge has a great GUI, windiff can be called forma command line, they are for comparing two text files for differences...is that what you are after?

i think the issue is related to teh name not being #tbl_temptable, but actually [#tbl_temptable[100underscores]0000000000F0]

for example. if you do this after you know your table exists :

SELECT table_name,

column_name 'Column...

the INTO belongs outside of the openquery:

CODE

SELECT *

into #tlb_testfile

FROM OPENQUERY(test_TERADATA,

'select *

from databse.file

where

datacode=''49548''

;')

if you have a datetime column for WHEN the data was actually entered, you could compare that to a TallyCalendar table(which you wanted to avoid) and get the DST offset.(ie...

sp_changeobjectowner 'wrongschema.procname','dbo'

a lot of the work around examples so far would return false positives if the values are two or more digits, thought right? 2|5|21|23|55 for example

redesign, or split the data...

there. fixed it for you. 😛

ok peers: poke holes in this: this seems to do what the oldstype autfox would do, right?

well...this just generates the statements...i'd have to execute them:

SELECT CASE

...