it's up to you; you can combine the functionality in the same trigger.

I'd just make a second trigger, but it is up to you.

i noticed your trigger will not send...

I'm curious; someone went to a lot of trouble to create 2000 jobs. what is your reason for wanting to delete them now? are you replacing them with something new?...

well, somehwere in your code, you have these two variables declared; just change their definition to a bigger value:(and make sure @msg is HUGE to hold the concat of these...

looks like it's just a syntax error because of some double quotes; the double quotesd belong inside the single quotes to create the string.

assuming you wanted double quotes around the...

also, isn't the implicit conversion of left(getdate() -1,11) dependent on the servers regional settings? I think that makes an assumption on the regional settings that might not be true...

usually, linked servers do not allow DDL commands; only DML insert/update/delete/select.

AFAIK, you can't even create temp tables on a SQL linked server, fir example, which i would think would be...

no, sorry.

the intellisense works only using 2008 client tools connecting to a 2008 instance; the same tools, when connecting to a pre-2008 instance do not enable themselves.

Great Plains is an application which can use SQL Server as it's database.

Great Plains versions 5 through 6 offered a number of database options, including c-tree, pervasive, and MSSQL...

keep in mind that if someone is restoring the database, the restore point might not have the users you are adding back constantly; that's a probable thing to look for...

remember getdate returns the time portion of NOW: 2010-03-26 12:18:05.390

you want to start at midnite yesterday, not 12:18 of yesterday.

and another way:

--2010-03-25 00:00:00.0002010-03-25 23:59:59.997

select DATEADD(dd, DATEDIFF(dd,0,getdate()), -1),

...

all the levels can be found in this thread:http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx

Forum Newbie - 0

Grasshopper - 10

SSC Rookie - 25

Valued Member - 50

SSC Journeyman - 75

SSC-Enthusiastic - 100

SSC Veteran - 200

Old Hand -...

There's a couple levels of auditing to consider.

using a profiler/server side trace would capture the commands against the table, but not the data itself. That's idea for determining things like...

thanks Paul; awesome performance on that one; i added that to my toolbox; excellent solution.

irena did you use sp_create_trace to make a trace, or did you use profiler?

a trace created with sp_create_trace runs until it is explicitly stopped or, if it was created...

Trey already knows this...he identified it as deprecated...this is so other folks(like me) don't have to google it.

the DUMP word was deprecated in favor of BACKUP; you cannot even use...