Ah, too humid in Houston. And you could easily be playing golf at Christmas in Denver. It was sunny and 60s last year. Kids outside in shorts.

Seattle is too...

Jeff,

I think you're right with IM for those unfamiliar with each other is hard. But for those that work together and know each other, you'd be surprised how much communication...

Very nice. Notice they didn't mention if he got the job.

That's strange. I've never seen that, but I'd suspect that it's a Windows issue with mapping types than a SQL one.

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