Create one trigger FOR INSERT and put the insert logic in that, create a second trigger FOR UPDATE and put the update logic in there.

Post it on Connect and see how people vote. Posted here the dev team isn't going to see it.

p.s. Why drop, create, fix permissions at all? That's what ALTER is...

wodom (3/11/2010)

---

That would seem to imply that to avoid the extra work, maybe it's better to have no clustered index, in which case SQL Server can always use the row...

Statistics are generated when the query optimiser needs to know cardinality of a column...

So if I have a server with only 2GB of memory in it, I can't give...

I think the safest thing here would be to script out all your jobs, alerts and anything else in MSDB and rebuild it. There are scripts available online (on MSDN...

Please post new questions in a new thread. Thank you.

If you want a list of what pages are allocated and what aren't, there's no documented way. You could use DBCC Page (undocumented) on all of the GAM and SGAM...

May I suggest, going forward, that you institute regular database integrity checks. Regular enough that, should there be a problem, restoring from backup is always an option.

Also keep in mind...

I'm kinda curious how that could happen. All the system databases should have the same collation. Did you restore MSDB from somewhere else?

What's the server collation and what are the...

Please post new questions in a new thread please, giving as much detail as possible as to what's wrong.

Truncate_only will only reduce the size of the DB is there's free space at the end of the file. Shrinkdatabase will move pages to the beginning of the file and...

Nasty.

You should do some root-cause analysis of this, otherwise it may happen again. See if there were any errors logged around the time that the DB went suspect. SQL...

Paul, is this in the SQL error log or the SQL Agent error log? If the latter, it narrows it down to something that Agent is running across. Does MSDB...

Very easily. Restore a database from another server where the server collation was different. Attach a database with a...