I haven't messed with the maintenance plans much in BIDS, but you should be able to open them in SSMS, under the Management folder. There is a subset of SSIS...

Typically named pipes is disabled on SQL Server. I think W2K used that as the default, XP uses TCP/IP. Change the Win2K machines to TCP or allow named pipes on...

RAID 5 isn't recommended. I'd really look at R1 or R10 for this, they will give you better performance.

When you say temporary files, do you mean temp tables in tempdb...

First, why do you use those values in the HAVING clause instead of the WHERE clause?

Also, it's not really clear what's not working. If you get extra rows, then you...

It's at the NYT You need to register for it.

First, triggers are inside the transaction and putting something that needs external resources (send mail, openrowsource, etc.) is a bad idea. You are asking for lots of issues.

Insert the row...

Brandie,

No way right now. We turned off the forum search since it confused a lot of people. We're debating tomorrow am if we should turn it back on.

I'm not sure many people are fired for "interpersonal reasons". They might be let go first in a layoff, but there are plenty of people that no one likes or...

I thought personal edition wasn't licensed for server installs. I'd highly recommend you move to standard ro enterprise. detach the databases, script the logins (sp_help_revlogin) and then uninstall personal.

Be careful of mirrored backups. If the mirror fails for some reason (network errors), the local isn't completed.

Thanks for the debate and this was a can of worms. I think it affects some professions (doctors, lawyers, IT), people that don't have regular hours and can get called...

SQLBill did a good job, but I still see some missing words. (get A better idea)

As for your questions:

1. The sentences are ok, definitely need spelling/grammar checks. Missing "a", "an",...

Please don't post the questions in the subject. That's a descriptor, but the question should be repeated or stated clearly in the post.

As mentioned above, just the Workstation stuff, maybe BOL.

IF you need SSIS, install it.

Looks like you have the names wrong in the ActiveX script. While you're adding them in the order, I thought there was a name mapping.