It's fixed . The publisher sent it to me and I missed it.

Yelena,

I believe that if you modify the plan in SSIS and save it back, it cannot be opened in the maintenance plan designer in SSMS.

Thanks for the reference. I know Project REAL was a big deal and I think its a great win. I wish Microsoft would do a few more like that.

Bob,

I apologize if you're offended, but it wasn't intended as a political commentary. More that data issues are a problem and I'd hate to think that anyone trusts incorrect data,...

That's interesting. Thanks for the update.

You can redistribute SQLExpress/MSDE for this purpose and use merge replication or custom scripts to make data synch up with a central server. The downside is limitations on size with...

What does your trigger look like? If it is set properly there should be no way to add new rows without capturing this.

You might need to trace EM and see what it is pulling. I suspect there might be a big somewhere or it is pulling from another location, like the original...

Maybe a TOP 1 from sysprocesses?

I'd think you could use suser_sname() for the user name. For the MAC I think you are stuck with sysprocesses.

If your connections are from AD authenticated machines/users, i.e. employees, you need a CAL for each user that accesses the machine. Usually when you purchase SQL Server, you get a...

As far as I know, you can determine if a clustered index and therefore the table data is on a filegroup with this script:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1499

DTS or linked server would be my suggestion.

SSC

If you really need clustering, be sure that you benchmark your 30 servers and have enough hardware to support it. The clustering, unless you are geographically dispersed, won't give you...

I think there would be some gas savings, more it would be a personal savings for lots of people. As for the environment, avoiding those plane trips would save way...