That would depend on how you're generating the messages. Are you talking about the number of rows affected and "Query Completed", or about custom messages from the proc?

You can't,...

That's usually set up at the server level, not through a script. I'm used to clustering being monitored by the servers involved. Don't think I've ever seen it...

The only real limit on how much data your databases can hold is the size of your hard drives, unless you're using Express edition. If you're using Standard or...

Where I've seen this before, it's either been data already in the table conflicted with the new insert, or the new insert wasn't as clean as expected.

Have you simply run...

I'm not sure. I always use integrated (Active Directory) security, so I've never run into that.

Not if you gave it the same name.

What it excludes will be based on values in the EmpCalcOT column. Set up the Where clause to include the values you want in that column, and it'll work.

I can't imagine not unit testing. Unit testing is how I taught myself T-SQL in the first place.

That's not to say that it always catches everything, but it sure...

Drop the PK constraint.

Add the UID column, add a PK constraint to that.

Drop the old ID column.

Would look like this:

select ...

from Companies

where CompanyID in

(select CompanyID

from Addresses

where Address1 like '%' + @Variable...

I have an automatic defragmentation routine for indexes that checks number of pages (> 1000), fragmentation level, and check sys.dm_db_index_usage_stats (taking uptime into account). If the index has very...

Change "c5 != 1" to "EmpCalcOT != 1" in the Where clause.

Paul White (11/6/2009)

---

Please also consider using an SSIS package to import data from files to a database - that is its primary purpose in life, and I don't like to...

Is the JPG stored in binary column? If so, you would first limit the search to tables that have binary columns.

Restore with a different name, then copy the table from that database to the main one.

When you do a restore, you pick the database name. Name it something like...