Take a look at these two articles:

http://www.sqlservercentral.com/articles/Auditing/63247/

http://www.sqlservercentral.com/articles/Auditing/63248/

And this discussion thread:

http://www.sqlservercentral.com/Forums/Topic536927-145-2.aspx

There's a lot of data about auditing and triggers in those. You should be able to come up with something...

Glad I could help.

Probably the better way to do this is to have the update proc called by the front end do the messaging. If you absolutely have to have it in...

SQL Mail isn't the same as DB Mail, if I remember correctly.

How are the jobs trying to send the e-mail? How were they set up?

Means there's something at that point in the import document that's too big for the field it's going into.

Val Byref (7/24/2008)

---

I know I'm going to regret this, but some masochistic bent is making me type this: why does it seem to be the general premise that Americans...

SQL Server. Did it with the wizard in Management Studio.

Disk mirroring wouldn't be a test of the truncate command.

After you set the value for @WeekEnd, do something like this:

if datepart(month, @WeekStart) < datepart(month, @WeekEnd)

select @WeekEnd = dateadd(day, -1 * datepart(day, @WeekEnd), @WeekEnd) + 1

That'll give you...

Model isn't really a system database. It's a template for user databases.

That's why I say that one should be fine.

MSDB, I wouldn't do a backup/restore, I'd do an insert...select...

I've tested the syntax of the command I suggested, through xp_cmdshell, and it works.

If the folder name has spaces in it, it needs to be in double-quotes.

You also need to...

Just the difference in RAM alone will often result in much slower performance on that machine.

What types of CPUs do they have? Is either one dual-core (or more)?

Without the code you've got so far, it's hard to tell you what to fix, so I'm kind of guessing here.

Can't you modify the query to exclude data after the...

Model should be fine. I'd be careful about Master. MSDB should be fine.

Why not install Standard, copy the databases over, then do an in-place upgrade? Is that...

Whatever rights you've given "public", which is pretty little by default.

The main difference is that the output parameters will only get the last value passed to them, if you have more than one row that fits the Where clause, while...