Viewing 15 posts - 33,061 through 33,075 (of 39,740 total)
It's fixed
. The publisher sent it to me and I missed it.
May 18, 2006 at 3:02 pm
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.
May 18, 2006 at 3:01 pm
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.
May 18, 2006 at 10:02 am
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,...
May 18, 2006 at 9:53 am
That's interesting. Thanks for the update.
May 11, 2006 at 6:12 pm
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...
May 11, 2006 at 10:20 am
What does your trigger look like? If it is set properly there should be no way to add new rows without capturing this.
May 11, 2006 at 10:17 am
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...
May 11, 2006 at 10:16 am
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.
May 11, 2006 at 10:15 am
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...
May 11, 2006 at 10:13 am
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
May 11, 2006 at 10:11 am
DTS or linked server would be my suggestion.
May 11, 2006 at 10:09 am
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...
May 10, 2006 at 3:05 pm
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...
May 10, 2006 at 11:03 am
Viewing 15 posts - 33,061 through 33,075 (of 39,740 total)