Books Online, maximum capacity specifications: http://msdn.microsoft.com/en-us/library/ms143432.aspx

You'll need accounts in those domains with any tool. They will all require authentication. Without a trust, you'll just need to supply domain\user credentials in the other domains.

Assuming those commands are proper for PuTTY, I think the problem is that PuTTY doesn't take separate commands from the command line. Once you invoke putty, you're in it's shell,...

the owner of the job, if I remember, doesn't do much in 2000. I think it can only be logins, and I've just used SA as the login.

It seems...

Richard,

Excellent points, and some of that is trying to be addressed with Sharepoint integration. I'd agree there are issues, but that's not a reason to ignore Excel, especially when a...

http://www.sqlservercentral.com/articles/Clustering/65994/

http://www.sqlservercentral.com/articles/Clustering/66246/

Very well put, Jeff. There are multiple ways to handle inventory, and modeling is not something you learn in a day. It takes time, and if you've never done it,...

I'd tend to agree with Jeff. You can secure this pretty well these days, and in limited use, it makes sense. I wouldn't want someone to have unbridled access, especially...

Are you sure the table contains only 7000 rows? Or are you looking at rows that have some value with a where clause?

If there are only 7000 rows, I'm confused...

Data warehouses tend to grow pretty well. Why both to shrink? If you needed 45GB at one point, won't you need it again relatively soon?

If there is a space issue,...

Everyone is replaceable, but not easily replaceable and I'd like to think that most people have value at their jobs. If you treat them as if they are easily replaceable...

Dell had some cheap ones, and you could check eBay for something used.

You can use virtual servers and share the disks that way.

You could use snapshots if you have Enterprise edition, but if you need to restore or something happens you'll lose them.

A better solution would be calculate this stuff and store...

You can write triggers to catch updates and deletes on specific tables if you want.

You can limit SQL using the affinity mask, but AFAIK, this doesn't affect licnensing. If you have 2 CPU sockets filled in the machine you need to license both of...