I really like the "Inside SQL Server" books. they do a great job of explaining the native SQL backups and I beleive it also covers maintenance plans. It's a great...

I think you would be better off looking at GROUP BY and ALL in BOL to find your answer.

sp_changeobjectowner [ @objname = ] 'object' , [ @newowner = ] 'owner'

2006-12-12 09:04:42.26 spid172   Using 'LEServer.dll' version '0503.90.00' to execute extended stored procedure 'xp_LEServer_Load'.

That's the line in the logs. Yes, we do run Lumigent, and I just installed it, so that...

you just run the command he gave you replacing "mytable" with the name of your table and "foo" with the column name that you need to filter your records on

I'll be driving to chicago to visit friends - It's going to be cold up there, but since I have never been there, it should be fun regardless - Happy Hollidays!!

backup log with truncate only means that it basically throws out the inactive part of the log, essentially taking away any chance of point in time recovery. it's usually used...

Even stranger yet, when I go into the sqlserver agent properties, I can set the profile that uses and it's fine, but I can't set the profile for sqlserver service(through...

I saw a demo of a product that did exactly what you are talking about here. It was very cool, would love to get it into out budget

is sqlservercentral still going to have PASS SQLServerCentral.com receptions in the future? Much fun to be had at those

We use quest performance analysis. It works great for that type of thing as well as identifying performance problems. I think it can be done with perfmon, but automating it...

I have only seen long running queries cause this.

Congratulations - I love the site and I hope nothing much changes. I know it's a big possibility with a sale like this and I just hope that redgate doesn't...

Excellent - thanks for the clarification

No, the error message does not contain an IP address, just what user name was attempted. do you know how I could get an IP address on a failed SQL...