ok will do ...thx

Great thx hanShi...

would something like this work as i want an email and restart to happen ?

IF not exists( SELECT * FROM ::fn_trace_getinfo(2)

...

If i want to exclude SYSLOGINS , not necessarily NTusernames as defined within the instance it looks like its this

exec sp_trace_setfilter @TraceID, 11, 0, 7, N'xxxxxxx'

Actually I would need to restart the trace automatically if it stops for whatever reason.

So would this be the syntax ?

IF not exists(SELECT * FROM ::fn_trace_geteventinfo(2))

BEGIN

EXEC...

Thank you !

JR

correct

yep the column is in a "datetime" format

The question is that I have to perform a select on a column ( in a datetime format ) with a condition of...

Lynn... thx for your patience 🙂

Basically because a new table was already loaded and created with most account descriptions already

I can probably do that but would have to match...

Maybe 3 times is a charm , let me try again 🙂

I have a server accounts table called ALLDB_syslogins_Sql2008 whereas I gather information hourly from other servers though a agent...

I apologize for the vagueness 🙂

What I have is table1 which has been imported externally with 4 fields including an (AccountDescription) field

srvnameAccountAccountDescriptionDATE_CREATION

-----------------------------------------------------------------------------

I need to be able to copy only 3...

Much appreciated !

I actually tried it the import data wizard and recreated the table with the necessary columns by loading all the respective rows... now I will just work...

Thanks for that !

exactly what i needed

I was just told to schedule a weekly stop and restart of this configured trace and therefore must put it in as an agent job.

Lowell (3/20/2013)

---

johnnyrmtl (3/20/2013)

---

Since the trace will never be closed and it will be started via command line , how would I go upon this if at all possible in validating...

Thanks for that !

I will review and see what I can do and get back to you.