Do a search. There are probably hundreds of them. Here are a list of companies & products:

Microsoft System Center Operations Manager

Cognos Ignite

Red-Gate SQL Alert

Idera Diagnostic Manager

Quest Fogloght

SQL Sentry

There are lots...

I'm with the previous poster. If you've upgraded the server itself, then no, you can't reconnect to the 2000 instance because it's not a 2000 instance any more. If you've...

This really gets down to personal preference to a large degree. Here's the question, will that two character abbreviation EVER change? If a country named the United States of Ted...

I agree. Do the backup locally and then ftp the file or whatever to the remote site. If you run backup across the internet, connection interruption, etc., could cause lots...

It only backups up the database if it's configured to and it doesn't take into account logs at all. If you want a full point in time recovery system, you...

From the sounds of things, you should be setting up a server side trace to capture the completed queries along with their performance metrics. That way you can see what...

CirquedeSQLeil (6/2/2010)

---

Sounds like a conversation I had recently.

Me: Why are we doing it that way?

other: Because it is being done this way.

Me: Why can't we do it...

Breaking my Thread-free streak...

At least his current icon is appropriate.

2-3 seconds...

Sure, Sharepoint writes it up to a varbinary data type and you can do the same. You just have to take into account that you need to stream that data...

So after you run a log backup, there is no extra free space within the log, at all?

If your transaction log continues to grow after a log backup, it sounds like your transactions are in an uncommitted state. You should see committed transactions cleared from the log...

Not to argue, but since R2 is a basically just a really big service pack, I'd suggest just leaving things alone. I think R2 can fit right into the basic...

I'm running a system that has millions of rows from about eight years of data. It's based on inserts only. It runs fine. The issue is not the amount of...

Not really. I've been posting about it on my blog for the last two years. Our project is... well, we'll see how it turns out. At the moment, I don't...